Update Separate Database IP Address

[Michael Legg]

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.

 

[ankeshanand]

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.

 

[cPRex]

It also sounds like a firewall issue to me. I'd start with the SSH settings and get those resolved, and then move on to the database issues.

 

[Michael Legg]

You are 100% correct. I forgot about the firewall. Doh!

 

[cPRex]

I'm glad that's all it was :D