On 3 March 2010 09:49, Jason Pickering <jason.p.picker...@gmail.com> wrote: > Yeah, it is certainly possible, but this is not how the DHIS2 live app > is launched. It is not launched with a bat script. > > So, if we want users to have a "double clickable" icon to start the > application and not a batch file, then it would need to occur from > within the DHIS2 Live EXE itself. That is how I see it, but maybe Bob > has other comments.
Yes it can easily be part of the startup process but would require some small tinkering. Something along the lines of "if there is a startup.sh or startup.bat in ./scripts/ then exec that. Wait for that to complete, capture status, and if all is well call the start method on the webserver". Translated to java. > > The downside of this is that users may need the Postgres service > running anyway, for instance if they need to use the PivotTables > without having DHIS2 running. > > I think a service is the best way to go at this point for the Desktop > install. It is not that much more complex to add a custom user and a > custom service. Comments welcome however. > > On Wed, Mar 3, 2010 at 11:45 AM, Knut Staring <knu...@gmail.com> wrote: >> I'm pretty sure it is - and I think I did it (though I certainly also used >> it as service). Looking through my bat scripts (attached) I see this line: >> @@DHIS2DIR@@\pgsql\bin\pg_ctl start -D @@DHIS2DIR@@\pgsql\data >> >> >> On Wed, Mar 3, 2010 at 10:35 AM, 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. >>> >>> >>> >>> 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 >> >> >> >> -- >> Cheers, >> Knut Staring >> > > > > -- > -- > 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