Alfresco installation with mysql database

[ankurgoel30]

Hi,

I am trying to install Alfresco 4.0.1 Enterprise with the the following command :

‍

alfresco-enterprise-4.0.1-installer-linux-x64.bin –mode unattended –alfresco_admin_password admin –disable-components postgres –jdbc_url 'jdbc:mysql://192.168.0.83/alfresco?useUnicode=yes&characterEncoding=UTF-8' –jdbc_database alfresco –jdbc_username alfresco –jdbc_password alfresco –jdbc_driver org.gjt.mm.mysql.Driver

‍

However I am getting the following error in my  tomcat logs :

‍

INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
2012-07-15 14:05:56,648  WARN  [hibernate.cfg.SettingsFactory] [main] Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.gjt.mm.mysql.Driver' for connect URL ''jdbc:mysql://192.168.0.83/alfresco?useUnicode=yes&characterEncoding=UTF-8''
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2079)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304)

‍

As per the documentation I have copied the mysql-connector-java-5.0.8-bin.jar to TOMCAT_HOME/lib directory.

Am I missing some steps or doing something wrong.

Please help me to resolve this issue.

-Ankur

[sheelamk]

hai.put mysql.jar in tomcat lib..it resolves..

[ankurgoel30]

Hi,

iresolved the issue . The problem was with jdbc_url that was there in the alfresco properties file.

The jdbc_url in the command line has the value   'jdbc:mysql://192.168.0.83/alfresco?useUnicode=yes&characterEncoding=UTF-8'
the value in the command line was enclosed in single quotes  , which were takes as a part of the value and were inserted in properties file as it is.
Removing the single quotes around the jdbc_url in the properties file resolved the issue..