dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hm..not quite sure which Sql procedure you are referring to. Unlike OpenMRS,
you don't need to run any scripts to create the tables, hibernate takes care
of that once the database exists and hibernate.properties contains the
correct connection info.

As for why you get Jetty popping up I'm not a 100 percent sure, however you
can change your Tomcat port (temporarily) in the file tomcat/conf/server.xml
(search for 8080 and set it to e.g. 8081, then restart Tomcat).

Alternatively, the Jetty port can be changed so it doesn't block Tomcat

Knut

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

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



-- 
Cheers,
Knut Staring