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.

cPanel remote mysql server [urgent]

Discussion in 'General Discussion' started by prixone, Aug 2, 2007.

  1. prixone

    prixone Well-Known Member

    Joined:
    Mar 4, 2004
    Messages:
    107
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    hi,

    i have done all the setup to make the remote mysql server:
    changed the /root/.my.cnf to the relative data
    updated the horde, phpMyAdmin, eximstats

    went to the WHM > SQL Services > Setup Remote MySQL server
    filled all everything change from sudo to su and inputed my root and procced

    it took a long time said few times timeout and at all said that it was complete but never worked at all.

    so i had to gather all the data from /var/lib/mysql and put it manually to the mysql server

    it is all working fine but i can't manage to WHM recognize it...

    what should i do in order to cPanel / WHM accept it ?

    the mysql server is setup on a 2nd machine at my internal lan. eth0 from both servers represente my internal lan and all the eth0 has no firewall or security.

    i am able to use the mysql server from both machines, and also from scripts and codes...

    just WHM and cPanel dont recognize it....

    also i am getting this every 5 minutes wich leads me to belive WHM is mad since it did not manage to acomplish the setup and has no mysql installed, i have turned of the warns in WHM but still getting it at /var/log/messages
     
    #1 prixone, Aug 2, 2007
    Last edited: Aug 2, 2007
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    In your /root/.my.cnf file, the host entry points to the correct ipaddress/hostname ?

    You are using the default port for MySQL on the remote server?

    On your cPanel server, SSH into it (as root), and do the following:

    Code:
    # mysql -h remote_host -u root -p
    
    Replace remote_host with the actual IP Address or hostname that is assigned to the remote MySQL server.

    You verified MySQL is running on the remote server and the GRANT statements are all correct?
     
  3. prixone

    prixone Well-Known Member

    Joined:
    Mar 4, 2004
    Messages:
    107
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    the problem was that everything i hit the setup button it changed the .my.cnf i had already configured so once i did it all i came back and re-setup it and all seems fine so far ...
    thanks
     
Loading...

Share This Page