Mysql version database dump for version 2.9

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the dump but only finding the postgress version. We want to avoid postgress as we do not have personnel experienced in it.

Regards,

Hi, to start with your own data, just connect to an empty mysql db. The dump is just for the demo data. What is your use case?

···

Sent from my mobile

On Oct 1, 2012 5:10 PM, “Judge Muzinda” jmuzinda@gmail.com wrote:

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the dump but only finding the postgress version. We want to avoid postgress as we do not have personnel experienced in it.

Regards,


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi Knut,

I want to use the DHIS2 Web API in another applications , without doing anything to the DHIS2 core code, so I just want to setup DHIS as quickly as possible , which means just the war file and the dump. The main issue I have with setting DHIS from code is that maven is failing to resolve all dependencies hosted on org.hisp domain.

Thanks,
···

On 01/10/2012 13:13, Knut Staring wrote:

    Hi, to start with your own data, just connect to an empty mysql db. The dump is just for the demo data. What is your use case?

Sent from my mobile

    On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com        > wrote:

Hi all,

      Please assist, we want to run DHIS 2.9 on mysql, been searching for the dump but only finding the postgress version. We want to avoid postgress as we do not have personnel experienced in it.



      Regards,



      _______________________________________________

      Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

      Post to     : dhis2-devs@lists.launchpad.net

      Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

      More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

Since you're not changing the source, just get the latest dhis.war
file from here:
http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

I suppose if your usage of the Web API is relatively limited, you
could perhaps connect directly to our online demo (though this is not
a good idea if you are planning some heavy testing).

As for converting the Postgres demo db to Mysql, I think Mysql used to
come with some free importing/converting tools that could do that, but
did not find anything about this through a quick googling now.
Commercial tools like Navicat should handle it well. If you do convert
it, pls share.

Best,
Knut

···

On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda <jmuzinda@gmail.com> wrote:

Hi Knut,

I want to use the DHIS2 Web API in another applications , without doing
anything to the DHIS2 core code, so I just want to setup DHIS as quickly as
possible , which means just the war file and the dump. The main issue I have
with setting DHIS from code is that maven is failing to resolve all
dependencies hosted on org.hisp domain.

Thanks,

On 01/10/2012 13:13, Knut Staring wrote:

Hi, to start with your own data, just connect to an empty mysql db. The dump
is just for the demo data. What is your use case?

Sent from my mobile

On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com> wrote:

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the
dump but only finding the postgress version. We want to avoid postgress as
we do not have personnel experienced in it.

Regards,

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522

Overall though, I do recommend just trying Postgres - for basic use it
is not too different from MySql.

If you are on Windows, get the installer from here:
http://www.enterprisedb.com/products-services-training/pgdownload#windows

···

On Mon, Oct 1, 2012 at 2:39 PM, Knut Staring <knutst@gmail.com> wrote:

Since you're not changing the source, just get the latest dhis.war
file from here:
DHIS2 App Hub

I suppose if your usage of the Web API is relatively limited, you
could perhaps connect directly to our online demo (though this is not
a good idea if you are planning some heavy testing).

As for converting the Postgres demo db to Mysql, I think Mysql used to
come with some free importing/converting tools that could do that, but
did not find anything about this through a quick googling now.
Commercial tools like Navicat should handle it well. If you do convert
it, pls share.

Best,
Knut

On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda <jmuzinda@gmail.com> wrote:

Hi Knut,

I want to use the DHIS2 Web API in another applications , without doing
anything to the DHIS2 core code, so I just want to setup DHIS as quickly as
possible , which means just the war file and the dump. The main issue I have
with setting DHIS from code is that maven is failing to resolve all
dependencies hosted on org.hisp domain.

Thanks,

On 01/10/2012 13:13, Knut Staring wrote:

Hi, to start with your own data, just connect to an empty mysql db. The dump
is just for the demo data. What is your use case?

Sent from my mobile

On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com> wrote:

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the
dump but only finding the postgress version. We want to avoid postgress as
we do not have personnel experienced in it.

Regards,

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522

Hi Knut,

Thanks so much for the useful information, I am on Ubuntu 12.04, so I will definitely try it out. I will share my experience with the community, on a second note , there is the issue of the dependencies failing to be resolved, especially the org.hisp, I am from Zimbabwe I am not sure if it has anything to do with my location.

···

On 01/10/2012 14:41, Knut Staring wrote:

Overall though, I do recommend just trying Postgres - for basic use it
is not too different from MySql.

If you are on Windows, get the installer from here:
Community DL Page

On Mon, Oct 1, 2012 at 2:39 PM, Knut Staring <knutst@gmail.com> wrote:

Since you're not changing the source, just get the latest dhis.war
file from here:
DHIS2 App Hub

I suppose if your usage of the Web API is relatively limited, you
could perhaps connect directly to our online demo (though this is not
a good idea if you are planning some heavy testing).

