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.
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?