[opencms-dev] Error installing OpenCms 5.0 rc2 on MySQL and Win XP

[Robert Gartman]

All,

I can't get OpenCms to install on my environment:

Windows XP
MySQL 4.0.12
Tomcat 4.1.24
Java 1.4.1

After installing MySQL, I removed the anonymous access rights on local
user, leaving the following:
mysql> select host,user,password from user;
+-----------+------+------------------+
| host      | user | password         |
+-----------+------+------------------+
| localhost | root |                  |
| %         | root | 4e07e50a6422XXXX |
| %         |      |                  |
+-----------+------+------------------+


In the OpenCMS web-based installation guide, I have tried a several
combinations, none leading to a successful installation. The two options
below lead to the error message as in the end of this mail:

Database Server Connection: root (password left blank)
OpenCms Connection: root (password left blank)
Connection String: jdbc:mysql://localhost:3306/
Database: opencms

or..

Database Server Connection: root (THE PASSWORD)
OpenCms Connection: root (THE PASSWORD)
Connection String: jdbc:mysql://MYSERVER.COM:3306/
Database: opencms
(Where of course MYSERVER is the correct server and domain name and
password is the one set up in MySQL.)


I disabled the installation of directory translation to minimize points
of failure.


The web based installation gives green light all the way until the
"Importing workplace" phase, where the errors below are triggered.

Any clues?
Thankful for any help
Robert Gartman


PS. I have been successful installing the same version of OpenCMS, by
replacing MySQL with MSDE (MS SQL 7), using the same Tomcat and the same
hardware/OS. It's not my desired setup, as I prefer to run it on MySQL.
It indicates though that the problem resides in the MySQL-specific
installation part of OpenCMS 5 rc2.



95:		at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
94:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
93:		at com.opencms.boot.CmsMain.begin(CmsMain.java:160)
92:		at java.lang.reflect.Method.invoke(Method.java:324)
91:		at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
90:		at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
89:		at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
88:		at com.opencms.core.CmsShell.commands(CmsShell.java:177)
87:		at
com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:75)
86:	java.lang.NullPointerException
85:	
84:	>>	at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
83:	>>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
82:	>>	at com.opencms.boot.CmsMain.begin(CmsMain.java:151)
81:	>>	at java.lang.Class.newInstance(Class.java:259)
80:	>>	at java.lang.Class.newInstance0(Class.java:306)
79:	>>	at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
78:	>>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
77:	>>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
76:	>>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
75:	>>	at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
74:	>>	at com.opencms.core.OpenCms.<init>(OpenCms.java:251)
73:	>>	at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
72:	>>	at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a:4174)
71:	>>	at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:62)
70:	>>	at
com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
69:	>>	at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:293)
68:	>>	at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:570)
67:	>>	at
com.opencms.file.genericSql.CmsDbAccess.createTask(CmsDbAccess.java:1834
)
66:	>>	at
com.opencms.file.mySql.CmsDbAccess.readTask(CmsDbAccess.java:843)
65:	>>java.lang.NullPointerException
64:	>>Root cause:
63:	>>-----------
62:	>	at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
61:	>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
60:	>	at com.opencms.boot.CmsMain.begin(CmsMain.java:151)
59:	>	at java.lang.Class.newInstance(Class.java:259)
58:	>	at java.lang.Class.newInstance0(Class.java:306)
57:	>	at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
56:	>	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
55:	>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
54:	>	at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
53:	>	at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
52:	>	at com.opencms.core.OpenCms.<init>(OpenCms.java:251)
51:	>	at
com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
50:	>root cause was java.lang.NullPointerException
49:	>com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Critical error while loading resourcebroker. 
48:	>Root cause:
47:	>-----------
46:		at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
45:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
44:		at com.opencms.boot.CmsMain.begin(CmsMain.java:151)
43:		at java.lang.Class.newInstance(Class.java:259)
42:		at java.lang.Class.newInstance0(Class.java:306)
41:		at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
40:		at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
39:		at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
38:		at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
37:		at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
36:		at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
35:	root cause was java.lang.NullPointerException
34:	root cause was com.opencms.core.CmsException: 33
Resourcebroker-init error. Detailed error: Critical error while loading
resourcebroker. 
33:	com.opencms.core.CmsException: 33 Resourcebroker-init error.
Detailed error: Database init failed. 
32:	. Critical init error/3: com.opencms.core.CmsException: Critical
error while loading resourcebroker
31:	[CmsRbManager] Critical error while loading resourcebroker
30:	. Database fill default: yes
29:	[com.opencms.dbpool.CmsPool] mysql: starting connection-guard
28:	[com.opencms.dbpool.CmsPool] mysql: created
27:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:9
26:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:8
25:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:7
24:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:6
23:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:5
22:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:4
21:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:3
20:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:2
19:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:1
18:	[com.opencms.dbpool.CmsPool] mysql: creating new connection.
Current Amount is:0
17:	. Using digest encoding: MD5 from SUN version 1.2
16:	. Digest file encoding : UTF-8
15:	. Digest configured    : MD5
14:	. Database backup pool : jdbc:opencmspool:mysqlbackup
13:	. Database online pool : jdbc:opencmspool:mysqlonline
12:	. Database offline pool: jdbc:opencmspool:mysql
11:	. Database access init : ok
10:	. Resource broker init : phase 3 ok - creating db access module
9:	. Resource broker init : phase 2 ok - initializing database
8:	. Resource broker init : phase 1 ok - starting
7:	. Resource broker class:
com.opencms.file.mySql.CmsResourceBroker
6:	. Resource broker used : mysql
5:	. Operating sytem      : Windows XP 5.1 x86 
4:	. Java VM in use       : Java HotSpot(TM) Client VM 1.4.1-b21
mixed mode Sun Microsystems Inc. 
3:	. Encoding set to      : ISO-8859-1
2:	. System file.encoding : ISO-8859-1
1:	. OpenCms encoding     : ISO-8859-1
0:	%%% props:
C:\development\jakarta-tomcat-4.1.24\webapps\opencms\WEB-INF\config/open
cms.properties