search

ma1uta / ma1sd

Federated Matrix Identity Server (formerly fork of kamax/mxisd)
GNU Affero General Public License v3.0
167 stars 55 forks source link

No Connection to Wordpress Database #95

Open BackInBash opened 3 years ago

BackInBash commented 3 years ago

I´ve tried to setup Wordpress as Identity store. The REST Calls / Login is working perfectly fine.

But the directory search is not working as intended.

I´m using this Docker container ma1uta/ma1sd:2.4.0-amd64

The error shoes up if someone is trying to send a directory query. The SQL connection keeps crashing.

Network connection between ma1sd and the database can be established as proven here:

bash-4.4# nc wordpress_db_1 3306
J
o@UIAjmysql_native_passwordPuTTY
!▒▒#08S01Got packets out of order
bash-4.4#

So the stack trace looks like this: 

Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Performing search for 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Original request URL: http://top.level.domain/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Querying HS at http://matrix-nginx-proxy:12080/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Found 0 match(es) in HS for 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider SynapseSqlDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by display name using 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: SELECT u.name,p.displayname FROM users u JOIN profiles p ON u.name LIKE concat('@',p.user_id,':%') WHERE u.is_guest = 0 AND u.appservice_id IS NULL AND p.displayname LIKE ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Display name: found 1 match(es) for 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by 3PID using 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: select t.user_id, p.displayname from user_threepids t JOIN profiles p on t.user_id = concat('@',p.user_id,':kraftpost.eu') where t.address ilike ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Threepid: found 0 match(es) for 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider WordpressDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider - Searching users by display name using 'te'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Performing search for 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Original request URL: http://top.level.domain/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Querying HS at http://matrix-nginx-proxy:12080/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Found 0 match(es) in HS for 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider SynapseSqlDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by display name using 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: SELECT u.name,p.displayname FROM users u JOIN profiles p ON u.name LIKE concat('@',p.user_id,':%') WHERE u.is_guest = 0 AND u.appservice_id IS NULL AND p.displayname LIKE ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Display name: found 1 match(es) for 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by 3PID using 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: select t.user_id, p.displayname from user_threepids t JOIN profiles p on t.user_id = concat('@',p.user_id,':kraftpost.eu') where t.address ilike ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Threepid: found 0 match(es) for 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider WordpressDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider - Searching users by display name using 'tes'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Performing search for 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Original request URL: http://top.level.domain/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Querying HS at http://matrix-nginx-proxy:12080/_matrix/client/r0/user_directory/search
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Found 0 match(es) in HS for 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider SynapseSqlDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by display name using 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: SELECT u.name,p.displayname FROM users u JOIN profiles p ON u.name LIKE concat('@',p.user_id,':%') WHERE u.is_guest = 0 AND u.appservice_id IS NULL AND p.displayname LIKE ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Display name: found 1 match(es) for 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Searching users by 3PID using 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.backend.sql.generic.GenericSqlDirectoryProvider - Will execute query: select t.user_id, p.displayname from user_threepids t JOIN profiles p on t.user_id = concat('@',p.user_id,':kraftpost.eu') where t.address ilike ?
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Threepid: found 0 match(es) for 'test'
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.directory.DirectoryManager - Using Directory provider WordpressDirectoryProvider
Jun 13 15:39:50 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider - Searching users by display name using 'test'
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#1] WARN com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@90c2915 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#1] WARN com.mchange.v2.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36272fa8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordressSqlBackend.getConnection(WordressSqlBackend.java:53)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.search(WordpressDirectoryProvider.java:66)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.searchByDisplayName(WordpressDirectoryProvider.java:98)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.directory.DirectoryManager.search(DirectoryManager.java:116)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.directory.v1.UserDirectorySearchHandler.handleRequest(UserDirectorySearchHandler.java:47)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.SaneHandler.handleRequest(SaneHandler.java:71)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.lang.Thread.run(Thread.java:748)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#2] WARN com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@501d3d66 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#2] WARN com.mchange.v2.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36272fa8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#2] WARN com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@653a0852 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#2] WARN com.mchange.v2.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36272fa8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         ... 12 more
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordressSqlBackend.getConnection(WordressSqlBackend.java:53)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.search(WordpressDirectoryProvider.java:66)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.searchByDisplayName(WordpressDirectoryProvider.java:98)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.directory.DirectoryManager.search(DirectoryManager.java:116)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.directory.v1.UserDirectorySearchHandler.handleRequest(UserDirectorySearchHandler.java:47)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.SaneHandler.handleRequest(SaneHandler.java:71)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.lang.Thread.run(Thread.java:748)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         ... 12 more
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#0] WARN com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@31ca9a6f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#0] WARN com.mchange.v2.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36272fa8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] ERROR io.kamax.mxisd.http.undertow.handler.SaneHandler - Transaction #1623591620575 - Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordressSqlBackend.getConnection(WordressSqlBackend.java:53)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.search(WordpressDirectoryProvider.java:66)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.backend.wordpress.WordpressDirectoryProvider.searchByDisplayName(WordpressDirectoryProvider.java:98)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.directory.DirectoryManager.search(DirectoryManager.java:116)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.directory.v1.UserDirectorySearchHandler.handleRequest(UserDirectorySearchHandler.java:47)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.kamax.mxisd.http.undertow.handler.SaneHandler.handleRequest(SaneHandler.java:71)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.lang.Thread.run(Thread.java:748)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         ... 12 more
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: Caused by: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-7] INFO io.kamax.mxisd.http.undertow.handler.BasicHttpHandler - Request POST http://top.level.domain/_matrix/client/r0/user_directory/search - Error M_UNKNOWN: An internal server error occurred. Contact your administrator with reference Transaction #1623591620575
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#1] WARN com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@63f7c956 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: java.sql.SQLException: No suitable driver
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at java.sql.DriverManager.getDriver(DriverManager.java:315)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [C3P0PooledConnectionPoolManager[identityToken->1bqrg22ai1j6kziturmra|14fc5f04]-HelperThread-#1] WARN com.mchange.v2.resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@36272fa8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] ERROR io.kamax.mxisd.http.undertow.handler.SaneHandler - Transaction #1623591620576 - Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-9] INFO io.kamax.mxisd.http.undertow.handler.BasicHttpHandler - Request POST http://top.level.domain/_matrix/client/r0/user_directory/search - Error M_UNKNOWN: An internal server error occurred. Contact your administrator with reference Transaction #1623591620575
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] ERROR io.kamax.mxisd.http.undertow.handler.SaneHandler - Transaction #1623591620576 - Connections could not be acquired from the underlying database!
Jun 13 15:40:20 matrix matrix-ma1sd[25181]: [XNIO-1 task-8] INFO io.kamax.mxisd.http.undertow.handler.BasicHttpHandler - Request POST http://top.level.domain/_matrix/client/r0/user_directory/search - Error M_UNKNOWN: An internal server error occurred. Contact your administrator with reference Transaction #1623591620576
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
Jun 13 15:40:20 matrix matrix-ma1sd[25181]:         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

ma1sd itself is configured like this:

  wordpress:
    enabled: true
    rest:
      base: 'https://account.level.domain'
    sql:
      connection: '//wordpress_db_1/wordpress?user=root&password=passwd'
    type: mysql