The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql Failed error after setting up Remote MySQL server

Discussion in 'General Discussion' started by ReB, Mar 18, 2007.

  1. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    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. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    This is the error i get when I restart the service

     
  3. Shinichi Kato

    Shinichi Kato Well-Known Member

    Joined:
    Mar 7, 2005
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Saitama-ken,japan
    Copy & Past MySQL error log here.

    Code:
    last /var/lib/mysql/hostname.err
     
  4. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    oops sorry about that.

     
  5. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    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. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    I have twice submitted a support request regarding the problem but have yet to get a reply on what to do.
     
  7. ReB

    ReB Member

    Joined:
    Aug 10, 2006
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    My site is up and running yet whm/cpanel is showing this. :confused:


    [​IMG]


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



    Oh what joy!! :rolleyes:
     
Loading...

Share This Page