Difference between revisions of "Software Collections:MySQL55"

From SME Server
Jump to navigationJump to search
Line 1: Line 1:
This page purpose is to help configuring mysql55 on SME8.
+
== Description ==
 +
This contrib purpose is to help configuring mysql55 on SME8 and SME9 using software collection.
  
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-".
+
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 remotly. 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  
+
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!!!
 
this RPM will allow you to have 2 versions of mysql running!!!
see also for reference: [Software_Collections:MySQL] and [MySQL55]
+
 
 +
see also for reference: [[Software_Collections:MySQL]] and [[MySQL55]]
 +
 
 
=== Version ===
 
=== Version ===
 
{{ #smeversion: smeserver-mysql55}}
 
{{ #smeversion: smeserver-mysql55}}
Line 20: Line 23:
 
  signal-event post-upgrade
 
  signal-event post-upgrade
 
  signal-event reboot
 
  signal-event reboot
 +
 +
for SME 9, still in testing you will need yum --enablerepo=smecontribs,smedev,smetest smeserver-mysql55
  
 
== Use in phpmyadmin==
 
== Use in phpmyadmin==

Revision as of 05:39, 16 February 2017

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

Contrib 9:
smeserver-mysql55
The latest version of smeserver-mysql55 is available in the SME repository, click on the version number(s) for more information.


Contrib 9:
mysql55
The latest version of mysql55 is available in the SME repository, click on the version number(s) for more information.



Maintainer

Unnilennium

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

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 .


"No open bugs found."

Changelog

Only versions released in smecontrib are listed here: