We have used OpenVPN/IPSec to allow direct access to the database for those users who need it. Therefore users do not need shell access and strong certificates can be used. This was viewed as a lower security risk than having PHP on the server or by opening up the database itself directly. Might also be a route to consider.
Regards, Jason --Sent from my mobile On Mar 4, 2014 8:02 PM, "Bob Jolliffe" <[email protected]> wrote: > yes people talk highly of phpPgAdmin. It has some small benefit over > pgadminIII that you don't have to explicitly open up your pg_hba.conf > settings to the full range of user/hosts which might connect. > > I guess it would be a simple enough app to embed phpPgAdmin into some sort > of iframe for integration with dhis ... > > > On 4 March 2014 16:16, Jason Pickering <[email protected]>wrote: > >> Hi Greg, >> You may want to check out phpPgAdmin. >> >> PgAdminIII could also of course be used by directly connecting to the >> database with an ODBC connection. >> >> Regards, >> Jason >> >> --Sent from my mobile >> On Mar 4, 2014 12:26 PM, "Greg Rowles" <[email protected]> wrote: >> >>> Hi Devs >>> >>> Is anyone aware of a web-based query gui-toolset? We have an 'IE' >>> designed tool here: >>> >>> http://hispsa.org/staging_timesheets/tablerels/viewtables.asp >>> >>> It only works on IE (sometimes) but at least allows users to see table >>> designs and edit SQL syntax. We're looking at something that we can plug-in >>> ontop of DHIS2 for our advanced users... >>> >>> Any responses will be appreciated... >>> >>> Thanks, >>> Greg >>> -- >>> >>> Business Intelligence Planner >>> *Health Information Systems Programme* >>> *- - - - - - - **- - - - - - - **- - - - - - - **- - - - - - - **- - - >>> - - * >>> Mobile : 073 246 2992 >>> Landline: 021 554 3130 >>> Fax: 086 733 8432 >>> Skype: gregory_rowles >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
