In a certain customer environment I have to change the OS password for the user which is used to access the MySQL database every 6 months.
After changing this password I could not successfully start the SafeLinx server and could see the following error message in the wg.log:
[LOG] DBManager::connect – WGDATA (entry)
[LOG] DBManager: connecting ‘WGDB’ to ‘WGDATA’
[DEBUG] DBManager: using connection string “Driver={MySQL ODBC 8.0 Unicode Driver};Server=v….;Database=WGDATA;UID=WGDB;PWD=;SslMode=Disab
[ERROR] DBManager: Failed connecting to database WGDATA with instance WGDB
(Generic error — -1)
[DEBUG] SQLGetDiagRec returns SQL_NO_DATA
[ERROR] DBManager::get_sql_error — database error report —
SQL ERROR -1 (FATAL ERROR) occurred for SQLConnect.
SQLSTATE: HY000
Native Error Code: 1045
[MySQL][ODBC 8.0(w) Driver]Access denied for user ‘WGDB’@’….’ (using password: YES)
— end error report —
So if you change the password on OS side for the user which you use to connect to you MySQL database you also have to change the password for the “connect user” on the SafeLinx database with the following command:
/opt/hcl/SafeLinx/bin/chwg “-s” “wlCfg” “-l” “Access Manager” “-g” “ch” “-a” “wpsstoredbadminpw=<new_password>” “-X”
Afterwards the HCL SafeLinx service could be started without any troubles.
