Hi All,
I am Dilanka Rathnayake, final year undergraduate student of Department of Computer Engineering, Faculty of Engineering, University of Peradeniya, Sri Lanka.
I went through the all the project ideas that have been published by ‘OpenMRS’ and I think ‘Patient Flags REST API’ project is more suitable according to the knowledge that I have acquired during my undergraduate courses and the experience gained by doing various projects in my internship program. And also i strongly believe that this would be more beneficial to my future carrier development as well. Furthermore I have very good knowledge about Restful APIs, Spring, Struts2, Hibernate, HTML, JavaScript/AngularJs, CSS/Bootstrap.
I tried to install ‘OpenMRS’ according to Installing OpenMRS - Documentation - OpenMRS Wiki and I did following things
- Installed Java 7 (jre1.7.0_79) as you told ‘‘Java 8 is not currently supported (April 7, 2014)’’
- Installed apache-tomcat-6.0.29
- installed mysql by ‘sudo apt-get install mysql-server’
- Downloaded ‘OpenMRS 2.3.1 Standalone Edition’ and ‘War’ file separately.
When I run standalone edition by ‘run-on-unix.sh’ then first time it started sucessfully. but then when i start it It gives error like below:
com.mysql.management.util.SQLRuntimeException: User initialization error. Can not connect as root with password. Can not connect as root without password. URL: jdbc:mysql://127.0.0.1:3317/mysql
the I deleted current ‘standalone edition’ and re ran ‘run-on-unix.sh’. the it gives below error:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
and I deployed separate war file into webapp folder in tomcat and when i run ‘catalina.sh’ it gives this error:
Unable to find a runtime properties file at /home/dilanka/GSOC16/OpenMRS/apache-tomcat-6.0.29/bin/openmrs-runtime.properties
Then I copied ‘openmrs-runtime.properties’ into bin. then I get following error:
java.lang.RuntimeException: Error occurred while trying to get the updates needed for the database. Unable to get a connection to the database. Please check your openmrs runtime properties file and make sure you have the correct connection.username and connection.password set
what should i give to connection.username
and connection.password
in openmrs-runtime.properties
file.
I went through Troubleshooting Installation - Documentation - OpenMRS Wiki and when I check my db according to that the it says there is no db called ‘OpenMRS’
Please be kind enough to solve this errors and provide more details about the project and i really appreciate your cooperation on this matter.
Best Regards, Dilanka Rathnayake.