As for converting the Postgres demo db to Mysql, I think Mysql used to
come with some free importing/converting tools that could do that, but
did not find anything about this through a quick googling now.
Commercial tools like Navicat should handle it well. If you do convert
it, pls share.

Best,
Knut

On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda <jmuzinda@gmail.com> wrote:

Hi Knut,

I want to use the DHIS2 Web API in another applications , without doing
anything to the DHIS2 core code, so I just want to setup DHIS as quickly as
possible , which means just the war file and the dump. The main issue I have
with setting DHIS from code is that maven is failing to resolve all
dependencies hosted on org.hisp domain.

Thanks,

On 01/10/2012 13:13, Knut Staring wrote:

Hi, to start with your own data, just connect to an empty mysql db. The dump
is just for the demo data. What is your use case?

Sent from my mobile

On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com> wrote:

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the
dump but only finding the postgress version. We want to avoid postgress as
we do not have personnel experienced in it.

Regards,

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Hi Judge

Did you remember to do all the steps when compiling the source?

  1. cd dhis-2 && mvn clean install -DskipTests=true

  2. cd dhis-web && mvn clean install -DskipTests=true

···


Morten

On Mon, Oct 1, 2012 at 7:53 PM, Judge Muzinda jmuzinda@gmail.com wrote:

Hi Knut,

Thanks so much for the useful information, I am on Ubuntu 12.04, so I will definitely try it out. I will share my experience with the community, on a second note , there is the issue of the dependencies failing to be resolved, especially the org.hisp, I am from Zimbabwe I am not sure if it has anything to do with my location.

On 01/10/2012 14:41, Knut Staring wrote:

Overall though, I do recommend just trying Postgres - for basic use it

is not too different from MySql.

If you are on Windows, get the installer from here:

http://www.enterprisedb.com/products-services-training/pgdownload#windows

On Mon, Oct 1, 2012 at 2:39 PM, Knut Staring knutst@gmail.com wrote:

Since you’re not changing the source, just get the latest dhis.war

file from here:

http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

I suppose if your usage of the Web API is relatively limited, you

could perhaps connect directly to our online demo (though this is not

a good idea if you are planning some heavy testing).

As for converting the Postgres demo db to Mysql, I think Mysql used to

come with some free importing/converting tools that could do that, but

did not find anything about this through a quick googling now.

Commercial tools like Navicat should handle it well. If you do convert

it, pls share.

Best,

Knut

On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda jmuzinda@gmail.com wrote:

Hi Knut,

I want to use the DHIS2 Web API in another applications , without doing

anything to the DHIS2 core code, so I just want to setup DHIS as quickly as

possible , which means just the war file and the dump. The main issue I have

with setting DHIS from code is that maven is failing to resolve all

dependencies hosted on org.hisp domain.

Thanks,

On 01/10/2012 13:13, Knut Staring wrote:

Hi, to start with your own data, just connect to an empty mysql db. The dump

is just for the demo data. What is your use case?

Sent from my mobile

On Oct 1, 2012 5:10 PM, “Judge Muzinda” jmuzinda@gmail.com wrote:

Hi all,

Please assist, we want to run DHIS 2.9 on mysql, been searching for the

dump but only finding the postgress version. We want to avoid postgress as

we do not have personnel experienced in it.

Regards,


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Hi Morten,

Thanks I ran these commands, however on the clean install command it manages to resolve and download all other dependencies except the org.hisp ones.

Regards,
···

On 01/10/2012 15:01, Morten Olav Hansen wrote:

Hi Judge

    Did you remember to do all the steps when compiling the source?
  1. cd dhis-2 && mvn clean install -DskipTests=true
  1. cd dhis-web && mvn clean install -DskipTests=true

    Morten




      On Mon, Oct 1, 2012 at 7:53 PM, Judge Muzinda <jmuzinda@gmail.com>
      wrote:

Hi Knut,

        Thanks so much for the useful information, I am on Ubuntu 12.04, so I will definitely try it out. I will share my experience with the community, on a second note , there is the issue of the dependencies failing to be resolved, especially the org.hisp, I am from Zimbabwe I am not sure if it has anything to do with my location.






            On 01/10/2012 14:41, Knut Staring wrote:
              Overall though, I do recommend just trying Postgres - for basic use it

              is not too different from MySql.



              If you are on Windows, get the installer from here:

              [http://www.enterprisedb.com/products-services-training/pgdownload#windows](http://www.enterprisedb.com/products-services-training/pgdownload#windows)



              On Mon, Oct 1, 2012 at 2:39 PM, Knut Staring <knutst@gmail.com                  > wrote:
                Since you're not changing the source, just get the latest dhis.war

                file from here:

                [http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war](http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war)



                I suppose if your usage of the Web API is relatively limited, you

                could perhaps connect directly to our online demo (though this is not

                a good idea if you are planning some heavy testing).



                As for converting the Postgres demo db to Mysql, I think Mysql used to

                come with some free importing/converting tools that could do that, but

                did not find anything about this through a quick googling now.

                Commercial tools like Navicat should handle it well. If you do convert

                it, pls share.



                Best,

                Knut



                On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda <jmuzinda@gmail.com                    > wrote:

Hi Knut,

                  I want to use the DHIS2 Web API in another applications , without doing

                  anything to the DHIS2 core code, so I just want to setup DHIS as quickly as

                  possible , which means just the war file and the dump. The main issue I have

                  with setting DHIS from code is that maven is failing to resolve all

                  dependencies hosted on org.hisp domain.



                  Thanks,





                  On 01/10/2012 13:13, Knut Staring wrote:



                  Hi, to start with your own data, just connect to an empty mysql db. The dump

                  is just for the demo data. What is your use case?



                  Sent from my mobile



                  On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com                      > wrote:

Hi all,

                    Please assist, we want to run DHIS 2.9 on mysql, been searching for the

                    dump but only finding the postgress version. We want to avoid postgress as

                    we do not have personnel experienced in it.



                    Regards,



                    _______________________________________________

                    Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

                    Post to     : dhis2-devs@lists.launchpad.net

                    Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

                    More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
                --

                Knut Staring

                Dept. of Informatics, University of Oslo

                +4791880522

                [http://dhis2.org](http://dhis2.org)
            _______________________________________________

            Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            Post to     : dhis2-devs@lists.launchpad.net

            Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

What are those dependencies? we don’t depend on external dependencies in the org.hisp namespace… maybe your dhis-2 build fails somewhere?

···


Morten

On Mon, Oct 1, 2012 at 8:15 PM, Judge Muzinda jmuzinda@gmail.com wrote:

Hi Morten,

Thanks I ran these commands, however on the clean install command it manages to resolve and download all other dependencies except the org.hisp ones.



Regards,



  On 01/10/2012 15:01, Morten Olav Hansen wrote:

Hi Judge

    Did you remember to do all the steps when compiling the source?
  1. cd dhis-2 && mvn clean install -DskipTests=true
  1. cd dhis-web && mvn clean install -DskipTests=true

    Morten




      On Mon, Oct 1, 2012 at 7:53 PM, Judge Muzinda <jmuzinda@gmail.com> > >           wrote:

Hi Knut,

        Thanks so much for the useful information, I am on Ubuntu 12.04, so I will definitely try it out. I will share my experience with the community, on a second note , there is the issue of the dependencies failing to be resolved, especially the org.hisp, I am from Zimbabwe I am not sure if it has anything to do with my location.






            On 01/10/2012 14:41, Knut Staring wrote:
              Overall though, I do recommend just trying Postgres - for basic use it

              is not too different from MySql.



              If you are on Windows, get the installer from here:

              [http://www.enterprisedb.com/products-services-training/pgdownload#windows](http://www.enterprisedb.com/products-services-training/pgdownload#windows)



              On Mon, Oct 1, 2012 at 2:39 PM, Knut Staring <knutst@gmail.com                  > wrote:
                Since you're not changing the source, just get the latest dhis.war

                file from here:

                [http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war](http://apps.dhis2.org/ci/job/dhis-web-trunk/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war)






                I suppose if your usage of the Web API is relatively limited, you

                could perhaps connect directly to our online demo (though this is not

                a good idea if you are planning some heavy testing).



                As for converting the Postgres demo db to Mysql, I think Mysql used to

                come with some free importing/converting tools that could do that, but

                did not find anything about this through a quick googling now.

                Commercial tools like Navicat should handle it well. If you do convert

                it, pls share.



                Best,

                Knut



                On Mon, Oct 1, 2012 at 2:14 PM, Judge Muzinda <jmuzinda@gmail.com                    > wrote:

Hi Knut,

                  I want to use the DHIS2 Web API in another applications , without doing

                  anything to the DHIS2 core code, so I just want to setup DHIS as quickly as

                  possible , which means just the war file and the dump. The main issue I have

                  with setting DHIS from code is that maven is failing to resolve all

                  dependencies hosted on org.hisp domain.



                  Thanks,





                  On 01/10/2012 13:13, Knut Staring wrote:



                  Hi, to start with your own data, just connect to an empty mysql db. The dump

                  is just for the demo data. What is your use case?



                  Sent from my mobile



                  On Oct 1, 2012 5:10 PM, "Judge Muzinda" <jmuzinda@gmail.com                      > wrote:

Hi all,

                    Please assist, we want to run DHIS 2.9 on mysql, been searching for the

                    dump but only finding the postgress version. We want to avoid postgress as

                    we do not have personnel experienced in it.



                    Regards,



                    _______________________________________________

                    Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

                    Post to     : dhis2-devs@lists.launchpad.net

                    Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

                    More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
                --

                Knut Staring

                Dept. of Informatics, University of Oslo

                +4791880522

                [http://dhis2.org](http://dhis2.org)
            _______________________________________________

            Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            Post to     : dhis2-devs@lists.launchpad.net

            Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)