[opencms-dev] Installation problems

M Butcher mbutcher at grcomputing.net
Fri Jun 27 22:11:01 CEST 2003


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.invokeNext(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.invokeNext(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.invokeNext(Unknown Source)
> 	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
> 	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
> 	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:392)
> 	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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.invokeNext(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.invokeNext(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.invokeNext(Unknown Source)
> 	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
> 	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
> 	at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:392)
> 	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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
-- 
M Butcher <mbutcher at grcomputing.net>



More information about the opencms-dev mailing list