Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 12th August 2011, 13:06
andrercmeira andrercmeira is offline
Junior Member
 
Join Date: Aug 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default GluterFS not start mysql

Hi,

I follow tuturial for install replicante server, step-by-step, master server is ok, all service is start, but in the slave server no start mysql.

it only result on syslog

Code:
Aug 12 08:02:30 johan mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [Note] Plugin 'FEDERATED' is disabled.
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [Note] Plugin 'InnoDB' is disabled.
Aug 12 08:02:30 johan mysqld: /usr/sbin/mysqld: Incorrect file format 'plugin'
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [ERROR] Can't start server : Bind on unix socket: Permission denied
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [ERROR] Aborting
Aug 12 08:02:30 johan mysqld: 
Aug 12 08:02:30 johan mysqld: 110812  8:02:30 [Note] /usr/sbin/mysqld: Shutdown complete
Aug 12 08:02:30 johan mysqld: 
Aug 12 08:02:30 johan mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Aug 12 08:02:44 johan /etc/init.d/mysql[23534]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 12 08:02:44 johan /etc/init.d/mysql[23534]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 12 08:02:44 johan /etc/init.d/mysql[23534]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 12 08:02:44 johan /etc/init.d/mysql[23534]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
obs: in two server I running mysql 5.1.49 on debian 6.0.2.1.a
Reply With Quote
Sponsored Links
  #2  
Old 12th August 2011, 13:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,509
Thanks: 815
Thanked 5,268 Times in 4,130 Posts
Default

Please post the output of:

ls -la /var/lib/mysql

from the slave server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 12th August 2011, 13:16
andrercmeira andrercmeira is offline
Junior Member
 
Join Date: Aug 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

in the slave

Code:
drwxr-xr-x  7 ntp   ntp       4096 Ago 12 08:02 .
drwxr-xr-x 43 root  root      4096 Ago 11 23:59 ..
drwx------  2 mysql mysql     4096 Ago  9 15:32 cadmizaz_web
drwx------  2 mysql mysql     4096 Ago 10 10:19 dbispconfig
-rw-r--r--  1 root  root         0 Ago  6 12:07 debian-5.1.flag
drwx------  2 mysql mysql     4096 Ago 10 14:54 gerencia_izaz
-rw-rw----  1 mysql mysql 10485760 Ago 12 00:00 ibdata1
-rw-rw----  1 mysql mysql  5242880 Ago 12 00:00 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Ago  6 12:07 ib_logfile1
drwx------  2 mysql root      4096 Ago  6 12:08 mysql
-rw-------  1 root  root         6 Ago  6 12:08 mysql_upgrade_info
in the master

Code:
drwxr-xr-x  6 ntp   ntp       4096 Ago 12 08:02 .
drwxr-xr-x 52 root  root      4096 Ago 12 00:00 ..
drwx------  2 mysql mysql     4096 Ago  9 15:32 cadmizaz_web
drwx------  2 mysql mysql     4096 Ago 10 10:19 dbispconfig
-rw-r--r--  1 root  root         0 Ago  6 12:07 debian-5.1.flag
drwx------  2 mysql mysql     4096 Ago 10 14:54 gerencia_izaz
-rw-rw----  1 mysql mysql 10485760 Ago 12 00:00 ibdata1
-rw-rw----  1 mysql mysql  5242880 Ago 12 00:00 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Ago  6 12:07 ib_logfile1
drwx------  2 mysql root      4096 Ago  6 12:08 mysql
-rw-------  1 root  root         6 Ago  6 12:08 mysql_upgrade_info
Reply With Quote
  #4  
Old 12th August 2011, 13:17
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,509
Thanks: 815
Thanked 5,268 Times in 4,130 Posts
Default

Is it possible to start mysql on the slave when you stop mysql on the master?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 12th August 2011, 13:22
andrercmeira andrercmeira is offline
Junior Member
 
Join Date: Aug 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes, in the master

Code:
root@anna:/var/lib# /etc/init.d/mysql status
/usr/bin/mysqladmin  Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on i486
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.49-3
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 7 hours 16 min 53 sec

