[opencms-dev] Oracle and OpenCMS 5 Installation Error

[Eke, Kemi]

Hi Everyone

Has anyone run into password problems getting into the OpenCMS application
when connected to Oracle 8i/9i?  I have installed OpenCMS in several setups
beforehand and have got it working, so this isn't a CAPS LOCK issue :)

I am currently trying to install OpenCMS 5 in the following environment:

RedHat Linux 9
Java Runtime Environment 1.4.2 from Sun
Oracle 9i (9.2.0.3) on a Tru64 5.1a box.
Apache Tomcat 4.1.27

1)Installed the JRE 1.4.2_01 and Tomcat and they work together.  
2)Installed the opencms.war file to the /webapps dir under Tomcat and once
this had been expanded installed the nls_charset12.jar, classes12.jar and
ocrs12.jar to WEB-INF/lib to allow JDBC connections to Oracle.
3)Restarted Tomcat and then ran the ocsetup files.

The whole setup procedure runs very smoothly, JDBC connections are made and
tables are created, and importing the workplace shows no errors onscreen.
(I have a copy if anyone is interested in seeing it).  I then go to
http://localhost:8080/opencms/opencms and the greeting page comes up saying
successful installation, and has a link to /opencms/opencms/system/login.  I
click on this link and the login page is displayed, type in the default user
and password (Admin/admin) and get the following error:

com.opencms.core.CmsException: 10 Unknown User. Detailed error: [OpenCms
login failed]. 
	at
com.opencms.workplace.CmsLoginNew.getContent(CmsLoginNew.java:150)
	at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)
	at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)
	at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache
.java:149)
	at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)
	at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)
	at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)
	at com.opencms.core.OpenCms.showResource(OpenCms.java:956)
	at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
	at
com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:331)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.ja
va:191)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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:2416)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.invok
eNext(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:601)
	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:534)

I've also run the install against the latest oracle jdbc jar ojdbc14.jar
instead of classes12.jar with the same error although I'm not sure if this
is a problem as well... http://65.61.175.198/t879314.html, (the password
field in the oracle database being a varchar2 field). I've checked solutions
that other users have used on this forum, such as renaming zip files from
classes12.zip to classes13.zip and using the genericANSI install to no
avail.

I have installed OpenCMS with the following setups:

1)RedHat Linux 9/Java Dev Kit 1.4.2 from Sun/MySQL/Apache Tomcat 4.1.27
2)Win2k/JDK 1.4.2/MySQL Windows 4.0.14/Apache Tomcat 4.1.27

both with no errors and a working workplace.  I have also set it up with

RedHat Linux 9/Java Dev Kit 1.4.2/Apache Tomcat 4.1.27/Oracle 9i 9.2.0.1 on
VMWare on Windows Virtual Machine and Win2k/Java Dev Kit 1.4.2/Apache Tomcat
4.1.27/Oracle 8i 8.1.7 and have run into the same problem.  All tables are
created, data is placed in the Oracle tables, success screen comes up and
then logging in it won't accept Admin/admin with the above exception being
thrown. OpenCMS looks like a neat bit of kit from the testing I've done but
I'd just like to get it working on Oracle.

Any advice/debugging tips would be appreciated,
TIA

Kemi Eke
Software Developer
Comm Fund London

Information contained in this email plus any attachment is intended for
the use of the addressee only and is confidential, proprietary and may
be privileged. Any dissemination, distribution, copying or use of this
communication without the prior permission of the sender is prohibited.
If you are not the intended recipient you must not copy this message or
attachment or disclose the contents to any other person, but are
requested to telephone or email the sender and delete the message and
any attachment from your system. The contents of this message will not
be in any way binding upon the Community Fund. Opinions, conclusions,
contractual obligations and other information in this message, in so far
as they relate to the official business of the Community Fund, must be
specifically confirmed in writing by the Community Fund.
___________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com