SOLVED ModSecurity™ Tools The following exception has occurred: API failure

[JerryB]

Hi,

when we click on ModSecurity™ Tools
we see the following error:
Error: The following exception has occurred: API failure: (XID Xxxx) Access denied for user 'modsec'@'XXXXXXX' (using password: YES)

XXXXXXX should be our external database server.
Where can I change the DB host?

Already tried:
[email protected] [~]# /usr/local/cpanel/scripts/setup_modsec_db
info [setup_modsec_db] Initialized ModSecurity™ database.
[email protected] [~]#

 

[cPanelMichael]

Already tried:
[email protected] [~]# /usr/local/cpanel/scripts/setup_modsec_db
info [setup_modsec_db] Initialized ModSecurity™ database.
[email protected] [~]#

Hello,

Please let us know if the following command helps:

/usr/local/cpanel/bin/modsecpass

Thank you.

 

[JerryB]

Yes, tried it, but did not fix the problem.

Running WHM 56.0 (build 17)

 

[JerryB]

Upgraded our test system to:
CLOUDLINUX 6.8 x86_64 VMware
WHM 60.0 (build 26)

Same error.

Error: The following exception has occurred: API failure: (XID XXXX) Database Connect Error: Access denied for user 'modsec'@'web02.XXXXXXXXXX.XXX(using password: YES)

 

[cPanelMichael]

Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[JerryB]

Support Request ID is: 8053645

 

[JerryB]

fixed by cpanel support.

====

update mysql.user set Host='xx.XXXXX.xx' WHERE User='modsec';

FLUSH PRIVILEGES;

use modsec;

grant all on modsec.* to [email protected];

====

 

[cPanelMichael]

I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.