| Line 20: |
Line 20: |
| | | | |
| | ==Installation== | | ==Installation== |
| − | for SME9 and SME8 | + | for SME8 |
| | yum --enablerepo=smecontribs smeserver-mysql55 | | yum --enablerepo=smecontribs smeserver-mysql55 |
| | signal-event post-upgrade | | signal-event post-upgrade |
| | signal-event reboot | | signal-event reboot |
| | | | |
| | + | for SME9 |
| | + | {{:Software_Collections_Repositories|transcludesection=SME9}} |
| | + | yum --enablerepo=smecontribs,centos-sclo-rh smeserver-mysql55 |
| | + | signal-event post-upgrade |
| | + | signal-event reboot |
| | | | |
| | == command line == | | == command line == |
| Line 39: |
Line 44: |
| | service mysql55-mysqld start | | service mysql55-mysqld start |
| | | | |
| − | == Use in phpmyadmin for SME8 ==
| |
| − | 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 === | | === Bugs === |
