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…
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…
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 …
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…
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.
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…
Here is an example of some pg_hba.conf settings with comments which people might find useful. The database in this case is on a separate server. The application server (with tomcat and all) is on a machine called appserver on 192.168.1.102. Other machines we want to allow to connect from the office are on the 192.168.2.0 subnet.
do peer identification on unix domain (local) sockets
local all postgres peer
local all all peer
you need the following if you have dhis running on same machine as database server
because its java it can’t use the unix domain sockets above, so we allow direct non-ssl
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.
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 …
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…
Thank you for the feedback. Some of these tools are for major DB-administration - a little overkill for our use right now but thank you. Have a great day!
Here is an example of some pg_hba.conf settings with comments which people might find useful. The database in this case is on a separate server. The application server (with tomcat and all) is on a machine called appserver on 192.168.1.102. Other machines we want to allow to connect from the office are on the 192.168.2.0 subnet.
do peer identification on unix domain (local) sockets
local all postgres peer
local all all peer
you need the following if you have dhis running on same machine as database server
because its java it can’t use the unix domain sockets above, so we allow direct non-ssl
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.
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 …
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…