# Database connection faulted

**URL:** <https://forum.inductiveautomation.com/t/database-connection-faulted/20242>\
**Category:** Ignition\
**Created:** [October 17, 2018, 6:45pm UTC](https://forum.inductiveautomation.com/t/database-connection-faulted/20242 "2018-10-17T18:45:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![danieltalbot](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/danieltalbot/32/11201_2.png) [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\
**Post date:** [October 17, 2018, 6:45pm UTC](https://forum.inductiveautomation.com/t/database-connection-faulted/20242/1 "2018-10-17T18:45:46Z")

</div>

Trying to add a connection to a new test database. To my knowledge, everything is added correctly. The jdbc:mysql://host:port/database part is correct. The username and password are correct. Somehow it is still faulting and giving me this error:

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unable to load authentication plugin ‘caching\_sha2\_password’.)  
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)  
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:242)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:196)  
at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:998)  
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)  
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)  
Caused by: java.sql.SQLException: Unable to load authentication plugin ‘caching\_sha2\_password’.  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:923)  
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1725)  
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)  
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)  
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)  
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)  
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822)  
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)  
at sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source)  
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)  
at java.lang.reflect.Constructor.newInstance(Unknown Source)  
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)  
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)  
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)  
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)  
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)  
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)  
… 12 more

7.9.9 (b2018081621)  
Oracle Corporation 1.8.0\_171

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 18, 2018, 3:44pm UTC](https://forum.inductiveautomation.com/t/database-connection-faulted/20242/2 "2018-10-18T15:44:42Z")

</div>

Try either a: [upgrading your JDBC driver](https://docs.inductiveautomation.com/display/DOC79/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-UpgradingaJDBCDriver) with the latest [MySQL JDBC driver](https://dev.mysql.com/downloads/connector/j/8.0.html), or b: starting from a “clean” install of 7.9.9 (don’t restore a .gwbk onto it) and verify if you can get a connection.