The requested resource (/alfresco/) is not available log
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2007 08:20 AM
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 ……..
- Labels:
-
Archive
![steve steve](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2007 12:41 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 08:21 AM
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 steve](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 11:40 AM
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 tmassa](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 12:00 PM
![steve steve](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 12:17 PM
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 tmassa](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 02:57 PM
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 steve](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 05:42 PM
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 tmassa](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-18-2007 10:37 PM
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 gavinc](https://connect.hyland.com/legacyfs/online/avatars/Blue-user-logo.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-20-2007 08:19 AM
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!!
![](/skins/images/3EA4296CAFBBFFCF1FE252BDE05FE3BC/responsive_peak/images/icon_anonymous_message.png)