Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

problem with remote mysql and modsec

Discussion in 'Database Discussion' started by uadm, Dec 21, 2014.

  1. uadm

    uadm Well-Known Member

    Joined:
    May 19, 2003
    Messages:
    91
    Likes Received:
    0
    Trophy Points:
    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
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,808
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice