dhis2-users team mailing list archive

[Hannan Khan <hannank@xxxxxxxxx>]

Hi Rebecca

Theoretically you can use MySQL and the hibernate.properties is as follows:


hibernate.dialect = org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://localhost/dhis2
hibernate.connection.username = xxxx
hibernate.connection.password = xxxx

But I suggest to use Postgres other wise you get plenty of bugs. We use
MySQL since 2011 and then we converted all our databases to postgres for
various reasons.

Regards

Hannan Khan
HISP Bangladesh


On Thu, Dec 3, 2015 at 1:08 AM, Smith, Rebecca A. <rs3524@xxxxxxxxxxxxxxxxx>
wrote:

> Thanks Iuri and Lars! This is very helpful.
>
> -----Original Message-----
> From: Iuri Fanti [mailto:iuri.fanti@xxxxxxxxx]
> Sent: Wednesday, December 02, 2015 12:24 PM
> To: Lars Helge Øverland
> Cc: Smith, Rebecca A.; dhis2-users@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Dhis2-users] MySQL for DHIS
>
> Hi,
>
> we tried to use MySQL, but it didn't work when we had to use OptionsSet
> values in DataElements for single events without registration. The
> OptionSet resulted empty, evidently because of some problem fetching data
> from MySQL.
>
> Iuri
>
> 2015-12-02 17:14 GMT+01:00 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> > Hi Rebecca,
> >
> > in order to use MySQL there is nothing else you need to do (beyond
> > changing the database connection config properties like you say).
> >
> > Now MySQL is far less tested with DHIS 2 compared to Postgres so you
> > are more likely to come across bugs and upgrade issues on MySQL.
> >
> > There is also a fair chance that we will create Postgres-only features
> > at some point in the future (as an example, using features from the
> > PostGIS spatial data extension).
> >
> > So MySQL works, but Postgres would be preferred.
> >
> >
> > best regards,
> >
> > Lars
> >
> >
> >
> > On Wed, Dec 2, 2015 at 4:29 PM, Smith, Rebecca A.
> > <rs3524@xxxxxxxxxxxxxxxxx>
> > wrote:
> >>
> >> Hi all,
> >>
> >>
> >>
> >> We have a partner who would strongly prefer to use MySQL instead of
> >> Postgres as the DHIS 2.21 database. The DHIS documentation notes that
> >> MySQL can be used but doesn’t give much detail beyond the connection
> strings.
> >>
> >>
> >>
> >> Does anyone in this group have experience with using MySQL for DHIS?
> >> Has it been reliable? Do you have to do any manual configuration that
> >> you wouldn’t do with Postgres?
> >>
> >>
> >>
> >> Thanks,
> >>
> >> Becky
> >>
> >>
> >>
> >>
> >>
> >> Becky Smith
> >>
> >> Development-Operations Specialist
> >>
> >> ICAP at Columbia University
> >>
> >> Tel: 212.304.7115
> >>
> >> Email: rs3524@xxxxxxxxxxxxxxxxx
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> 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
> >>
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > http://www.dhis2.org
> >
> >
> > _______________________________________________
> > 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
> >
>
>
>
> --
> "The best argument against democracy is a five-minute conversation with
> the average voter." - Winston Churchill
> @-`-,--
> _______________________________________________
> 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
>