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

default root password not working

okay I got my server all setup and running, but when I login with the root login and pw it says my password is incorrect. I checked the User_Account table in pgAdminIII and the root account is there but the password is encrypted... which made me hesitate to manually change it. How can I fix this?
Thank you,
Jay

Comments

  • Hi Jay,

    You will probably want to make sure you are connecting to the database first, before you start to alter the contents. Double-check the OpenClinica.xml file and make sure your database information is entered TWICE; once for the Security Realm, once for the Connection Pool. This is set up this way so that OpenClinica could run with an external authenticator, like LDAP.

    If your settings are okay, you should check the log files and see what the problem is. If you can, post the messages to the list and we can continue to diagnose the problem.

    Hope this helps, Tom
  • jaygattisjaygattis Posts: 5
    I see the Realm and Connection pw info in the openclinica.xml. Here is my complete Openclinic.xml (commented out parts for Oracle excluded). After this I tried changing the clinca user password in the openclinica.xml and in pgAdminIII, but I still couldn't login - same error "Your Username and Password combination could not be found. Please try again. If you continue to have trouble, please click "Forgot Password" or contact the Administrator."
    <?xml version='1.0' encoding='utf-8'?>










    On Thu, Jul 31, 2008 at 10:00 AM, Tom Hickerson wrote:
    Hi Jay,
    You will probably want to make sure you are connecting to the database first, before you start to alter the contents. Double-check the OpenClinica.xml file and make sure your database information is entered TWICE; once for the Security Realm, once for the Connection Pool. This is set up this way so that OpenClinica could run with an external authenticator, like LDAP.
    If your settings are okay, you should check the log files and see what the problem is. If you can, post the messages to the list and we can continue to diagnose the problem.
    Hope this helps, Tom
  • Hi Jay,

    In general, everything there looks good - you could test the pwd by logging into pgAdmin as the 'clinica' user. Can you take a look at the openclinica.log file under the /logs directory to see what is happening on the back end?

    Also, users have had problems with the JDBC driver, so you might want to copy a newer one into Tomcat's common/lib directory. Here are some links/threads that you can review about this problem:

    http://openclinica.org/dokuwiki/doku.php?id=publicwiki:upgrade2.0.1driver&s=jdbc
    http://www.openclinica.org/pipermail/users/2008-May/000633.html

    Hope that helps, Tom
  • jaygattisjaygattis Posts: 5
    Thank you, downloading the JDBC driver and loading into Tomcat worked! -J
    On Thu, Jul 31, 2008 at 10:56 AM, Tom Hickerson wrote:
    Hi Jay,
    In general, everything there looks good - you could test the pwd by logging into pgAdmin as the 'clinica' user. Can you take a look at the openclinica.log file under the /logs directory to see what is happening on the back end?
    Also, users have had problems with the JDBC driver, so you might want to copy a newer one into Tomcat's common/lib directory. Here are some links/threads that you can review about this problem:
    http://openclinica.org/dokuwiki/doku.php?id=publicwiki:upgrade2.0.1driver&s=jdbc
    http://www.openclinica.org/pipermail/users/2008-May/000633.html
    Hope that helps, Tom
This discussion has been closed.