[opencms-dev] Installation problems
Pascal DeMilly
list.opencms at newgenesys.com
Sat Jun 28 00:44:01 CEST 2003
Did that. And yes, miraculously it seemed to do something as it said
that it was done and to check for any errors in the output window. Sadly
I have some errors:
113: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
112: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
111: at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
110: at java.lang.reflect.Method.invoke(Method.java:324)
109: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
108: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
107: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
106: at com.opencms.core.CmsShell.commands(CmsShell.java:177)
105: at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
104: java.lang.NullPointerException
103:
102: >>> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
101: >>> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
100: >>> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
99: >>> at java.lang.Class.newInstance(Class.java:259)
98: >>> at java.lang.Class.newInstance0(Class.java:306)
97: >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
96: >>> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
95: >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
94: >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
93: >>> at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
92: >>> at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
91: >>> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
90: >>> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
89: >>> at com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62)
88: >>> at com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
87: >>> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
86: >>> at com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
85: >>> at com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1163)
84: >>> at com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.java:177)
83: >>> at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
82: >>> at com.mysql.jdbc.PreparedStatement.executeUpdate(Unknown Source)
81: >>> at com.mysql.jdbc.Connection.execSQL(Unknown Source)
80: >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
79: >>> at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
78: >>>java.sql.SQLException: Invalid argument value: Duplicate entry '/' for key 2
77: >>>Root cause:
76: >>>-----------
75: >> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
74: >> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
73: >> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
72: >> at java.lang.Class.newInstance(Class.java:259)
71: >> at java.lang.Class.newInstance0(Class.java:306)
70: >> at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
69: >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
68: >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
67: >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
66: >> at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
65: >> at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
64: >> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
63: >> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
62: >> at com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62)
61: >> at com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
60: >> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
59: >> at com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
58: >> at com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1165)
57: >>root cause was java.sql.SQLException: Invalid argument value: Duplicate entry '/' for key 2
56: >>com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value: Duplicate entry '/' for key 2.
55: >>Root cause:
54: >>-----------
53: > at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
52: > at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
51: > at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
50: > at java.lang.Class.newInstance(Class.java:259)
49: > at java.lang.Class.newInstance0(Class.java:306)
48: > at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
47: > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
46: > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
45: > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
44: > at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
43: > at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
42: > at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
41: >root cause was java.sql.SQLException: Invalid argument value: Duplicate entry '/' for key 2
40: >root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value: Duplicate entry '/' for key 2.
39: >com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.
38: >Root cause:
37: >-----------
36: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
35: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
34: at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
33: at java.lang.Class.newInstance(Class.java:259)
32: at java.lang.Class.newInstance0(Class.java:306)
31: at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
30: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
29: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
28: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
27: at com.opencms.core.CmsShell.<init>(CmsShell.java:114)
26: at com.opencms.core.OpenCms.<init>(OpenCms.java:259)
25: root cause was java.sql.SQLException: Invalid argument value: Duplicate entry '/' for key 2
24: root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value: Duplicate entry '/' for key 2.
23: root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.
22: com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed.
21: . Critical init error/3: com.opencms.core.CmsException: Critical error while loading resourcebroker
20: [CmsRbManager] Critical error while loading resourcebroker
19: . Database fill default: yes
18: . Using digest encoding: MD5 from SUN version 1.2
17: . Digest file encoding : UTF-8
16: . Digest configured : MD5
15: . Database backup pool : jdbc:opencmspool:mysqlbackup
14: . Database online pool : jdbc:opencmspool:mysqlonline
13: . Database offline pool: jdbc:opencmspool:mysql
12: . Database access init : ok
11: . Resource broker init : phase 3 ok - creating db access module
10: . Resource broker init : phase 2 ok - initializing database
9: . Resource broker init : phase 1 ok - starting
8: . Resource broker class: com.opencms.file.mySql.CmsResourceBroker
7: . Resource broker used : mysql
6: . Operating sytem : Linux 2.4.18-24.8.0 i386
5: . Java VM in use : Java HotSpot(TM) Client VM 1.4.1_01-b01 mixed mode Sun Microsystems Inc.
4: . Ethernet address used: e5:27:0e:5e:96:4e
3: . Encoding set to : ISO-8859-1
2: . System file.encoding : ISO-8859-1
1: . OpenCms encoding : ISO-8859-1
0: %%% props: /var/tomcat4/webapps/opencms/WEB-INF/config/opencms.properties
Any ideas?
Thanks for all your help
Regards
Pascal
On Fri, 2003-06-27 at 15:14, Stephan Hartmann wrote:
> if you are using mozilla you have to refresh the frame with the text area
> once manually.
>
> Bye,
> Stephan
>
> ----- Original Message -----
> From: "Pascal DeMilly" <list.opencms at newgenesys.com>
> To: "opencms dev list" <opencms-dev at opencms.org>
> Sent: Friday, June 27, 2003 11:44 PM
> Subject: Re: [opencms-dev] Installation problems
>
>
> > Matt,
> >
> > Thanks for your help. Actually for those running into the same problem,
> > I had to:
> >
> > grant privileges to *.* identified by opencms@"%" identified by
> 'mypassword' with grant option;
> >
> > as well.
> >
> > But now I am getting stuck at importing workspace. Is there a way to debug
> this wizard or better to run it from a command line.
> >
> > Thanks again for your help. I am eager to give opencms a try. Sounds
> > like a great product.
> >
> > Pascal
> >
> > PS: sorry if it double-post
> >
> > On Fri, 2003-06-27 at 13:19, M Butcher wrote:
> > > Pascal,
> > >
> > > For RH 8, it is a good idea to _not_ use the root user to connect to the
> > > database. RH security settings will cause some problems, and I bet
> > > that's what you are seeing here.
> > >
> > > NOTE: I had already created a database called 'opencms' by hand (e.g.
> > > CREATE DATABASE opencms)
> > >
> > > What I did was create a new user called opencms:
> > > # useradd opencms
> > >
> > > Then I logged into MySQL and granted that user permissions to the
> > > opencms database:
> > > # mysql -u root mysql
> > > ...
> > > mysql> GRANT ALL PRIVILEGES ON *.* TO opencms at localhost IDENTIFIED BY
> > > 'myPassword' WITH GRANT OPTION;
> > > ...
> > > mysql> \q
> > >
> > > Then I tested that MySQL account:
> > > # mysql -u opencms -p opencms
> > > ...
> > > mysql>\q
> > >
> > > Then I went back and re-ran the http://localhost:8080/opencms/ocsetup
> > > This time, I set user (for both creating and using) to 'opencms' and set
> > > the password to 'myPassword'.
> > >
> > > Hope that helps.
> > >
> > > Matt
> > >
> > >
> > > On Fri, 2003-06-27 at 13:35, Pascal DeMilly wrote:
> > > > Hi,
> > > >
> > > > I am new to opencms and tomcat for that matter. I am trying to install
> > > > and configure opencms and I am not able to create the database
> following
> > > > the installation instructions provided.
> > > >
> > > > I am using:
> > > >
> > > > Linux/Redhat 8.0: 2.4.18-24.8.0
> > > > Tomcat 4: tomcat4-4.1.24-full.2jpp
> > > > OpenCMS: OpenCms 5.0.0
> > > > MySQL: mysql-3.23.56-1.80
> > > >
> > > > I tested mysql with the root password I assigned using mysqladmin -u
> > > > root -p, so it looks like mysql is setup correctly.
> > > >
> > > > However when trying to create the database in opencms I get the
> message:
> > > >
> > > > What I am doing wrong?
> > > >
> > > > Thanks in advance,
> > > >
> > > > Pascal
> > > >
> > > > type Exception report
> > > > ------------------------
> > > > message
> > > >
> > > > description The server encountered an internal error () that prevented
> > > > it from fulfilling this request.
> > > >
> > > > exception
> > > >
> > > >
> > > > org.apache.jasper.JasperException
> > > > at
> org.apache.jasper.runtime.JspRuntimeLibrary.internalIntrospecthelper(Unknown
> Source)
> > > > at
> org.apache.jasper.runtime.JspRuntimeLibrary.introspecthelper(Unknown Source)
> > > > at org.apache.jasper.runtime.JspRuntimeLibrary.introspect(Unknown
> Source)
> > > > at
> org.apache.jsp.connect_mysql_jsp._jspService(connect_mysql_jsp.java:69)
> > > > at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
> > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> > > > at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
> > > > at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
> > > > at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
> > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> > > > at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
> Source)
> > > > at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
> Source)
> > > > at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardContextValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> > > > at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> > > > at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
> > > > at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> > > > at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
> > > > at java.lang.Thread.run(Thread.java:536)
> > > >
> > > > root cause
> > > >
> > > >
> > > > java.lang.reflect.InvocationTargetException
> > > > at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
> > > > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
> > > > at java.lang.reflect.Method.invoke(Method.java:324)
> > > > at
> org.apache.jasper.runtime.JspRuntimeLibrary.internalIntrospecthelper(Unknown
> Source)
> > > > at
> org.apache.jasper.runtime.JspRuntimeLibrary.introspecthelper(Unknown Source)
> > > > at org.apache.jasper.runtime.JspRuntimeLibrary.introspect(Unknown
> Source)
> > > > at
> org.apache.jsp.connect_mysql_jsp._jspService(connect_mysql_jsp.java:69)
> > > > at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
> > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> > > > at org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
> > > > at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
> > > > at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
> > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> > > > at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
> Source)
> > > > at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
> Source)
> > > > at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardContextValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
> Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
> > > > at
> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
> eNext(Unknown Source)
> > > > at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
> > > > at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
> > > > at
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> > > > at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> > > > at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
> ction(Http11Protocol.java:392)
> > > > at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> > > > at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:619)
> > > > at java.lang.Thread.run(Thread.java:536)
> > > > Caused by: java.lang.NullPointerException
> > > > at com.opencms.boot.CmsSetup.getExtProperty(CmsSetup.java:163)
> > > > at com.opencms.boot.CmsSetup.getResourceBroker(CmsSetup.java:241)
> > > > at com.opencms.boot.CmsSetup.setDbCreateConStr(CmsSetup.java:812)
> > > > ... 42 more
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > This mail is send to you from the opencms-dev mailing list
> > > > To change your list options, or to unsubscribe from the list, please
> visit
> > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> >
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
More information about the opencms-dev
mailing list