Mysql Failed error after setting up Remote MySQL server

[ReB]

I have 2 servers, one for the Web (Server 1) and one for the DB (Server 2). Aside from the web, server1 also host whm/cpanel and DB for phpadsnew and roundcube. While server 2 host the main DB of the site (no cpanel).

Everything was running smoothly before.

Since cpanel can only add DB on server 1 and we wanted server 2 to host all db of all new sites, we decide to set it up as remote mysql server using WHM.

Now I'm getting this error every 9 Minutes

mysql failed @ Sun Mar 18 23:43:17 2007. A restart was attempted automagicly.

But mysql is working fine since we can still connect in all db, the site, phpadnew, roundcube but in WHM > Service Status > mysql is always reported as failed.

We tried rebooting both servers but to no avail.

I believe it does really restart mysql since, now, server 1 load shoots up to 30+ (for about 10-15 secs) when its highest used to be only 2, meaning for that short period server 1 can not connect to the db in server 2.

It all started after we set up the remote mysql server. We are sure that the setting we entered are correct.

Any ideas how we get this fixed.

[ReB]

This is the error i get when I restart the service

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").

[Shinichi Kato]

Copy & Past MySQL error log here.

last /var/lib/mysql/hostname.err

[ReB]

oops sorry about that.

070319 20:24:23 mysqld started
070319 20:24:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.24-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070319 20:24:24 [Note] /usr/sbin/mysqld: Normal shutdown

070319 20:24:26 [Note] /usr/sbin/mysqld: Shutdown complete

070319 20:24:26 mysqld ended

070319 20:24:30 mysqld started
070319 20:24:30 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.24-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070319 20:32:53 [Note] /usr/sbin/mysqld: Normal shutdown

070319 20:32:53 [Note] /usr/sbin/mysqld: Shutdown complete

070319 20:32:53 mysqld ended

070319 20:33:16 mysqld started
070319 20:33:16 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.24-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070319 20:33:17 [Note] /usr/sbin/mysqld: Normal shutdown

070319 20:33:19 [Note] /usr/sbin/mysqld: Shutdown complete

070319 20:33:21 mysqld ended

070319 20:33:33 mysqld started
070319 20:33:33 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.24-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
070319 20:41:55 [Note] /usr/sbin/mysqld: Normal shutdown

070319 20:41:57 [Note] /usr/sbin/mysqld: Shutdown complete

070319 20:41:58 mysqld ended

[ReB]

Mar 26 09:40:11 cp lsb_log_message: MySQL manager or server PID file could not be found! failed
Mar 26 09:40:13 cp lsb_log_message:  succeeded
Mar 26 09:40:31 cp last message repeated 2 times
Mar 26 09:48:53 cp pure-ftpd: (?@127.0.0.1) [INFO] New connection from 127.0.0.1
Mar 26 09:48:53 cp pure-ftpd: (?@127.0.0.1) [INFO] Logout.
Mar 26 09:48:56 cp lsb_log_message:  succeeded
Mar 26 09:49:33 cp lsb_log_message: MySQL manager or server PID file could not be found! failed
Mar 26 09:49:36 cp lsb_log_message:  succeeded
Mar 26 09:49:45 cp last message repeated 2 times
Mar 26 09:58:08 cp pure-ftpd: (?@127.0.0.1) [INFO] New connection from 127.0.0.1
Mar 26 09:58:08 cp pure-ftpd: (?@127.0.0.1) [INFO] Logout.
Mar 26 09:58:19 cp lsb_log_message:  succeeded
Mar 26 09:58:55 cp lsb_log_message: MySQL manager or server PID file could not be found! failed
Mar 26 09:58:58 cp lsb_log_message:  succeeded
Mar 26 09:59:08 cp last message repeated 2 times
Mar 26 10:07:28 cp pure-ftpd: (?@127.0.0.1) [INFO] New connection from 127.0.0.1
Mar 26 10:07:28 cp pure-ftpd: (?@127.0.0.1) [INFO] Logout.
Mar 26 10:07:35 cp lsb_log_message:  succeeded
Mar 26 10:08:12 cp lsb_log_message: MySQL manager or server PID file could not be found! failed
Mar 26 10:08:14 cp lsb_log_message:  succeeded

I really can't figure this out. MySQL is working but it keeps restarting.

[ReB]

I have twice submitted a support request regarding the problem but have yet to get a reply on what to do.

[ReB]

My site is up and running yet whm/cpanel is showing this.





And yes mysql is being 'AUTOMAGICALY' restarted every 9 minutes.



Oh what joy!!