[opencms-dev] problem

[Riccardo Cozzani]

Hi all,

I'm moving my old devel server to a new one, but I've some problem  
with opencms.  On the old server I had: opencms 5.0, JDK 1.4.2, tomcat  
4.1.31 and mysql 4.0.24, white the new server is a CentOS 5.0 with  
mysql 5.0.22, jdk-6u3-linux-i586 and tomcat 5.5.23.

On the new server I've restored the mysql dump and set a mysql account  
accordinly with the old mysql/opencms installation, so I can connect  
to the new mysql db: I double checked these parameters with  
opencms.properties and it's ok.

Then I've unpacked the old opencms archive, from a tar zcf of  
webapps/opencms, into the new webapps and then I've started tomcat5  
with CATALINA_OPTS=" -Djava.awt.headless=true  
-Dfile.encoding=ISO-8859-1".

When I try to connect to http://localhost:8080/opencms/opencms/ it  
shows me an error like this:

[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> . OpenCms version 5.0.0 Kaitain
[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> . Copyright (c) 2002-2003 Alkacon  
Software
[30.11.2007 19:07:48] <opencms_init> . Copyright (c) 2000-2002 The  
OpenCms Group
[30.11.2007 19:07:48] <opencms_init> . OpenCms comes with ABSOLUTELY  
NO WARRANTY
[30.11.2007 19:07:48] <opencms_init> . This is free software, and you  
are welcome to
[30.11.2007 19:07:48] <opencms_init> . redistribute it under certain  
conditions.
[30.11.2007 19:07:48] <opencms_init> . Please see the GNU Lesser  
General Public Licence for
[30.11.2007 19:07:48] <opencms_init> . further details.
[30.11.2007 19:07:48] <opencms_init> .
[30.11.2007 19:07:48] <opencms_init> .                       
...............................................................
[30.11.2007 19:07:48] <opencms_init> . Startup time         : Fri Nov  
30 19:07:48 GMT+01:00 2007
[30.11.2007 19:07:48] <opencms_init> . Servlet container    : Apache  
Tomcat/5.5.20
[30.11.2007 19:07:48] <opencms_init> . OpenCms version      : 5.0.0 Kaitain
[30.11.2007 19:07:48] <opencms_init> . OpenCms base path    :  
/usr/share/tomcat5/webapps/opencms/WEB-INF/
[30.11.2007 19:07:48] <opencms_init> . OpenCms property file:  
/usr/share/tomcat5/webapps/opencms/WEB-INF/config/opencms.properties
[30.11.2007 19:07:48] <opencms_init> . OpenCms logfile      :  
/usr/share/tomcat5/webapps/opencms/WEB-INF/logs/opencms.log
[30.11.2007 19:07:48] <opencms_init> . OpenCms encoding     : ISO-8859-1
[30.11.2007 19:07:48] <opencms_init> . System file.encoding : ISO-8859-1
[30.11.2007 19:07:48] <opencms_init> . Encoding set to      : ISO-8859-1
[30.11.2007 19:07:48] <opencms_init> . Ethernet address used:  
c6:b5:45:5e:47:19
[30.11.2007 19:07:48] <opencms_init> . Java VM in use       : GNU  
libgcj 4.1.1 20070105 (Red Hat 4.1.1-52) GNU libgcj 4.1.1 20070105  
(Red Hat 4.1.1-52) Free Software Foundation, Inc.
[30.11.2007 19:07:48] <opencms_init> . Operating sytem      : Linux  
2.6.18-8.el5 i386
[30.11.2007 19:07:48] <opencms_init> . Resource broker used : mysql
[30.11.2007 19:07:48] <opencms_init> . Resource broker class:  
com.opencms.file.mySql.CmsResourceBroker
[30.11.2007 19:07:48] <opencms_init> . Resource broker init : phase 1  
ok - starting
[30.11.2007 19:07:48] <opencms_init> . Resource broker init : phase 2  
ok - initializing database
[30.11.2007 19:07:48] <opencms_init> . Resource broker init : phase 3  
ok - creating db access module

while in the mysql log there are only these lines:

071130 19:07:49       2 Connect     opencms at localhost on
                       2 Init DB     opencms
                       2 Query       SHOW VARIABLES
                       3 Connect     opencms at localhost on
                       3 Init DB     opencms
                       3 Query       SHOW VARIABLES

I don't know what in the mysql variables opencms doesn't like, I hope  
someone could give me some hint.

Thanks,
Riccardo