Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Crowd is not able to connect to MySQL database after update from 4.3.0 to 4.3.5

Hi,

I've updated our crowd instance but its not able to connect to the MySQL database anymore. Im using the mysql-connector version 5.1.45, I've also tried 5.1.48 in this case.

2021-07-16 09:07:28,306 localhost-startStop-1 INFO [apache.jasper.servlet.TldScanner] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2021-07-16 09:07:28,311 localhost-startStop-1 INFO [ContainerBase.[Catalina].[localhost].[/crowd]] No Spring WebApplicationInitializer types detected on classpath
2021-07-16 09:07:29,067 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:07:29,067 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:07:29,116 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:07:29,820 localhost-startStop-1 INFO [ContainerBase.[Catalina].[localhost].[/crowd]] Initializing Spring root WebApplicationContext
2021-07-16 09:07:31,563 localhost-startStop-1 INFO [persistence.hibernate.connection.DelegatingConnectionProvider] Configuring delegated connection provider: org.hibernate.c3p0.internal.C3P0ConnectionProvider@e904faf
2021-07-16 09:07:31,577 MLog-Init-Reporter INFO [mchange.v2.log.MLog] MLog clients using slf4j logging.
2021-07-16 09:07:31,628 localhost-startStop-1 INFO [mchange.v2.c3p0.C3P0Registry] Initializing c3p0-0.9.5.4 [built 23-March-2019 23:00:48 -0700; debug? true; trace: 10]
2021-07-16 09:07:31,699 localhost-startStop-1 INFO [v2.c3p0.impl.AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@81deed9d [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@dcceb96e [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 186xnslai1cbgbkm1pj4yyn|50779df3, idleConnectionTestPeriod -> 100, initialPoolSize -> 0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@82d5bc75 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 186xnslai1cbgbkm1pj4yyn|1e9c4c65, jdbcUrl -> jdbc:mysql://localhost/crowd?autoReconnect=true&characterEncoding=utf8&useUnicode=true&rewriteBatchedStatements=true, properties -> {handling_mode=DELAYED_ACQUISITION_AND_RELEASE_AFTER_TRANSACTION, user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 186xnslai1cbgbkm1pj4yyn|7c805302, numHelperThreads -> 3 ]
2021-07-16 09:10:05,999 C3P0PooledConnectionPoolManager[identityToken->186xnslai1cbgbkm1pj4yyn|7c805302]-HelperThread-#1 WARN [mchange.v2.resourcepool.BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@9abc472 -- 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:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.GeneratedConstructorAccessor73.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2094)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2019)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 1 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:203)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4901)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2035)
... 18 more
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
at sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:171)
at sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:98)
at sun.security.ssl.TransportContext.kickstart(TransportContext.java:220)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:428)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:188)
... 23 more
2021-07-16 09:10:06,000 C3P0PooledConnectionPoolManager[identityToken->186xnslai1cbgbkm1pj4yyn|7c805302]-HelperThread-#1 WARN [mchange.v2.resourcepool.BasicResourcePool] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@6bd2704d is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2021-07-16 09:10:06,002 localhost-startStop-1 WARN [jdbc.env.internal.JdbcEnvironmentInitiator] HHH000342: Could not obtain connection to query metadata : Connections could not be acquired from the underlying database!

 I tried a newser version of mysql connector (8.0.24) and get the following error:

