dhis2-users team mailing list archive

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

Thanks, Knut --

    After rebooting, Tomcat could not start DHIS2, there were a lot of SQL errors due to the pre-existence of the tables.  So I dropped and recreated the database and now it has started OK, periodtype is populated, can add a user, users is populated, looks like we are on the road.

Thanks, Roger

 

 

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

 

One problem with using an environment variable is that you sometimes have to reboot Windows for it to take effect - which is very annoying. In order to check that you are indeed connected to the right database, please go to Help -> About DHIS 2 to verify your connection. E.g. here in the online demo:

http://dhis.uio.no/demo/dhis-web-commons-about/about.action

 

Knut

On Mon, Mar 1, 2010 at 5:22 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

The time periods are generated on a "need to have" basis, i.e. if you select a new year in the data entry view, more periods will be generated.

 

 

On Mon, Mar 1, 2010 at 5:21 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

Right, I realized just now that it was the Jetty that comes with Geoserver that was blocking Tomcat. I take it you are working on Windows? You'll either have to change one of the ports or run one of them at a time - which should be fine for now. The alternative would be to just move the Geoserver webapp to Tomcat.

 

Since you can create users, Hibernate has probably done what it is supposed to do, namely create the (mostly empty) database tables, although I find it strange that the users table is empty if you have created a new user.

 

Knut

 

On Mon, Mar 1, 2010 at 4:52 PM, Friedman, Roger (CDC/CCID/NCHHSTP) (CTR) <rdf4@xxxxxxx> wrote:

By stopping the Geoserver service, I got access to Tomcat back again.  I can log into DHIS2.  I can create a new user and login with those credentials.  It does not appear that Hibernate has done anything, I still only have the one year's worth of time periods in the database.  The users table is still empty.

 

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





-- 
Cheers,
Knut Staring





-- 
Cheers,
Knut Staring




-- 
Cheers,
Knut Staring