Layer7 API Management

Hello,

I'm trying to configure and execute the audit purge script 'audit_purge.sh' provided by CA, on our developpement server, in order to purge old audit records automatically.

https://support.ca.com/us/knowledge-base-articles.tec0000001279.html

I have following error message:

ERROR 1045 (28000) : Access denied for user 'gateway'@localhost' (using password: YES)

cf. printscreens attached.

How can we solve this issue ?

Thanks in advance,

Regards

Bruno

I think you've posted this to the wrong community. Are you looking for CA Asset Management or CA Application Performance Management?

Dear Bruno:

     To get the correct answer fast, please post in the correct community. Based on what I found in that KB and in searching, I am moving it to the API Community. We look forward to responding to APM issues should one arise. Leaving you in great hands here!

Thanks

Hal German

Hello,

The application is CA API Gateway.

We fixed the issue, by resetting the password, and setting the proper permissions to the database user.

GRANT SELECT ON ssg.audit_main TO 'ssg'@'localhost';

GRANT SELECT ON ssg.audit_admin TO 'ssg'@'localhost';

GRANT SELECT ON ssg.audit_detail_params TO 'ssg'@'localhost';

GRANT SELECT ON ssg.audit_system TO 'ssg'@'localhost';

GRANT SELECT ON ssg.audit_message TO 'ssg'@'localhost';

GRANT SELECT ON ssg.audit_detail TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_main TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_admin TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_detail_params TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_system TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_message TO 'ssg'@'localhost';

GRANT INSERT ON ssg.audit_detail TO 'ssg'@'localhost';

Thanks

Regards,

Bruno