The requested resource (/alfresco/) is not available log

[uthayakumar]

11:54:02,312 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
   os:         Windows XP
   command:    imconvert "C:\Program Files\Apache Software Foundation\Tomcat 5.5\temp\Alfresco\ImageMagickContentTransformer_init_source_39718.gif"  "C:\Program Files\Apache Software Foundation\Tomcat 5.5\temp\Alfresco\ImageMagickContentTransformer_init_target_39719.png"
   succeeded:  false
   exit code:  1
   out:       
   err:        CreateProcess: imconvert "C:\Program Files\Apache Software Foundation\Tomcat 5.5\temp\Alfresco\ImageMagickContentTransformer_init_source_39718.gif" "C:\Program Files\Apache Software Foundation\Tomcat 5.5\temp\Alfresco\ImageMagickContentTransformer_in
11:54:07,453 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
11:54:08,984 ERROR [org.alfresco.repo.transaction.TransactionUtil] Error rolling back transaction ……
11:54:09,125 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
   at
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
   … 54 more
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
   at java.lang.ClassLoader.loadClassInternal(Unknown Source)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Unknown Source)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
   … 57 more
11:54:09,375 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
   ……..
11:54:09,625 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
   at ……..

[steve]

Hi,

Your error contains the two following items:
org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

This means that you don't have the MySQL JDBC driver.

I am assuming you are using the WAR package (you don't state what Alfresco package you are using).

If so, you need to read the file 'README_mysql.txt' contained within the package for instructions on how to get Alfresco working with MySQL.

[uthayakumar]

Hi,

Your error contains the two following items:
org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

This means that you don't have the MySQL JDBC driver.

I am assuming you are using the WAR package (you don't state what Alfresco package you are using).

If so, you need to read the file 'README_mysql.txt' contained within the package for instructions on how to get Alfresco working with MySQL.

but,
MySQL Database tables are created, database name alfresco  username &password are same by Deploying alfresco.war.

[steve]

Hi,

Are you saying that the tables were created as part of your war deployment process, or that the tables were already there when you tried to deploy the war?

[tmassa]

I have the same issue i followed the instructions in the README_mysql.txt and i get the same issue when i try to access alfresco. The tables were created in the alfresco mysql database and i am able to see them if i use the admin interface for mysql. Also i was running fine with the HSQL connector and decided to switch to MySQL for deployment and now it hangs.

[steve]

Hi,
Can you provide answers to the following:

Did you create the alfresco tablespace and user following the instructions in the readme?
Have you started Alfresco running against MySQL and the Alfresco tables have been created in the alfresco tablespace?
Are you getting the errors using the exact same Alfresco install as was used to create the tables?

What version of Alfresco are you using?
What version of MySQL are you using?

Thanks.

[tmassa]

Yes i created the alfresco tablespace per the readme file.
Yes i have started alfresco running against the MySQL after which the tables get created, but i still get the error "The requested resource (/alfresco/) is not available."
Yes i have only 1 alfresco install, which i am using to create the tables.

I am using the latest version of Alfresco available 2.1RC
I am using MySQL : 4.1.22
I am using OS X Server

Thanks for the help

[steve]

Hi,

Since you are running on OS X, have you followed the instructions in our Wiki here:
http://wiki.alfresco.com/wiki/Installing_on_MacOS_X

Steve

[tmassa]

Yes i have. As i said before the install works fine with HSQL once i decided to switch the installation over to MySQL it stopped working.

I have added mysql-connector-java-5.0.3-bin.jar to /opt/alfresco/tomcat/common/lib

and i commented out the mysql values in the two configuration files per the instructions in the readme_mysql.txt

Are there some sort of permissions i am missing or is there some detailed debug information i can get from somewhere.

Thanks

[gavinc]

I'm running on Mac OS X without any issues so this should work! I notice you are using Mac OS X Server which has MySQL pre-installed (is that right?) so there could be something to do with the pre-configured state of MySQL, not sure, just a guess!

However, as you have Alfresco tables in MySQL, that implies the connector worked at least once! One thought I had was how did you/are you running Tomcat, did you start it with sudo the first time and your local user the subsequent times? Also check the permissions on the mysql-connector-java-5.0.3-bin.jar file, make sure the file is readable to the user starting Tomcat.

For detailed debugging info you can try turning on debug for various classes (try the ones mentioned in the error stack trace) in /opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/log4j.properties, but be warned this could result in a very large log file!!