dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Yes, it is being installed as a service. There is no way (that I know
of) to kick Postgres into action with the DHIS2 live package, so it
needs to be running prior to DHIS2 trying to start.



On Wed, Mar 3, 2010 at 11:25 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
> 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
>



-- 
--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260968395190