Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default Mysql Failed error after setting up Remote MySQL server

    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.

  2. #2
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default

    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").

  3. #3
    Member Shinichi Kato's Avatar
    Join Date
    Mar 2005
    Location
    Saitama-ken,japan
    Posts
    73

    Wink

    Copy & Past MySQL error log here.

    Code:
    last /var/lib/mysql/hostname.err
    Service of my company is "free web server" "shared web server" "dedicated web server" in Japan.
    [ADSV.JP]FREE WEB SERVER
    Total Media Studio Help Forum
    TMS at GoogleMap

  4. #4
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default

    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

  5. #5
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default

    Code:
    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.

  6. #6
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default

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

  7. #7
    ReB
    ReB is offline
    Member
    Join Date
    Aug 2006
    Posts
    20

    Default

    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!!

Similar Threads & Tags
Similar threads

  1. Setting up remote MySQL server
    By fugtruck in forum E-mail Discussions
    Replies: 0
    Last Post: 05-05-2011, 03:02 PM
  2. Setting up remote mysql server. I got this error
    By DeadManWalking in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 01-08-2007, 08:55 AM
  3. Howto Request: setting up a remote MySQL server
    By protocol in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 04-26-2006, 01:25 AM
  4. Setting up remote MySQL Server
    By PlanetHosted in forum cPanel and WHM Discussions
    Replies: 7
    Last Post: 03-14-2006, 09:56 PM
  5. Setting up a Remote MySQL Server
    By cvan in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-27-2005, 04:40 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube