topic Re: The requested resource (/alfresco/) is not available log in Alfresco Archive

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

uthayakumar — Tue, 17 Jul 2007 12:20:42 GMT

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 Found

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

steve — Tue, 17 Jul 2007 16:41:49 GMT

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.

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

uthayakumar — Wed, 18 Jul 2007 12:21:23 GMT

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.

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

steve — Wed, 18 Jul 2007 15:40:50 GMT

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?

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

tmassa — Wed, 18 Jul 2007 16:00:34 GMT

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.

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

steve — Wed, 18 Jul 2007 16:17:14 GMT

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.

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

tmassa — Wed, 18 Jul 2007 18:57:17 GMT

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

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

steve — Wed, 18 Jul 2007 21:42:26 GMT

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

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

tmassa — Thu, 19 Jul 2007 02:37:22 GMT

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

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

gavinc — Fri, 20 Jul 2007 12:19:15 GMT

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!!

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

tmassa — Fri, 20 Jul 2007 14:01:27 GMT

I was able to make it work using the instructions in the readme file, but i downloaded one of the Nightly builds for Alfresco 2.1 i wasn't able to get it going with Alfresco 2.1RC