• FEATURES
  • PRICING
  • MARKETPLACE
  • CASE STUDIES
  • BLOG
  • Openspecimen not working

    after restarting Openspecimen server the system did not work although the Apache service is running
    and mySQL service is running can someone help

    Hi @Shamil_Ansouqa,

    Seems like the OpenSpecimen did not start up after server restart. If you want to set to automatic start, refer to Start/stop server
    Did you try starting up the OpenSpecimen manually?
    If you still face issues, please check log file ${install_home}/os-data/logs/os.log to debug further.

    hi Chetan_Khilosiya, i tried to locate the log file under os-data but i could not find any log. even the hall os-data directory is empty!
    i even tried to start/stop the server nothing is working
    any ideas?

    Hi @Shamil_Ansouqa,

    OpenSpecimen log feature is added in v3.3. It seems like you are using an older version.
    So please provide Apache Tomcat log files
    ${tomcat_home}/logs/catalina.{latest_date}.log and
    ${tomcat_home}/logs/localhost.{latest_date}.log
    to evaluate the issue further.

    catalina.2016-11-08.log (93.8 KB)localhost.2016-11-08.log (56.5 KB)

    Hi Chetan,

    please find logs

    Hi @Shamil_Ansouqa,

    It seems like a server is not able to connect to a database with provided a user name and password.
    Please configure correct database server user name and password in ${tomcat_home}/conf/context.xml

    example:

    < Resource name=“jdbc/openspecimen” auth=“Container” type=“javax.sql.DataSource”
    maxActive=“100” maxIdle=“30” maxWait=“10000”
    username="{{db-username}}" password="{{db-password}}" driverClassName="{{db-driver}}"
    url="{{db-url}}"
    validationInterval=“3600”
    testOnBorrow=“true”
    validationQuery=“Select 1 from dual” />

    in this config change {{db-username}} and {{db-password}} with respective values.
    change {{db-driver}} with com.mysql.jdbc.Driver
    change {{db-url}} with server url like jdbc:mysql://< db_host >:< db_port >/< db_name >

    hi Chetan, i appreciate your help,
    i checked the context.html file, and i used the username and password to sign to MySQL command line client,
    i end up on a black screen with MySQL> prompt
    does that means i am connected to MySQL?

    i run command under MySQL> show databases; and it returns some outputs one of them is openspecimen.

    Any other suggestions?