We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Installation problems]

I checked the openClinica.xml (…/catalina/localhost/) I’ve changed connectionName, and connectionPassword (could not find instructions about this in the installation file)



As per the Catalina.log, there are not startup errors
The following is the Catalina start up and the error generated when I try to run Openclinica. Any help is appreciated

Regards, Adel

13-Jun-2006 17:29:25 org.apache.catalina.startup.Catalina start
INFO: Server startup in 13829 ms
13-Jun-2006 17:29:59 org.akaza.openclinica.core.SessionManager setupDataSource
INFO: looking up postgres...
java.lang.NullPointerException
at org.akaza.openclinica.dao.login.UserAccountDAO.findByUserName(Unknown
Source)
at org.akaza.openclinica.core.SessionManager.(Unknown Source)
at org.akaza.openclinica.control.core.SecureController.process(Unknown S
ource)
at org.akaza.openclinica.control.core.SecureController.doGet(Unknown Sou
rce)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)
13-Jun-2006 17:29:59 org.akaza.openclinica.control.core.SecureController process

WARNING: OpenClinicaException:: org.akaza.openclinica.control.SecureController::
null
java.lang.NullPointerException
at org.akaza.openclinica.control.core.SecureController.forwardPage(Unkno
wn Source)
at org.akaza.openclinica.control.core.SecureController.forwardPage(Unkno
wn Source)
at org.akaza.openclinica.control.core.SecureController.process(Unknown S
ource)
at org.akaza.openclinica.control.core.SecureController.doGet(Unknown Sou
rce)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)

From: Tom Hickerson [mailto:[email protected]]
Sent: 13 June 2006 16:17
To: Adel Taweel
Cc: [email protected]
Subject: RE: [Users] Installation problems

Hi Adel,

A couple of questions:
1. In the XML for the configuration file (OpenClinica.xml) does the setup for the security Realm have the correct database URL, username and password for your system?
2. Are there any error log messages that generate either when you start up the application, or when you try to log in (they should be in logs/catalina.out)?

Let us know what you find, and we can try to help.

Thanks,
Tom
Sent: Tue 6/13/2006 10:15 AM
Cc: [email protected]
Subject: [Users] Installation problems
Hi,
I've installed OpenClinica 1.02 , it seems to have installed fine until I enter the login information, then it dies!! Trying the loign displays the following message, anyone can help?

regards, Adel

