Unable to Start Crowd Due to Missing JDBC Driver
Symptoms
The following errors may appear in atlassian-crowd.log
file:
2013-02-14 15:26:22,877 main ERROR [org.hibernate.connection.C3P0ConnectionProvider] JDBC Driver class not found: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
2017-11-01 15:34:53,393 http-bio-8095-exec-11 ERROR [console.action.setup.Database] Unable to connect to database: java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432
com.atlassian.config.bootstrap.BootstrapException: java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432
Cause #1
JDBC driver is not loaded
The appropriate JDBC driver (in the example above, the MySQL jdbc driver) has not been installed
Resolution #1
Download the latest driver from the manufacturer's website and insert it into <crowd-install>/apache-tomcat/lib directory.
Please refer to the following documentation on configuring the database:
Cause #2
JDBC URL is in wrong syntax
Entering the wrong JDBC URL syntax will throw a similar error:
Resolution #2
Check the default JDBC URL to access the database provided by Crowd and make sure you are using the correct syntax.
In the case above, we are not specifying which database Crowd will connect with. The correct syntax would be like:
jdbc:postgresql://localhost:5432/crowd