cPanel remote mysql server [urgent]

prixone

Well-Known Member
Mar 4, 2004
111
3
168
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
Aug 2 09:20:01 host lsb_log_message: MySQL PID file could not be found! failed
Aug 2 09:20:36 host lsb_log_message: failed
 
Last edited:

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,608
77
458
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?
 

prixone

Well-Known Member
Mar 4, 2004
111
3
168
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