Comments

  • Jun XuJun Xu Posts: 20
    Just from the error log you provided, it looks like a database connection problem.
    In your OpenClinica.xml, there are several places you need to change. The instruction can be found in INSTALL-linux.txt if you use Linux, please download a .doc version installation guide if you use Windows.
    See the example below :












    url
    jdbc:postgresql://localhost:5432/openclinica


    driverClassName
    org.postgresql.Driver


    username
    clinica


    password
    clinica


    maxActive
    50


    maxWait
    -1


    maxIdle
    10




    Please check those places and see whether you have correct values there.
    Thanks,
    Jun
    ------------------------------------------
    Jun Xu
    Developer/Analyst
    Akaza Research
    One Kendall Square, Bldg 400, Fourth Floor
    Cambridge, MA 02139
    p 617.621.8585 x20
    f 617.621.0065
    "Open informatics for public research"
    http://www.akazaresearch.com/
    http://www.openclinica.org/
  • adelt00adelt00 Posts: 5
    Thanks for your reply.
    I've changed the openclinica.xml file as per the instructions in the install-windows.doc (the one package with release 1.02), as for the first time. However, it does not include info about the changes to make to the openclinica.xml file apart from those to the and tags. I've installed it on windows.
    I changed the username to "postgres" and set the password to the one I used for postgres. However, after runing it, and trying to login, it says " You have logged out of the application. Please go to the Login Page in order to re-enter OpenClinica." It does not allow to re-login again even if I start tomcat.
    Looking at the error log this time (below), you are right it is a db connection problem, but cannot figure out why it is failing to create JDBC driver! :
    > ...
    > 15-Jun-2006 16:23:54 org.apache.catalina.startup.Catalina start
    > INFO: Server startup in 9296 ms
    > 15-Jun-2006 16:24:04 org.akaza.openclinica.core.SessionManager setupDataSource
    > INFO: looking up postgres...
    > 15-Jun-2006 16:24:04 org.akaza.openclinica.dao.core.EntityDAO select
    > WARNING: Exeception while executing dynamic query, GenericDAO.select: select * f
    > rom user_account where user_name=?:message: Cannot create JDBC driver of class '
    > ' for connect URL 'null'
    > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of cla
    > ss '' for connect URL 'null'
    > at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
    > aSource.java:780)
    > at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSo
    > urce.java:540)
    > at org.akaza.openclinica.dao.core.EntityDAO.select(Unknown Source)
    > at org.akaza.openclinica.dao.login.UserAccountDAO.findByUserName(Unknown
    > Source)
    > at org.akaza.openclinica.core.SessionManager.(Unknown Source)
    > at org.akaza.openclinica.control.core.SecureController.process(Unknown S
    > ource)
    > at org.akaza.openclinica.control.core.SecureController.doGet(Unknown Sou
    > rce)
    > at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
    > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    > icationFilterChain.java:252)
    > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    > ilterChain.java:173)
    > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    > alve.java:213)
    > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    > alve.java:178)
    > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
    > torBase.java:524)
    > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    > ava:126)
    > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    > ava:105)
    > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    > ve.java:107)
    > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    > a:148)
    > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    > :869)
    > at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
    > rocessConnection(Http11BaseProtocol.java:664)
    > at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
    > int.java:527)
    > at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
    > lowerWorkerThread.java:80)
    > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
    > ool.java:684)
    > at java.lang.Thread.run(Thread.java:595)
    > Caused by: java.lang.NullPointerException
    > at org.postgresql.Driver.parseURL(Driver.java:302)
    > at org.postgresql.Driver.acceptsURL(Driver.java:170)
    > at java.sql.DriverManager.getDriver(DriverManager.java:232)
    > at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat
    > aSource.java:773)
    > ... 23 more
    > 15-Jun-2006 16:24:04 org.akaza.openclinica.control.core.SecureController process
    >
    > INFO: user bean from SessionManager:
    Jun Xu akazaresearch.com wrote:
    >
    > Hi Adel,
    >
    > Just from the error log you provided, it looks like a database connection problem.
    >
    > In your OpenClinica.xml, there are several places you need to change. The instruction can be found in INSTALL-linux.txt if you use Linux, please download a .doc version installation guide if you use Windows.
    >
    > See the example below :
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > connectionURL="jdbc:postgresql://localhost:5432/openclinica" connectionName="clinica" connectionPassword="clinica" userTable="user_account"
    >
    > userNameCol="user_name" userCredCol="passwd" userRoleTable="study_user_role" roleNameCol="role_name"/>
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > url
    >
    > jdbc:postgresql://localhost:5432/openclinica
    >
    >
    >
    >
    >
    > driverClassName
    >
    > org.postgresql.Driver
    >
    >
    >
    >
    >
    > username
    >
    > clinica
    >
    >
    >
    >
    >
    > password
    >
    > clinica
    >
    >
    >
    >
    >
    > maxActive
    >
    > 50
    >
    >
    >
    >
    >
    > maxWait
    >
    > -1
    >
    >
    >
    >
    >
    > maxIdle
    >
    > 10
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > Please check those places and see whether you have correct values there.
    >
    >
    >
    > Thanks,
    >
    > Jun
    >
    > ------------------------------------------
    >
    > Jun Xu
    >
    > Developer/Analyst
    >
    > Akaza Research
    >
    > One Kendall Square, Bldg 400, Fourth Floor
    >
    > Cambridge, MA 02139
    >
    > p 617.621.8585 x20
    >
    > f 617.621.0065
    >
    > "Open informatics for public research"
    >
    > http://www.akazaresearch.com/
    >
    > http://www.openclinica.org/
    >
    >
    >
This discussion has been closed.