[opencms-dev] Problem in installing opencms.

Frederico Luis Cabral frluca at compuland.com.br
Tue Oct 19 14:23:29 CEST 2004 

Hi.

I had this problem some weeks ago .... 

copy the file 

CATALINA_HOME\webapps\opencms\WEN-INF\lib\xerces-1_4_4.jar

to the folder

CATALINA_HOME\common\endorsed\

where CATALINA_HOME is the root folder of your
OpenCms.

Also, you must rename the file,

CATALINA_HOME\common\endorsed\xercesImpl.jar 

for 

CATALINA_HOME\common\endorsed\xercesImpl.old

If it doesn't work, let me know.

Cheers,
Fred.


On Tue, 19 Oct 2004 18:21:45 +0530, Pallavi Vidhate wrote 
> Hi, 
>   
> I am facing a problem while installing  opencms. 
>   
> I am using the MySql database. 
>   
> I get an error while creating the database and the tables. 
> The database gets created but the tables are not created. 
>   
> The error that I get is as below :  
>   
> Tables could not be created! 
> Error connecting to database using: jdbc:mysql://localhost:3306/opencms 
> ------------------------------------------- 
> java.sql.SQLException: General error, message from server: "Access denied 
for user: '@localhost' to database 'opencms'" at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977) at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900) at 
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950) at 
com.mysql.jdbc.Connection.createNewIO(Connection.java:1771) at 
com.mysql.jdbc.Connection.(Connection.java:440) at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400) at 
java.sql.DriverManager.getConnection(DriverManager.java:512) at 
java.sql.DriverManager.getConnection(DriverManager.java:171) at 
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:99) at 
org.apache.jsp.step_5_database_creation_jsp._jspService
(step_5_database_creation_jsp.java:325) at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.jasper.servlet.JspServletWrapper.service
(JspServletWrapper.java:204) at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at 
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:247) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193) at 
org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:260) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:191) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:641) at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:641) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:174) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnect
ion(Http11Protocol.java:380) at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:533) at java.lang.Thread.run(Thread.java:536) 
> ------------------------------------------- 
> Error parsing database setup SQL script in line: ); 
> ------------------------------------------- 
> java.lang.NullPointerException at 
org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:336) at 
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:260) at 
org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:195) at 
org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:159) at 
org.apache.jsp.step_5_database_creation_jsp._jspService
(step_5_database_creation_jsp.java:331) at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.jasper.servlet.JspServletWrapper.service
(JspServletWrapper.java:204) at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at 
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:247) at 
org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:193) at 
org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:260) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:191) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:641) at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) 
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:641) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:174) at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeN
ext(StandardPipeline.java:643) at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at 
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnect
ion(Http11Protocol.java:380) at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:533) at java.lang.Thread.run(Thread.java:536) 
> ------------------------------------------- 
> 
> I have not changed any of the default database settings. 
>   
> They are as below : 
>   
>

 Setup Connection        
 OpenCms Connection        
 Connection String      
 Database      
     Create database and tables

>   
>   
> Please let me know the solution to this problem.... 
>   
> Thanks in advance. 
>   
>   
> Regards, 
>   
> Pallavi 
>   
>   
>   
>  

-- 
CompuLand WebMail (http://www.compuland.com.br)

More information about the opencms-dev mailing list