Connection refused

[Amritha M]

While running the tomcat it shows login page and when entering the id and password gets error message as "sorry something went wrong", here by attached the error message in the terminal.

D:/Killbill/Aapache-tomcat-8.5.59-windows-x64/apache-tomcat-8.5.59/webapps2/ROOT/WEB-INF/gems/gems/activerecord-7.0.8/lib/active_record/model_schema.rb:160: warning: previous definition of inheritance_column= was here
System property java.security.egd has not been set, this may cause some requests to hang because of a lack of entropy. You should probably set it to 'file:/dev/./urandom'
2024-04-06T14:51:36,223+0000 lvl='WARN', log='DefaultQueueLifecycle', th='notifications-lifecycle-dispatcher-th-1', xff='', rId='', tok='', aRId='', tRId='', notifications: Thread notifications-lifecycle-dispatcher-th-1 got DBIException exception:
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLTransientConnectionException: main - Connection is not available, request timed out after 10018ms.
        at org.skife.jdbi.v2.DBI.open(DBI.java:251)
        at org.skife.jdbi.v2.DBI.open(DBI.java:219)
        at org.skife.jdbi.v2.DBI.withHandle(DBI.java:300)
        at org.skife.jdbi.v2.DBI.inTransaction(DBI.java:328)
        at org.killbill.queue.DBBackedQueue.executeTransaction(DBBackedQueue.java:343)
        at org.killbill.queue.DBBackedQueueWithPolling.getReadyEntries(DBBackedQueueWithPolling.java:71)
        at org.killbill.notificationq.NotificationQueueDispatcher.getReadyNotifications(NotificationQueueDispatcher.java:287)
        at org.killbill.notificationq.NotificationQueueDispatcher.doDispatchEvents(NotificationQueueDispatcher.java:217)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable.dispatchEvents(DefaultQueueLifecycle.java:335)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable$1.callback(DefaultQueueLifecycle.java:305)
        at org.killbill.queue.DefaultQueueLifecycle.withHandlingRuntimeException(DefaultQueueLifecycle.java:367)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable.run(DefaultQueueLifecycle.java:301)
        at org.killbill.commons.concurrent.WrappedRunnable.run(WrappedRunnable.java:49)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransientConnectionException: main - Connection is not available, request timed out after 10018ms.
        at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
        at net.sf.log4jdbc.sql.jdbcapi.DataSourceSpy.getConnection(DataSourceSpy.java:147)
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:40)
        at org.skife.jdbi.v2.DBI$4.execute(DBI.java:230)
        at org.skife.jdbi.v2.DBI$4.execute(DBI.java:227)
        at org.killbill.commons.profiling.Profiling.executeWithProfiling(Profiling.java:35)
        at org.skife.jdbi.v2.DBI.open(DBI.java:227)
        ... 15 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=127.0.0.1)(port=3306)(type=primary). Connection refused: connect
        at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:136)
        at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:103)
        at org.mariadb.jdbc.Driver.connect(Driver.java:70)
        at org.mariadb.jdbc.MariaDbDataSource.getConnection(MariaDbDataSource.java:100)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733)
        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        ... 3 common frames omitted
Caused by: java.net.ConnectException: Connection refused: connect
        at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method)
        at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)
        at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
        at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
        at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
        at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
        at java.base/java.net.Socket.connect(Socket.java:591)
        at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:130)
        ... 12 common frames omitted
2024-04-06T14:51:46,243+0000 lvl='WARN', log='DefaultQueueLifecycle', th='notifications-lifecycle-dispatcher-th-1', xff='', rId='', tok='', aRId='', tRId='', notifications: Thread notifications-lifecycle-dispatcher-th-1 got DBIException exception:
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLTransientConnectionException: main - Connection is not available, request timed out after 10003ms.
        at org.skife.jdbi.v2.DBI.open(DBI.java:251)
        at org.skife.jdbi.v2.DBI.open(DBI.java:219)
        at org.skife.jdbi.v2.DBI.withHandle(DBI.java:300)
        at org.skife.jdbi.v2.DBI.inTransaction(DBI.java:328)
        at org.killbill.queue.DBBackedQueue.executeTransaction(DBBackedQueue.java:343)
        at org.killbill.queue.DBBackedQueueWithPolling.getReadyEntries(DBBackedQueueWithPolling.java:71)
        at org.killbill.notificationq.NotificationQueueDispatcher.getReadyNotifications(NotificationQueueDispatcher.java:287)
        at org.killbill.notificationq.NotificationQueueDispatcher.doDispatchEvents(NotificationQueueDispatcher.java:217)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable.dispatchEvents(DefaultQueueLifecycle.java:335)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable$1.callback(DefaultQueueLifecycle.java:305)
        at org.killbill.queue.DefaultQueueLifecycle.withHandlingRuntimeException(DefaultQueueLifecycle.java:367)
        at org.killbill.queue.DefaultQueueLifecycle$DispatcherRunnable.run(DefaultQueueLifecycle.java:301)
        at org.killbill.commons.concurrent.WrappedRunnable.run(WrappedRunnable.java:49)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransientConnectionException: main - Connection is not available, request timed out after 10003ms.
        at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
        at net.sf.log4jdbc.sql.jdbcapi.DataSourceSpy.getConnection(DataSourceSpy.java:147)
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:40)
        at org.skife.jdbi.v2.DBI$4.execute(DBI.java:230)
        at org.skife.jdbi.v2.DBI$4.execute(DBI.java:227)
        at org.killbill.commons.profiling.Profiling.executeWithProfiling(Profiling.java:35)
        at org.skife.jdbi.v2.DBI.open(DBI.java:227)
        ... 15 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=127.0.0.1)(port=3306)(type=primary). Connection refused: connect
        at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:136)
        at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:103)
        at org.mariadb.jdbc.Driver.connect(Driver.java:70)
        at org.mariadb.jdbc.MariaDbDataSource.getConnection(MariaDbDataSource.java:100)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733)
        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        ... 3 common frames omitted
Caused by: java.net.ConnectException: Connection refused: connect
        at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method)
        at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107)
        at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399)
        at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242)
        at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224)
        at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
        at java.base/java.net.Socket.connect(Socket.java:591)
        at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:130)
        ... 12 common frames omitted

[Reshma Bidikar]

Hello,

Could you please check if the KB database is configured as explained at  https://docs.killbill.io/latest/getting_started#_database_configuration_kill_bill and if the MySQL server running?

Regards,

Reshma