The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

problem with remote mysql and modsec

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

  1. uadm

    uadm Well-Known Member

    Joined:
    May 19, 2003
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page