problem with remote mysql and modsec

[uadm]

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:

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]

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.