Update Separate Database IP Address

Operating System & Version
Centos
cPanel & WHM Version
94.0.4

Michael Legg

Well-Known Member
Mar 2, 2015
67
4
58
New Farm, Queensland, Australi
cPanel Access Level
Website Owner
Hi Guys

We've just had to change our local network address range and we have a separate MariaDB database server.

I logged into mysql and updated all of the hostnames in mysql.user and ran FLUSH PRIVILEGES, but the web sites still can't connect to the db server.

I also tried to update the connection in WHM from the Manage MySQL® Profiles page, but was unable to update the existing profile, so I tried to create a new profile with a new user by providing the root SSH credentials.

But I get this error ...

Failed to “create” Remote MySQL profile. 1 error occurred.

Failed to make an SSH connection to the remote server because of an error: Failed to execute “/bin/cat /root/.my.cnf 2>/dev/null” on remote host “10.x.x.x” because of an error: The system experienced a timeout error while it attempted to connect to “10.x.x.x”: timeout.

I can ping the db server from the cPanel server and visa-versa.

So I don't know what could be causing the problem.
 
Last edited:

ankeshanand

Well-Known Member
Mar 29, 2021
203
61
103
India
cPanel Access Level
Root Administrator
Hi Guys

We've just had to change our local network address range and we have a separate MariaDB database server.

I logged into mysql and updated all of the hostnames in mysql.user and ran FLUSH PRIVILEGES, but the web sites still can't connect to the db server.

I also tried to update the connection in WHM from the Manage MySQL® Profiles page, but was unable to update the existing profile, so I tried to create a new profile with a new user by providing the root SSH credentials.

But I get this error ...

Failed to “create” Remote MySQL profile. 1 error occurred.

Failed to make an SSH connection to the remote server because of an error: Failed to execute “/bin/cat /root/.my.cnf 2>/dev/null” on remote host “10.x.x.x” because of an error: The system experienced a timeout error while it attempted to connect to “10.x.x.x”: timeout.

I can ping the db server from the cPanel server and visa-versa.

So I don't know what could be causing the problem.
Most probable cause of Timeouts is Firewall or Service not occupied. Check lsof -i:22 if Service is occupied. Next, Go to any online tool and check if port is open and accessible.
 
  • Like
Reactions: cPRex