2021-07-16 09:12:14,940 localhost-startStop-1 INFO [apache.jasper.servlet.TldScanner] At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2021-07-16 09:12:14,943 localhost-startStop-1 INFO [ContainerBase.[Catalina].[localhost].[/crowd]] No Spring WebApplicationInitializer types detected on classpath
2021-07-16 09:12:15,636 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:12:15,636 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:12:15,685 localhost-startStop-1 INFO [atlassian.crowd.config.CrowdApplicationConfig] Using config directory : /var/atlassian/application-data/crowd/shared
2021-07-16 09:12:16,374 localhost-startStop-1 INFO [ContainerBase.[Catalina].[localhost].[/crowd]] Initializing Spring root WebApplicationContext
2021-07-16 09:12:18,027 localhost-startStop-1 INFO [persistence.hibernate.connection.DelegatingConnectionProvider] Configuring delegated connection provider: org.hibernate.c3p0.internal.C3P0ConnectionProvider@2018de93
2021-07-16 09:12:18,040 MLog-Init-Reporter INFO [mchange.v2.log.MLog] MLog clients using slf4j logging.
2021-07-16 09:12:18,121 localhost-startStop-1 INFO [mchange.v2.c3p0.C3P0Registry] Initializing c3p0-0.9.5.4 [built 23-March-2019 23:00:48 -0700; debug? true; trace: 10]
2021-07-16 09:12:18,200 localhost-startStop-1 INFO [v2.c3p0.impl.AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@399c905 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@5372d8c7 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 186xnslai1cbmgmi84j5bb|4b9b4b53, idleConnectionTestPeriod -> 100, initialPoolSize -> 0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@53af1266 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 186xnslai1cbmgmi84j5bb|6c6f7b62, jdbcUrl -> jdbc:mysql://localhost/crowd?autoReconnect=true&characterEncoding=utf8&useUnicode=true&rewriteBatchedStatements=true, properties -> {handling_mode=DELAYED_ACQUISITION_AND_RELEASE_AFTER_TRANSACTION, user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 186xnslai1cbmgmi84j5bb|776b4d09, numHelperThreads -> 3 ]
2021-07-16 09:12:22,151 localhost-startStop-1 INFO [opensaml.core.config.InitializationService] Initializing OpenSAML using the Java Services API
2021-07-16 09:12:23,113 localhost-startStop-1 INFO [crowd.console.listener.StartupListener] License is valid. Support Entitlement Number (SEN) is SEN-11352380
2021-07-16 09:12:23,169 localhost-startStop-1 INFO [v2.c3p0.impl.AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@5becbfa2 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@610baf38 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> 186xnslai1cbmgmi84j5bb|4b1c586e, idleConnectionTestPeriod -> 100, initialPoolSize -> 0, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 30, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@a582c860 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 186xnslai1cbmgmi84j5bb|3765de28, jdbcUrl -> jdbc:mysql://localhost/crowd?autoReconnect=true&characterEncoding=utf8&useUnicode=true&rewriteBatchedStatements=true, properties -> {user=******, password=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 186xnslai1cbmgmi84j5bb|4b4c649f, numHelperThreads -> 3 ]
2021-07-16 09:12:24,009 localhost-startStop-1 INFO [liquibase.lockservice.StandardLockService] Successfully acquired change log lock
2021-07-16 09:12:24,012 localhost-startStop-1 INFO [liquibase.servicelocator.ServiceLocator] Can not use class liquibase.parser.core.yaml.YamlChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2021-07-16 09:12:24,012 localhost-startStop-1 INFO [liquibase.servicelocator.ServiceLocator] Can not use class liquibase.parser.core.json.JsonChangeLogParser as a Liquibase service because org.yaml.snakeyaml.constructor.BaseConstructor is not in the classpath
2021-07-16 09:12:24,565 localhost-startStop-1 INFO [liquibase.changelog.StandardChangeLogHistoryService] Reading from crowd.CWD_DATABASECHANGELOG
2021-07-16 09:12:24,574 localhost-startStop-1 INFO [liquibase.lockservice.StandardLockService] Successfully released change log lock
2021-07-16 09:12:24,576 localhost-startStop-1 ERROR [crowd.console.listener.StartupListener] Failed to initialise Crowd container
java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String
at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:328)
at liquibase.changelog.AbstractChangeLogHistoryService.upgradeChecksums(AbstractChangeLogHistoryService.java:66)
at liquibase.changelog.StandardChangeLogHistoryService.upgradeChecksums(StandardChangeLogHistoryService.java:297)
at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1174)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.Liquibase.update(Liquibase.java:178)
at com.atlassian.crowd.util.persistence.hibernate.LiquibaseSchemaHelper.runLiquibaseUpdate(LiquibaseSchemaHelper.java:154)
at com.atlassian.crowd.util.persistence.hibernate.LiquibaseSchemaHelper.lambda$updateSchemaIfNeeded$1(LiquibaseSchemaHelper.java:76)
at com.atlassian.crowd.util.persistence.hibernate.LiquibaseSchemaHelper.withServiceRegistry(LiquibaseSchemaHelper.java:178)
at com.atlassian.crowd.util.persistence.hibernate.LiquibaseSchemaHelper.withServiceRegistry(LiquibaseSchemaHelper.java:164)
at com.atlassian.crowd.util.persistence.hibernate.LiquibaseSchemaHelper.updateSchemaIfNeeded(LiquibaseSchemaHelper.java:75)
at com.atlassian.crowd.console.listener.StartupListener.migrateAndUpgradeCrowd(StartupListener.java:194)
at com.atlassian.crowd.console.listener.StartupListener.contextInitialized(StartupListener.java:61)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4705)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5171)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1873)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2021-07-16 09:12:24,579 localhost-startStop-1 ERROR [crowd.console.listener.StartupListener] Errors experienced during the Crowd upgrade process: []
2021-07-16 09:12:24,579 localhost-startStop-1 INFO [com.atlassian.crowd.startup] System Information:
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Timezone: Central European Time
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Java Version: 1.8.0_292
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Java Vendor: AdoptOpenJDK
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] JVM Version: 25.292-b10
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] JVM Vendor: AdoptOpenJDK
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] JVM Runtime: OpenJDK 64-Bit Server VM
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Username: root
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Operating System: Linux4.19.0-17-amd64
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Architecture: amd64
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] File Encoding: UTF-8
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] JVM Statistics:
2021-07-16 09:12:24,580 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Total Memory: 261MB
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Used Memory: 106MB
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Free Memory: 154MB
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Runtime Information:
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Version: 4.3.5
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Build Number: 1637
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [com.atlassian.crowd.startup] Build Date: 2021-07-02
2021-07-16 09:12:24,581 localhost-startStop-1 INFO [crowd.console.listener.StartupListener] Upgrades not performed since the application has not been setup yet.
2021-07-16 09:12:24,581 localhost-startStop-1 ERROR [crowd.console.listener.StartupListener] Stopping Crowd startup due to earlier errors
2021-07-16 09:12:24,613 localhost-startStop-1 INFO [ContainerBase.[Catalina].[localhost].[/crowd]] org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)

