AW: [opencms-dev] Error "Duplicate entry 'Guests' for key 2."

[Andreas Zahner]

Jürgen,

Check if the error occurs when you use mysql 3.23.55 (the latest stable
release and not the gamma of version 4) and Tomcat 4.1.18.
Good luck!

Regards,

Andreas Zahner
Alkacon Software - The OpenCms Experts
http://www.alkacon.com 


-----Ursprüngliche Nachricht-----
Von: owner-opencms-dev at www.opencms.org
[mailto:owner-opencms-dev at www.opencms.org] Im Auftrag von
juergen.link at bgs-ag.de
Gesendet: Donnerstag, 13. März 2003 18:15
An: opencms-dev at opencms.com
Betreff: [opencms-dev] Error "Duplicate entry 'Guests' for key 2."


I installed opencms 5.0 RC2 today using Tomcat  4.0.3, J2SDK 1.4.0-beta3
and MySql 4.0.11.a.gamma under Windows 2000. The wizard stated "Your
system uses components which have been tested to work properly with
OpenCms." after creation of the db and tables (checked via mysql
client). While importing the workplace, the following error occured:
65:       at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
64:       at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
63:       at com.opencms.boot.CmsMain.begin(CmsMain.java:159)
62:       at java.lang.reflect.Method.invoke(Method.java:327)
61:       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:28)
60:       at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:42)
59:       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
58:       at com.opencms.core.CmsShell.commands(CmsShell.java:168)
57:       at
com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:65)
56:  java.lang.NullPointerException
55:
54:
53:  >    at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
52:
51:  >    at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
50:
49:  >    at com.opencms.boot.CmsMain.begin(CmsMain.java:150)
48:
47:  >    at java.lang.Class.newInstance(Class.java:254)
46:
45:  >    at java.lang.Class.newInstance0(Class.java:301)
44:
43:  >    at
java.lang.reflect.Constructor.newInstance(Constructor.java:277)
42:
41:  >    at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:30)
40:
39:  >    at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:42)
38:
37:  >    at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
36:
35:  >    at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
34:
33:  >    at com.opencms.core.OpenCms.<init>(OpenCms.java:175)
32:
31:  >    at com.opencms.file.CmsRbManager.init(CmsRbManager.java:86)
30:
29:  >    at
com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.jav
a:3970)
28:
27:  >    at
com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroke
r.java:66)
26:
25:  >    at
com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:65)
24:
23:  >    at
com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:270)
22:
21:  >    at
com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:442)
20:
19:  >    at
com.opencms.file.genericSql.CmsDbAccess.createTask(CmsDbAccess.java:1682
)
18:
17:  >java.lang.NullPointerException
16:       at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
15:       at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
14:       at com.opencms.boot.CmsMain.begin(CmsMain.java:150)
13:       at java.lang.Class.newInstance(Class.java:254)
12:       at java.lang.Class.newInstance0(Class.java:301)
11:       at
java.lang.reflect.Constructor.newInstance(Constructor.java:277)
10:       at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:30)
9:        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:42)
8:        at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
7:        at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
6:        at com.opencms.core.OpenCms.<init>(OpenCms.java:175)
5:        at com.opencms.file.CmsRbManager.init(CmsRbManager.java:98)
4:   [CmsException]: 33 Resourcebroker-init error. Detailed Error:
Critical error while loading resourcebroker. . Caught Exception:
>java.lang.NullPointerException<
3:   %%% props:
D:\Software\jakarta-tomcat-4.0.3\webapps\opencms\WEB-INF\config/opencms.
properties
2:   jarlist
1:   oclib folder:
D:\Software\jakarta-tomcat-4.0.3\webapps\opencms\WEB-INF\oclib
0:   Collecting Repositories

I tried to downgrade to 4.7.7, but the effect is identical. When I try
to login to the workplace, the following error is found in the
opencms.log:

<snip>
[13.03.2003 18:12:02] <opencms_pool> [com.opencms.dbpool.CmsPool] mysql:
starting connection-guard [13.03.2003 18:12:02] <opencms_init>
[CmsDbAccess] fill default resources [13.03.2003 18:12:02]
<opencms_init> [CmsRbManager] Critical error while loading
resourcebroker. [13.03.2003 18:12:02] <opencms_init> [OpenCms] Critical
error while loading resourcebroker. [13.03.2003 18:12:01] <opencms_info>
[CmsClassLoader] Adding repository
D:\Software\jakarta-tomcat-4.0.3\webapps\opencms\WEB-INF\oclib\opencms.j
ar
</snip>

I'm a newbie to OpenCms, but I read the manuals and the mailing archive
;)  I verified the entry "resourcebroker=mysql" in opencms.properties.

Has anyone some idea?

Thanks in advance, Jürgen