Update Separate Database IP Address

Michael Legg

• April 16, 2021 19:49

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

  • April 17, 2021 05:32

  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.

  0
• 

  cPRex Jurassic Moderator

  • April 19, 2021 16:12

  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.

  0
• 

  Michael Legg

  • April 20, 2021 05:14

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

  0
• 

  cPRex Jurassic Moderator

  • April 20, 2021 14:19

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

  0

Please sign in to leave a comment.