Software Collections:MySQL55

From SME Server
Jump to navigationJump to search

This page purpose is to help configuring mysql55 on SME8.

most of configuration options explained for mysql here : http:wiki.contribs.org/MySQL are also available for mysql55 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql55-"

Installation

yum --enablerepo=smedev smeserver-mysql55
signal-event post-upgrade
signal-event reboot


Use in phpmyadmin

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