Changes

From SME Server
Jump to navigationJump to search

Software Collections:MySQL55 (view source)

Revision as of 02:15, 20 May 2014

3,648 bytes added ,  02:15, 20 May 2014
Created page with "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..."
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'
$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
Unnilennium
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,250

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/24252"

Navigation menu