README


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

pgPhoneHome
===========
 
pgPhoneHome is a remote monitoring web application designed for monitoring your
PostgreSQL and EnterpriseDB Postgres Plus servers from your Apple iPhone. It
makes use of the iui iPhone/iPod Touch user interface library to provide a 
familiar and easy-to-use user interface. 

v8.2 and above of PostgreSQL, Postgres Plus and Postgres Plus Advanced Server
can be monitored.

pgPhoneHome is released under the GNU General Public License v2.0.

Installation
------------

You will need a webserver with PHP 5.0 or above, with PostgreSQL support
enabled. To install pgPhoneHome, simply unpack the downloaded archive into 
a directory accessible from the webserver. You may wish to rename the top
level directory to make the URL more convenient, or if installing on a 
dedicated vhost, remove it from the path altogether.

Configuration
-------------

Copy the config.php.in file to config.php and add the servers you wish to 
monitor, per the examples included. You may need to add additional options
to the connection strings to specify non-default port numbers or other 
parameters.

Custom icons for your servers may be added to the images directory and used
with your servers if desired. Icons should be 32x32 pixels or less.

Security
--------

pgPhoneHome will always connect to your servers using the credentials supplied in
the connection strings in the config.php file. The user account used must have
superuser privileges for correct operation.

To secure pgPhoneHome, it is recommended that the software is installed on an SSL
secured webserver. Access control may be implemented using any of the methods
your server offers for securing a directory. With an Apache server, the most
straightforward method is to place a .htaccess file in the root directory of
the pgPhoneHome software, referencing a password file stored outside of the web
directory. 

A simple example of a .htaccess file looks may be:

AuthUserFile /path/to/pgremote.htpasswd
AuthGroupFile /dev/null
AuthName "pgPhoneHome"
AuthType Basic
require valid-user

The password file may be created using the htpasswd utility, e.g:

% htpasswd -c /path/to/pgremote.htpasswd dave

This will create a new user called 'dave' and prompt for the password to set.
Additional users may be added with the same command, omitting the -c option.

Support
-------

If you require any support for pgPhoneHome, please visit the EnterpriseDB forums
at http://forums.enterprisedb.com/