Sathish V created FINERACT-1928:
-----------------------------------
Summary: HikariPool-2 - Exception during pool initialization,
Error: 1045-28000: Access denied for user 'root'@'10.128.0.2'
Key: FINERACT-1928
URL: https://issues.apache.org/jira/browse/FINERACT-1928
Project: Apache Fineract
Issue Type: Bug
Components: Migration Scripts
Affects Versions: 1.8.3
Environment: Debian Linux
Reporter: Sathish V
Tried building up and setting the newest code 1.8.x and got this issue.. not
sure from where it picks up the root [db connect is happeing for pool1 but
fails for pool2.. any idea where pool2 config is?]
2023-05-04 18:26:17.026 - INFO 10641 --- [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8443 (https)
2023-05-04 18:26:17.093 - INFO 10641 --- [ main]
o.a.coyote.http11.Http11Nio2Protocol : Initializing ProtocolHandler
["https-jsse-nio2-8443"]
2023-05-04 18:26:17.094 - INFO 10641 --- [ main]
o.apache.catalina.core.StandardService : Starting service [Tomcat]
2023-05-04 18:26:17.095 - INFO 10641 --- [ main]
org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache
Tomcat/9.0.73]
2023-05-04 18:26:17.525 - INFO 10641 --- [ main]
o.a.c.c.C.[.[.[/fineract-provider] : Initializing Spring embedded
WebApplicationContext
2023-05-04 18:26:17.532 - INFO 10641 --- [ main]
w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext:
initialization completed in 34378 ms
2023-05-04 18:26:19.801 - INFO 10641 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2023-05-04 18:26:20.226 - INFO 10641 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
Database is up to date, no changesets to execute
UPDATE SUMMARY
Run: 0
Previously run: 49
Filtered out: 1287
-------------------------------
Total change sets: 1336
FILTERED CHANGE SETS SUMMARY
Context mismatch: 1287
2023-05-04 18:26:38.884 - INFO 10641 --- [ main]
a.f.i.c.s.m.TenantDatabaseUpgradeService : Tenant store upgrade finished
2023-05-04 18:26:38.885 - INFO 10641 --- [ main]
a.f.i.c.s.m.TenantDatabaseUpgradeService : Upgrading all tenants
2023-05-04 18:26:38.931 - INFO 10641 --- [ main]
a.f.i.c.s.m.TenantDatabaseUpgradeService : Upgrade for tenant default has
started
isTablePresent: DATABASECHANGELOG
Datasource details: HikariDataSource (null)
2023-05-04 18:26:39.644 - INFO 10641 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Starting...
2023-05-04 18:26:39.652 - WARN 10641 --- [ main]
o.m.jdbc.message.server.ErrorPacket : Error: 1045-28000: Access denied for
user 'root'@'10.128.0.2' (using password: YES)
2023-05-04 18:26:40.659 -ERROR 10641 --- [ main]
com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Exception during pool
initialization.
java.sql.SQLInvalidAuthorizationSpecException: (conn=4275) Access denied for
user 'root'@'10.128.0.2' (using password: YES)
at
org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:286)
at
org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370)
at
org.mariadb.jdbc.client.impl.ConnectionHelper.authenticationHandler(ConnectionHelper.java:309)
at
org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:189)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)