AnsweredAssumed Answered

Alfresco 3 stable with Mysql

Question asked by peter-adams on Apr 9, 2009
Latest reply on Apr 20, 2009 by mrogers
Can anyone help?

I have setup a new Ubuntu server and installed Mysql 5  and Alfresco 3 stable.  Before starting Alfresco, I edited the custom-repository.properties to change the database directory to mysql, remove the Derby config and add the mysql.  I also edited the custom-hiberate-dialect.properties file to remove Derby and add Mysql.  Then I edited the Alfresco.sh to configure the JAVA_HOME.

When I start up, tomcat runs (I tested it with an index.html file), but Alfresco fails with a 404 error.  From everything I have read, it appears that the mysql-connector-java-5.0.3-bin.jar was missing.  I downloaded this and placed it in the /tomcat/lib folder, but I am not sure how it gets called?  In anycase, it still does not work.

One last point, Before doing this clean install, I did the standard Derby install and it worked, so it is definitely something to do with the mysql connection.  I can connect manually to the Alfresco database, so I know that the MYsql itself is okay.

Outcomes