dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Are you installing Postgres as a service? I am agnostic as to whether that
is a good idea, but if we do, we should probably call it dhis2postgres or
similar (which is what we did before).

k

On Wed, Mar 3, 2010 at 10:23 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Hi. Sounds reasonable. I have something right now that will install
> postgres with a non-standard user name and on a non-standard port.
> Clean up scripts delete this user after an uninstall as well. I am
> just adding a registry check, and if there are any other versions of
> postgres already installed, the installer will abort. What do you
> think about this?
>
>
>
> On Wed, Mar 3, 2010 at 10:27 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
> > A couple of comments:
> > While it maybe somewhat instructive to have a look at the Netbeans
> > installer, it was not targeted at Postgres and I doubt much of it would
> be
> > transferable to BitRock.
> > Also, I really think we shouldn't waste our time trying to detect all
> sorts
> > of things. Rather, there are two options:
> > 1) Create a nonstandard username for Postgres (i.e. not "postgres") and
> run
> > it on a nonstandard port (i.e. not 5432). This should avoid 99% of
> conflicts
> > 2) State very clearly in the docs and on dhis2.org that the FULL
> installer
> > is for people who don't already have a database engine installed. If you
> > already have Postgres, it would be much better to go with the minimal
> > installer, which is just DHIS2 Live and a few links in the menu. THEN we
> add
> > clear instructions as to how to modify hibernate.properties, and all is
> > well.
> > Similar clear instructions for server installation, where the full
> installer
> > would not be used would do the trick. I see very little value in putting
> > more work into the installer at this point (beyond making Postgres an
> > option).
> > I agree with Lars that we should strongly promote Postgres over Mysql
> (even
> > more so after Oracle's takeover). However, I think we should promote the
> use
> > of H2 unless it is a server-type installation.
> > Knut
> >
> > On Wed, Mar 3, 2010 at 6:01 AM, Jason Pickering
> > <jason.p.pickering@xxxxxxxxx> wrote:
> >>
> >> Hi Saptarshi,
> >>
> >> It will certainly be a lot of effort, but nothing compared to the
> >> number of  man hours devoted to DHIS2. If we cannot get this product
> >> installed on more peoples machine's, all of that development effort is
> >> just wasted. So, it is absolutely critical we get a good installer
> >> together, regardless of the effort that is required.
> >>
> >>
> >> Could you release what you did in NetBeans, and let others, like
> >> myself that are in need of a proper installer, learn from what has
> >> been done previously. Knut has provided valuable information to me
> >> with a previous BitRock installer that he was working on.
> >>
> >> I think there are ways to do this, but we will need to try and be a
> >> bit more clever. :)
> >>
> >> Let me know what you think.
> >>
> >> Regards,
> >> Jason
> >>
> >>
> >> On Tue, Mar 2, 2010 at 8:29 PM, Saptarshi Purkayastha <sunbiz@xxxxxxxxx
> >
> >> wrote:
> >> > This is what the Netbeans-based installer is doing... Infact it is
> able
> >> > to
> >> > do that for Linux, Windows, Mac and Solaris from the beginning. It was
> >> > able
> >> > to detect mysql and jre's installations on the system, tomcat was not
> >> > detectable, which could have been detected from the registry or
> services
> >> > like MySQL... but it was too much effort and I lost interest in
> >> > developing
> >> > that further...
> >> > Anyways, what happens when postgres/mysql/tomcat is already installed
> >> > and
> >> > running?? The bitrock installer screwed a few things and I know ppl
> just
> >> > uninstall it and all the data entered just goes... Possibly most
> >> > important
> >> > for an installer is to understand what's installed and not overwrite
> >> > anything, which is why msi is so good for Windows.
> >> >
> >> > ---
> >> > Regards,
> >> > Saptarshi PURKAYASTHA
> >> > Director R & D, HISP India
> >> > Health Information Systems Programme
> >> >
> >> > My Tech Blog:  http://sunnytalkstech.blogspot.com
> >> > You Live by CHOICE, Not by CHANCE
> >> >
> >> >
> >> > 2010/3/2 Jason Pickering <jason.p.pickering@xxxxxxxxx>
> >> >>
> >> >> OK. A quick update.
> >> >>
> >> >> I managed to get DHIS+Postgres installed on a "clean" system, meaning
> >> >> one without a Postgres user or previous install Postgres instance.
> >> >> This is good, as this may be 90% of the cases we will encounter for a
> >> >> first time install, but it is only part of the problem.
> >> >>
> >> >> On a system with the postgres user already there, I do not know how
> to
> >> >> get the password  in order to start the windows service, where the
> >> >> password needs to be set when the service is installed.
> >> >>
> >> >>  This is not a big deal if you can start the postgres DB from the
> >> >> command line, but will users know to do this and-or can DHIS start it
> >> >> if it is not started. So, it will install a new instance of postgres,
> >> >> but, the service cannot be started, as the password is not correct.
> >> >> Hmm..maybe there are some bright ideas out there. Perhaps we can set
> >> >> it to the system account?
> >> >>
> >> >> So basically, I can release tomorrow for testing an installer that
> >> >> will install on system without a postgres user. I tried to install
> >> >> Postgres as a different user by creating a different user account,
> but
> >> >> the installer did not manage to create it. Will need some more work
> >> >> here.
> >> >>
> >> >> Let me know what you think.
> >> >>
> >> >> Regards,
> >> >> Jason
> >> >>
> >> >> _______________________________________________
> >> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> >> More help   : https://help.launchpad.net/ListHelp
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> --
> >> Jason P. Pickering
> >> email: jason.p.pickering@xxxxxxxxx
> >> tel:+260968395190
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >
> >
> >
> > --
> > Cheers,
> > Knut Staring
> >
>
>
>
> --
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>



-- 
Cheers,
Knut Staring