problem with remote mysql and modsec

uadm

• December 21, 2014 07:18

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

  • December 22, 2014 15:27

  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.

  0

Please sign in to leave a comment.