problem with remote mysql and modsec

uadm

Well-Known Member
May 19, 2003
97
0
156
I'd like to report a problem.

When setting up remote mysql then modsec tools link in whm is not working and giving the error:
API failure: Cpanel::DBI::Mysql connect('','modsec',...) failed: Access denied for user 'modsec'@ip.of.accessing.server

This is because when setting the remote mysql and whm moves the modsec database to the remove mysql server, the user and db permissions are set to host=remote.mysql.server and not host=ip.of.accessing.server

This can be fixed by setting:
Code:
update user set host='ip.of.accessing.server' where user='modsec'
and the same for the db table.
also we had to update the password from the password in /var/cpanel/modsec_db_pass
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello :)

Could you open a support ticket using the link in my signature so we can reproduce the issue and open an internal case if necessary? You can post the ticket number here so we can update this thread with the outcome.

Thank you.