Threads: 2  Questions: 14345  Slow queries: 0  Opens: 1001  Flush tables: 1  Open tables: 64  Queries per second avg: 0.547.
after restart:

Code:
root@anna:/var/lib# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
root@anna:/var/lib# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Code:
root@anna:/var/lib# /etc/init.d/mysql status
/usr/bin/mysqladmin  Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on i486
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.49-3
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 1 min 9 sec

Threads: 1  Questions: 512  Slow queries: 0  Opens: 958  Flush tables: 1  Open tables: 64  Queries per second avg: 7.420.
Reply With Quote
  #6  
Old 12th August 2011, 14:04
andrercmeira andrercmeira is offline
Junior Member
 
Join Date: Aug 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I see a little differ in passwd file...

in master is one number for mysql user, in slave is other

in the master:
Code:
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/bin/sh
bin:x:2:2:bin:/bin:/bin/sh
sys:x:3:3:sys:/dev:/bin/sh
sync:x:4:65534:sync:/bin:/bin/sync
games:x:5:60:games:/usr/games:/bin/sh
man:x:6:12:man:/var/cache/man:/bin/sh
lp:x:7:7:lp:/var/spool/lpd:/bin/sh
mail:x:8:8:mail:/var/mail:/bin/sh
news:x:9:9:news:/var/spool/news:/bin/sh
uucp:x:10:10:uucp:/var/spool/uucp:/bin/sh
proxy:x:13:13:proxy:/bin:/bin/sh
www-data:x:33:33:www-data:/var/www:/bin/sh
backup:x:34:34:backup:/var/backups:/bin/sh
list:x:38:38:Mailing List Manager:/var/list:/bin/sh
irc:x:39:39:ircd:/var/run/ircd:/bin/sh
gnats:x:41:41:Gnats Bug-Reporting System (admin):/var/lib/gnats:/bin/sh
nobody:x:65534:65534:nobody:/nonexistent:/bin/sh
libuuid:x:100:101::/var/lib/libuuid:/bin/sh
Debian-exim:x:101:103::/var/spool/exim4:/bin/false
statd:x:102:65534::/var/lib/nfs:/bin/false
sshd:x:103:65534::/var/run/sshd:/usr/sbin/nologin
izaz:x:1000:1000:izaz,,,:/home/izaz:/bin/bash
ntp:x:104:106::/home/ntp:/bin/false
postfix:x:105:108::/var/spool/postfix:/bin/false
mysql:x:106:110:MySQL Server,,,:/var/lib/mysql:/bin/false
clamav:x:107:111::/var/lib/clamav:/bin/false
amavis:x:108:112:AMaViS system user,,,:/var/lib/amavis:/bin/sh
messagebus:x:109:113::/var/run/dbus:/bin/false
bind:x:110:114::/var/cache/bind:/bin/false
vmail:x:5000:5000::/var/vmail:/bin/sh
getmail:x:5001:5001::/etc/getmail:/bin/sh
ispapps:x:5002:5003::/var/www/apps:/bin/sh
ispconfig:x:5003:5004::/usr/local/ispconfig:/bin/sh
web1:x:5004:5005::/var/www/clients/client1/web1/./home/web1:/bin/false
admizaz_izaz:x:5004:5005::/var/www/clients/client1/web1/./home/admizaz_izaz:/usr/sbin/jk_chrootsh
web2:x:5005:5006::/var/www/clients/client2/web2/./home/web2:/bin/false
gerenciaizaz:x:5004:5005::/var/www/clients/client1/web1/./home/gerenciaizaz:/usr/sbin/jk_chrootsh
web3:x:5006:5006::/var/www/clients/client2/web3:/bin/false
in the slave

