Wso2 admin/admin failing after changing to mysql datasource

Question

I was facing issue while login to Carbon Management Console Version; WSO2 IS 5.10. 0 as Key Manager

Changes:

I have made Mysql database changes for WSO2AM_DB, WSO2Shared_DB,WSO2User_db in deployment.toml file. When i tried login Management Console with default admin/admin credentials, I am getting error in UI:

Login failed! Please recheck the username and password and try again.

ERROR {org.wso2.carbon.core.services.authentication.AuthenticationAdmin} - System error while Authenticating/Authorizing User : com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Also user store changes in deployment.toml cause error

Changes:

[user_store]
type = "database"

[user_store.properties]
TenantManager="org.wso2.carbon.user.core.tenant.JDBCTenantManager"
ReadOnly=false
ReadGroups=true
WriteGroups=true
scim_enabled = true

[realm_manager]
data_source = "WSO2USER_DB"

Praminda Praminda · Accepted Answer · 2020-09-08T10:58:56

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure normally means the configured database is not accessible.

Did you define the database.user configuration in the deployment.toml according to WSO2 jdbc user configuration guidelines? If this is already configured, check the configured connection url and network connectivity from WSO2-IS to userstore database.

Wso2 admin/admin failing after changing to mysql datasource

1 Answers