Fisheye/Crucible with MySQL does not start

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Fisheye/Crucible with MySQL does not start.

The following appears in the atlassian-fisheye-<date>.log:

2012-12-31 07:45:03,914 INFO  - Starting database...
2012-12-31 07:45:03,932 ERROR - The Web context could not be started
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbControlFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is java.lang.IllegalStateException: Database not available (Unable to connect to MySQL database jdbc:mysql://localhost/fisheye: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver: is the database driver jar file properly installed in the FISHEYE_INST/lib directory?). Current state: NO_DB
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
...
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is java.lang.IllegalStateException: Database not available (Unable to connect to MySQL database jdbc:mysql://localhost/fisheye: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver: is the database driver jar file properly installed in the FISHEYE_INST/lib directory?). Current state: NO_DB
...
Caused by: java.lang.IllegalStateException: Database not available (Unable to connect to MySQL database jdbc:mysql://localhost/fisheye: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver: is the database driver jar file properly installed in the FISHEYE_INST/lib directory?). Current state: NO_DB

Cause

The JDBC driver for MySQL is not bundled with Fisheye/Crucible 2.9+ (due to licensing restrictions). 

Resolution

  1. Download the MySQL Connector/J JDBC driver from the MySQL download website.
  2. Expand the downloaded zip/tar.gz file.
  3. Copy the .jar file to your FISHEYE_INST/lib directory. If the lib/directory doesn't already exist, you will need to create it. 
  4. Restart Fisheye/Crucible.
Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.