Code:
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/bin/sh
bin:x:2:2:bin:/bin:/bin/sh
sys:x:3:3:sys:/dev:/bin/sh
sync:x:4:65534:sync:/bin:/bin/sync
games:x:5:60:games:/usr/games:/bin/sh
man:x:6:12:man:/var/cache/man:/bin/sh
lp:x:7:7:lp:/var/spool/lpd:/bin/sh
mail:x:8:8:mail:/var/mail:/bin/sh
news:x:9:9:news:/var/spool/news:/bin/sh
uucp:x:10:10:uucp:/var/spool/uucp:/bin/sh
proxy:x:13:13:proxy:/bin:/bin/sh
www-data:x:33:33:www-data:/var/www:/bin/sh
backup:x:34:34:backup:/var/backups:/bin/sh
list:x:38:38:Mailing List Manager:/var/list:/bin/sh
irc:x:39:39:ircd:/var/run/ircd:/bin/sh
gnats:x:41:41:Gnats Bug-Reporting System (admin):/var/lib/gnats:/bin/sh
nobody:x:65534:65534:nobody:/nonexistent:/bin/sh
libuuid:x:100:101::/var/lib/libuuid:/bin/sh
Debian-exim:x:101:103::/var/spool/exim4:/bin/false
sshd:x:103:65534::/var/run/sshd:/usr/sbin/nologin
izaz:x:1000:1000:izaz,,,:/home/izaz:/bin/bash
ntp:x:104:105::/home/ntp:/bin/false
mysql:x:106:106:MySQL Server,,,:/var/lib/mysql:/bin/false
postfix:x:105:108::/var/spool/postfix:/bin/false
clamav:x:107:110::/var/lib/clamav:/bin/false
amavis:x:108:111:AMaViS system user,,,:/var/lib/amavis:/bin/sh
messagebus:x:109:112::/var/run/dbus:/bin/false
bind:x:110:113::/var/cache/bind:/bin/false
vmail:x:5000:5000::/var/vmail:/bin/sh
getmail:x:5001:5001::/etc/getmail:/bin/sh
ispapps:x:5002:5003::/var/www/apps:/bin/sh
ispconfig:x:5003:5004::/usr/local/ispconfig:/bin/sh
but if edit this file rest of system not is functional, if i restart machine user id change for original

Last edited by andrercmeira; 12th August 2011 at 14:17.
Reply With Quote
  #7  
Old 12th August 2011, 14:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,509
Thanks: 815
Thanked 5,268 Times in 4,130 Posts
Default

This is most likely the reason for the problem. What is the ID of the mysql group on master and slave.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 12th August 2011, 15:04
andrercmeira andrercmeira is offline
Junior Member
 
Join Date: Aug 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

in master original id is 106 in slave original id is 104
Reply With Quote
  #9  
Old 15th September 2011, 23:41
AlexGer83 AlexGer83 is offline
Junior Member
 
Join Date: Sep 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Exclamation MySQL Server won't start (Multiserver-Setup -> Slave Server))

Hi and thank's for this howto: Installing A Web, Email And MySQL Database Cluster (Mirror) On Debian 5.0 With ISPConfig 3.

I have a Problem where i have to start the Slave-server's MySQL Server!

I've modified the /etc/mysql/debian.cnf file on the Slave-Server
-> replaced the original Content with the Master-Server's content


Code:
Now start the services again:
/etc/init.d/mysql start
...
Code:
root@L-SRV-2:/tmp# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
nano /var/log/syslog says:
Code:
Sep 15 23:03:40 L-SRV-2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [Note] Plugin 'FEDERATED' is disabled.
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [Note] Plugin 'InnoDB' is disabled.
Sep 15 23:03:40 L-SRV-2 mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Sep 15 23:03:40 L-SRV-2 mysqld: 110915 23:03:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Sep 15 23:03:40 L-SRV-2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 15 23:03:54 L-SRV-2 /etc/init.d/mysql[27916]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Where is the Problem?
I googled around and couldn't find any helping posts.

Thank's for help Y'all.
AlexGer83

Last edited by AlexGer83; 16th September 2011 at 00:02.
Reply With Quote
  #10  
Old 16th September 2011, 07:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Can you set a new password in debian.cnf and then try this post?
http://www.howtoforge.com/reset-forg...-root-password

But in the update statement please use debian-sys-maint instead of root:

Code:
update user set Password=PASSWORD('new-password') where user='debian-sys-maint';
flush privileges;
exit;
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Monit & Munin SamTzu HOWTO-Related Questions 1 4th May 2008 18:03
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
"Too many open files in system" problems Berry Installation/Configuration 3 10th November 2007 21:58


All times are GMT +2. The time now is 02:38.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.