Software Collections:MySQL55
Description
This contrib purpose is to help configuring mysql55 on SME8 and SME9 using software collection.
Most of configuration options are explained for mysql here : MySQL are also available for mysql55 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql55-".
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3307 locally. You then will need to open port to 3307 to access remotely. Also if you want another port you need to define mysql55-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
this RPM will allow you to have 2 versions of mysql running!!!
see also for reference: Software_Collections:MySQL and MySQL55
Version
Maintainer
Installation
yum --enablerepo=smecontribs smeserver-mysql55 signal-event post-upgrade signal-event reboot
for SME 9, still in testing you will need yum --enablerepo=smecontribs,smedev,smetest smeserver-mysql55
command line
/opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock
Resetting the MySQL root password
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user.
service mysql55-mysqld stop expand-template /root/.my.cnf expand-template /var/service/mysql55-mysqld/set.password /opt/rh/mysql55/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql55.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql55-mysqld/set.password service mysql55-mysqld start
Use in phpmyadmin
this way you will be avle to access both installation of mysql with your phpmyadmin contrib.
mkdir --parent /etc/e-smith/templates-custom/etc/phpMyAdmin/config.inc.php/
then
vim /etc/e-smith/templates-custom/etc/phpMyAdmin/config.inc.php/11config
and paste this :
/* Server MYSQL55 localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql55.sock';
$cfg['Servers'][$i]['compress'] = false;
# standalone or login mode
$scriptname=end(explode('/',$_SERVER['PHP_SELF']));
$scriptpath=str_replace($scriptname,"",$_SERVER['PHP_SELF']);
# standalone login part
{
my $adminaccess = ($phpmyadmin{'adminaccess'} || 'enabled');
my $multiaccess = ($phpmyadmin{'multiaccess'} || 'disabled');
if (("$adminaccess" eq "enabled"))
{
$OUT .="if (\$scriptpath==\"/phpmyadmin/\" && \$_SERVER['PHP_AUTH_USER']=='admin')\n";
$OUT .="{\n";
$OUT .="\$cfg['Servers'][\$i]['auth_type'] = 'config';\n";
$OUT .="\$cfg['Servers'][\$i]['user'] = 'root';\n";
open (PW, "/etc/openldap/ldap.pw")
|| die "Could not read LDAP password.\n";
my $pw = <PW>;
chomp ($pw);
close PW;
$OUT .="\$cfg['Servers'][\$i]['password'] = '$pw';\n";
$OUT .="}";
}
else
{
$OUT .="# standelaone admin configuration disabled";
}
}
# end of standalone login part
# multiuser login part
{
my $adminaccess = ($phpmyadmin{'adminaccess'} || 'enabled');
my $multiaccess = ($phpmyadmin{'multiaccess'} || 'disabled');
$OUT .="\n";
if (("$multiaccess" eq "enabled") && ("$adminaccess" eq "enabled"))
{
$OUT .="if (\$scriptpath==\"/phpmyadmin-multi/\")\n";
$OUT .="{\n";
}
if (("$multiaccess" eq "enabled"))
{
$OUT .="\$cfg['Servers'][\$i]['auth_type'] = 'cookie';\n";
my $secret = ${'httpd-admin'}{TKTAuthSecret} || "34322500-7330-4400-423A-3A00434F5245";
$OUT .="\$cfg['blowfish_secret'] = '$secret';\n";
}
else
{
$OUT .="# multiuser disabled\n";
}
if (("$multiaccess" eq "enabled") && ("$adminaccess" eq "enabled"))
{
$OUT .="}\n";
}
}
# end of multiuser login part
$cfg['Servers'][$i]['controluser'] = "";
$cfg['Servers'][$i]['controlpass'] = "";
$cfg['Servers'][$i]['only_db'] = "";
$cfg['Servers'][$i]['hide_db'] = "";
$cfg['Servers'][$i]['verbose'] = 'Mysql55';// here is the name as it appears in phpmyadmin
$cfg['Servers'][$i]['pmadb'] = "";
$cfg['Servers'][$i]['bookmarktable'] = "";
$cfg['Servers'][$i]['relation'] = "";
$cfg['Servers'][$i]['table_info'] = "";
$cfg['Servers'][$i]['table_coords'] = "";
$cfg['Servers'][$i]['pdf_pages'] = "";
$cfg['Servers'][$i]['column_info'] = "";
$cfg['Servers'][$i]['history'] = "";
$cfg['Servers'][$i]['verbose_check'] = TRUE;
$cfg['Servers'][$i]['AllowRoot'] = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']="";
$cfg['Servers'][$i]['AllowDeny']['rules']= array();
$cfg['Servers'][$i]['AllowNoPassword']= FALSE;
$cfg['Servers'][$i]['designer_coords']= "";
$cfg['Servers'][$i]['bs_garbage_threshold']= 50;
$cfg['Servers'][$i]['bs_repository_threshold']= '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout']= 600;
$cfg['Servers'][$i]['bs_temp_log_threshold']= '32M';
after just do
expand-template /etc/phpMyAdmin/config.inc.php
Bugs
Please raise bugs under the SME-Contribs section in bugzilla and select the smeserver-mysql55 component or use this link .
Changelog
Only versions released in smecontrib are listed here: