dhis2-users team mailing list archive

["Friedman, Roger (CDC/CCID/NCHHSTP) (CTR)" <rdf4@xxxxxxx>]

Hi Knut,

    I had already deployed the war file and was able to start it when I wrote, but there was no data in MySql so I knew it wasn't right.

    I have created the environment variable and the hibernate.properties file.  I bounced the dhis app and it didn't create the database.

    So I stopped Tomcat, created the DB in MySql per the instructions and created tables with the 2 .sql procedures.  The monthly periods are now in the DB.

    I downloaded GeoServer per the instructions, I also downloaded the MySql plugin but didn't install it.

    I restarted Tomcat, but I no longer get the Tomcat manager, Jetty seems to have taken over port 8080.

Help! Roger

 

From: Knut Staring [mailto:knutst@xxxxxxxxx] 
Sent: Monday, March 01, 2010 8:46 AM
To: Friedman, Roger (CDC/CCID/NCHHSTP) (CTR)
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Getting started

 

Hi Roger,

 

There is still some consolidation of the relevant information needed, but for a Linux server we have quite a bit of information starting on page 7 of the (latest build of the) documentation: http://dhis.uio.no/ci/job/Dhis2%20documentation/ 

 

In general, if you already have Tomcat and a database engine (Postgres or Mysql) installed, it boils down a few steps:

 

1) Put the war file in tomcat/webapps

2) Create an environment variable called DHIS2_HOME set equal to the path to your configuration folder (placed anywhere you like).

3) Create a file called hibernate.properties in the configuration folder, pointing to your database. The manual has the settings for Postgres, for Mysql it should be along these lines:

http://208.76.222.114/confluence/display/DOC/MySQL#MySQL-PrepareMySQLforDHIS2

 

When it comes to loading facilities I first recommend tools like PgAdmin or Toad. You first have to populate the Source table with facility primary keys, and then start with the top of the hierarchy (e.g. the country, then provinces, then districts, facilities) to ensure the foreign keys have references in the organisationunit table.

 

Knut

 

 

On Mon, Mar 1, 2010 at 11:35 AM, Friedman, Roger (CDC/CCID/NCHHSTP) (CTR) <rdf4@xxxxxxx> wrote:

	  Hi all.  Where are the installation instructions for server version (Tomcat)?  Also, is there a detailed data model anywhere, I would like to load facility list and shapefile relationships from existing  sources.  Also more information on patient-level data.
	Thanks, Roger

	
	_______________________________________________
	Mailing list: https://launchpad.net/~dhis2-users
	Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
	Unsubscribe : https://launchpad.net/~dhis2-users
	More help   : https://help.launchpad.net/ListHelp




-- 
Cheers,
Knut Staring