topic Installation on Linux ( Ubuntu Breezy ) in Alfresco Archive

Installation on Linux ( Ubuntu Breezy )

gautham_hegde — Sat, 01 Apr 2006 00:05:13 GMT

I am trying to install alfresco from alfresco-tomcat-1.2.0.tar.gz on the following platform-Ubuntu 5.10 Breezy-MySQL 4.1.12-Debian_1ubuntu3-log-Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05)Havent made too many modifications-Installed in /opt/alfresco-set JAVA_HOME variable to

Re: Installation on Linux ( Ubuntu Breezy )

pipol — Sun, 21 May 2006 15:52:12 GMT

It seems to come from the version 4.1.12 of the MySQL server.

I had exactly the problem that you describe, on a totally different platform, excepting the MySQL version for Linux.

Simply try to upgrade at least to the 4.1.16 (found in the Alfresco bundled installation), or better to the current 4.1.19 … This solved the problem for me !

Re: Installation on Linux ( Ubuntu Breezy )

unknown-user — Tue, 23 May 2006 10:31:51 GMT

I encountered same problem. I've chosen to install MySQL 5 from repository, and it is functional and without any installation problems.

Re: Installation on Linux ( Ubuntu Breezy )

jpotts — Wed, 09 Aug 2006 23:13:40 GMT

I had the same problem running the same release of MySQL (4.1.12-Debian_lubuntu3) on Breezy Badger. What fixed it for me was adding useServerPrepStmts=false to my JDBC connection string.

If you are running the Tomcat-Alfresco bundle, look at the $TOMCAT_HOME/classes/shared/alfresco/extension files. The custom-repository.properties file has an entry called db.url which you can use to override the default JDBC connection string.

There are numerous posts on the internet about that particular hibernate exception–it isn't specific to Alfresco.

Jeff