I am getting below error/warning in API gateway audit logs:
2018-07-02T16:50:12.812+0100 WARNING 100 com.l7tech.server.cluster.DatabaseReplicationMonitor: 2380: Error accessing host/database <hostname>/ssg: Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'gateway'@'<hostname>' (using password: YES)
How can we reset the password of "gateway"(DB user) user? We have installed API Gateway on appliance.
I have tried to change the password using below methods but no luck:
1) Executing below query on mysql of API gateway:
ALTER USER 'gateway'@'<hostname>' IDENTIFIED BY '<password>';
Getting error as: Mysql query error.
2) Via resetadmin.sh script which is present under /opt/SecureSpan/Appliance/bin directory.
Haven't got any error but still getting the same above error in logs.
3) Through ssgconfig UI, by selecting options:
2 - Display CA API Gateway Configuration meu
8 - Reset Admin password
Getting error as: "The administrative username, 'gateway', does not exist."
Also tried with gateway@hostname however no luck.
Have I missed something? Can anybody help me to resolve the above mentioned error in logs?