1 answer

0 votes

Hey @Martin Grulich 

Have you confirmed that the MySQL server is indeed running and accepting connections at localhost:3306?

While this is basic troubleshooting, sometimes it's the easy things that are overlooked and based on the logs, it does indicate a basic connection issue and I'd be surprised if the mysql connector version came in to play.

 

CCM

Hi CCM,

thank you. But I've already checked this manually with manual connection on shell: 

mysql -h localhost -P 3306 -u crowd -p crowd
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 176763
Server version: 5.7.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW TABLES;
+-----------------------------+
| Tables_in_crowd |
+-----------------------------+
| CWD_DATABASECHANGELOG |
| CWD_DATABASECHANGELOGLOCK |
| cwd_app_dir_default_groups |
| cwd_app_dir_group_mapping |
| cwd_app_dir_mapping |
| cwd_app_dir_operation |
| cwd_app_licensed_user |
| cwd_app_licensing |
| cwd_app_licensing_dir_info |
| cwd_application |
| cwd_application_address |
| cwd_application_alias |
| cwd_application_attribute |
| cwd_application_saml_config |
| cwd_audit_log_changeset |
| cwd_audit_log_entity |
| cwd_audit_log_entry |
| cwd_cluster_heartbeat |
| cwd_cluster_info |
| cwd_cluster_job |
| cwd_cluster_lock |
| cwd_cluster_message |
| cwd_cluster_message_id |
| cwd_cluster_safety |
| cwd_directory |
| cwd_directory_attribute |
| cwd_directory_operation |
| cwd_expirable_user_token |
| cwd_granted_perm |
| cwd_group |
| cwd_group_admin_group |
| cwd_group_admin_user |
| cwd_group_attribute |
| cwd_membership |
| cwd_property |
| cwd_remember_me_token |
| cwd_saml_trust_entity_idp |
| cwd_synchronisation_status |
| cwd_synchronisation_token |
| cwd_token |
| cwd_tombstone |
| cwd_user |
| cwd_user_attribute |
| cwd_user_credential_record |
| cwd_webhook |
| hibernate_unique_key |
+-----------------------------+
46 rows in set (0.00 sec)

mysql> QUIT
Bye

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
4.3.5
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

119 views 1 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you