AnsweredAssumed Answered

CA API Gateway DB user(gateway) password reset

Question asked by Nikunj_Padhiyar on Jul 3, 2018
Latest reply on Jul 5, 2018 by Nikunj_Padhiyar

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 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?