[opencms-dev] OpenCms 6.0 and Oracle 9i
David Gonzalez Fuentes
david.gonzalezf at ibernettelematica.es
Mon Jul 18 13:01:08 CEST 2005
I'had a problem like that. Basically de BBDD connection problem was due to a Java an OS connectivity problem, depend on your Linux distribution. In my case I used Fedora FC4.
Check my notes (posted in mailing list), just in case help you. You will find the java forum OS pblm and how to solve it.
Hi Team,
I'd like to post some instalation notes that i think may be interesting to OpenCms instalation and if your are novel:
1.- If Fedora FC4 is instaled
Disable ipv6 as reported in http://www.linuxforums.org/forum/topic-47483.html. If this is not done, OpenCms will not
have communication to MySQL and could not create de DB.
I recommend FC4 full instalation without Firewall
2.- Use RPM files as possible
When java SDK is downloaded, use the RPM file, execute the bin and then execute the "rpm -Uvh <file>" command.
This will install everythink in the apropiate path
3.- Variables
use in same command instruction "export JAVA_HOME= /usr/java/jj2sdk1.4.2_08. Same with other variables.
4.- Tomcat:
install it in "/usr/tomcat" path
5.- MySQL
If FC4 is full installed, dond install again MySQL as www.opencsm.org says.
Only use the command to run de BD as says the instalation notes. Básicaly "mysql_install_db --user=mysql"
"mysqld_safe --user=mysql" without any special path.
6.- OpenCms
Install the last version 6.0.0
Do not use password in "Setup Connection". Select de 4.1x MySQL BBDD
Try to fill de "MAC" address when is requested in "setup wizard-seting". Should be automatically detected. If is not
detected will not appear de login screen. If OpenCms suggest to run again the setup wizard, do it and MAC will be
detected automatically. This will permit to finalize the setup and have access to the login screen.
Brgds, David
________________________________
De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] En nombre de Manuel Wallnoefer
Enviado el: martes, 12 de julio de 2005 15:46
Para: List OpenCMS
Asunto: [opencms-dev] OpenCms 6.0 and Oracle 9i
Hi all,
i want to install OCms 6.0 and use a Oracle 9i database.
When I've entered the User and the Connection String in the setup Wizard and press next I become the following Error:
Formularbeginn
Creating database ...
Database could not be created!
Error loading JDBC driver: "oracle.jdbc.driver.OracleDriver".
-------------------------------------------
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:265) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:106) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534)
-------------------------------------------
Error parsing database setup SQL script in line: QUOTA UNLIMITED ON ${temporaryTablespace};
-------------------------------------------
java.lang.NullPointerException at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:456) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:363) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:426) at org.opencms.setup.CmsSetupDb.createDatabase(CmsSetupDb.java:117) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:276) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534)
-------------------------------------------
Creating tables ...
Tables could not be created!
Error loading JDBC driver: "oracle.jdbc.driver.OracleDriver".
-------------------------------------------
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:265) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:340) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534)
-------------------------------------------
Error parsing database setup SQL script in line: );
-------------------------------------------
java.lang.NullPointerException at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:456) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:363) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:426) at org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:142) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp:350) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534)
-------------------------------------------
Formularende
Can anybody help me what i've done wrong ???
Thx a lot ....
mfg
manuel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050718/a29981e5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1713 bytes
Desc: image001.gif
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050718/a29981e5/attachment.gif>
More information about the opencms-dev
mailing list