Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

flowthinks — Sun, 25 Oct 2020 17:26:53 GMT

I am pulled the lastest cimmunity content management docker image and I get the following error when I run it. Looks like it has to do with mysql.

Can someone lend a hand . Thanks!

... 
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1674)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1248)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:257)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
at org.springframework.beans.factory.config.PropertyPathFactoryBean.setBeanFactory(PropertyPathFactoryBean.java:196)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1793)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.lambda$initializeBean$4(AbstractAutowireCapableBeanFactory.java:1753)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1752)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
... 111 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.alfresco.repo.domain.dialect.DialectFactoryBean.getObject(DialectFactoryBean.java:59)
at org.alfresco.repo.domain.dialect.DialectFactoryBean.getObject(DialectFactoryBean.java:1)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:164)
... 122 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 126 more
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1360)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1182)
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
... 131 more

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

EddieMay — Mon, 26 Oct 2020 10:27:34 GMT

Hi @flowthinks & welcome to Alfresco!

Postgress is the default database & it looks like Alfresco can't find the MySQL JDBC driver. Take a look at the docs for connecting to MySQL.

HTH,

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

kaynezhang — Mon, 26 Oct 2020 13:43:58 GMT

You can also refer to https://hub.alfresco.com/t5/alfresco-content-services-blog/deploying-and-running-alfresco-content-services-6-0/ba-p/293225 about how to deploy and run alfresco acs using docker

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

flowthinks — Mon, 26 Oct 2020 20:39:40 GMT

Thank you for the warm welcome EddieMay

topic Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver in Alfresco Forum

Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver

Re: Unable to run docker image content management community edition CNFE:org.gjt.mm.mysql.Driver