On 3 March 2010 09:35, Jason Pickering <jason.p.picker...@gmail.com> wrote: > Not installing postgres as a Windows service would remove a > significant amount of the complexity of the installation. If it could > be done, it would really be great. So, prior to launching jetty, > Postgres would need to be fired up manually. It is certainly worth > considering if this is possible.
I guess that could be done from the tray app as well .. in fact it probably could be done from within the dhis startup process itself. On startup see if there is any pre-run shell script to run first by checking for scripts somewhere in dhis2_home, if so run that first, wait for it, then proceed to launch app. Gives me a few security wobblies though :-) > > > > On Wed, Mar 3, 2010 at 11:31 AM, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> If we are committed to using the dhis2-live model for the desktop >> installs - with the tray icon+jetty+hibernate-points-to-whatever - >> then it makes sense to expand on our current lonely "exit" option to >> include others such as upgrading the war, updating the database and >> what have you. This is also a direction it seems the openmrs guys are >> considering taking with our approach. We can then build in as much or >> as little flexibility is desired. There are many rich maintenance use >> cases which we can deal with here rather than with an uber-smart >> installer. The important thing with the trayicon app is that it has >> full control over the webserver - so it could pause it, run psql or >> mysql scripts - unpause etc. Also manage hibernate connections >> through a nicer gui dialog than hand editing hibernate.properties. >> There's a list of maintenance tasks which we should consider. Given >> that it is easy for the app to read the hibernate.properties (and >> manage the webserver) it could also be possible to intelligently >> select between running pgdumps vs mysqldumps and restores and the >> like. My two cents. Anyone interested in doing a little bit of >> swing? >> >> Cheers >> Bob >> >> On 3 March 2010 08:27, Knut Staring <knu...@gmail.com> 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.picker...@gmail.com> 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 <sun...@gmail.com> >>>> 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.picker...@gmail.com> >>>> >> >>>> >> 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@lists.launchpad.net >>>> >> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> >> More help : https://help.launchpad.net/ListHelp >>>> > >>>> > >>>> >>>> >>>> >>>> -- >>>> -- >>>> Jason P. Pickering >>>> email: jason.p.picker...@gmail.com >>>> tel:+260968395190 >>>> >>>> _______________________________________________ >>>> 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 >>> >>> >>> >>> -- >>> Cheers, >>> Knut Staring >>> >>> _______________________________________________ >>> 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 >>> >>> >> > > > > -- > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+260968395190 > _______________________________________________ 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
