Need help with new installation

[Friedman, Roger (CDC/CCID/NCHHSTP) (CTR)]

Folks --

    I am trying to set up a new instance based on OpenMRS Express HIV.  I have successfully installed Tomcat 6.0.18 and MySql 5.1 as Windows XP services.  I have successfully loaded the database using the create script from OpenMRS Express HIV.  I have copied the entire OpenMRS directory structure from the OpenMRS ExpressHIV installation into C:\, including the properties file, and have set the environment variable to point at the properties file.  I have deployed OpenMRS, both the version in OpenMRS Express HIV and 1.3.4 downloaded from OpenMRS.org (I don't want to undertake changing from BIRT 2.2 until after things are functioning and I understand them more).  However, in both cases, Tomcat fails to start OpenMRS with the message Application at context path /openmrs could not be started.  The stdout log starts as follows:

 

WARN - Listener.getRuntimeProperties(467) |2009-07-30 15:37:46,062| Using runtime properties file: c:\program files\openmrs\OpenMRS-runtime.properties
ERROR - HibernateSessionFactoryBean.checkDatabaseConnection(118) |2009-07-30 15:38:08,734| Error while starting up.  Unable to connection using
java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused: connect'.

 

** BEGIN NESTED EXCEPTION **

 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

 

STACKTRACE:

 

java.net.SocketException: java.net.ConnectException: Connection refused: connect
 at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
 at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
 at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at org.openmrs.api.db.hibernate.HibernateSessionFactoryBean.checkDatabaseConnection(HibernateSessionFactoryBean.java:113)

Any suggestions?  Also, can I expect the modules copied over with the OpenMRS directory structure to function, or do I have to do something more to get them going?  I noticed some tables had been added to the database related to the modules.

Thanks, Roger

Phillipe -- If you want to try this together, I have free time in Geneva Monday

[Boucher, Phillipe Jean-Pierre]

Hi,

 

The OpenMRS Express package currently does not work with OpenMRS 1.5 out of the box.  I'm currently in the process of sorting it out. 

 

P

 

 

Philippe Boucher
Health Care Informatics unit, department of Health Statistics and Informatics
World Health Organization,
20 Appia, 1211 Geneva 27, Switzerland
email: bouc...@who.int
+41 22 791 3688

---