phppgadmin is installed in /usr/share/phppgadmin. You will need to create a site file in /etc/apache2/sites-available and enable it in order to access phppgadmin. You will also have to set up dns accordingly. The file should look something like this
<VirtualHost> *:80> ServerName pgadmin.caa.intrasec.net Redirect "/" https://pgadmin.caa.intrasec.net </VirtualHost> <IfModule mod_ssl.c> <VirtualHost _default_:443> Servername pgadmin.caa.intrasec.net ServerAdmin tim@jtek.co.uk DocumentRoot /usr/share/phppgadmin ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined SSLEngine on SSLCertificateFile /etc/ssl/certs/mail-caa.pem SSLCertificateKeyFile /etc/ssl/private/mail-caa.key <FilesMatch "\.(cgi|shtml|phtml|php)$"> SSLOptions +StdEnvVars </FilesMatch> <Directory /usr/lib/cgi-bin> SSLOptions +StdEnvVars DirectoryIndex index.php index.html AllowOverride None Require all granted AcceptPathInfo On </Directory> <Location "/"> Require all granted </Location> BrowserMatch "MSIE [2-6]" \ nokeepalive ssl-unclean-shutdown \ downgrade-1.0 force-response-1.0 BrowserMatch "MSIE [17-9]" ssl-unclean-shutdown </VirtualHost> </IfModule>
You will need to change the server name, SSLCertificateFile, SSLCertificateKeyFile and Redirect to match your configuration.
Don’t forget that the file name needs to end in “.conf” otherwise the “a2ensite” script will not work. If you installed the Debian packaged version then you will also need to disable the phppgadmin conf that it automatically creates:
#a2disconf phppgadmin
You might want to create a superuser that can log on to phppgadmin. To do so run
#createuser NewUserName -U postgres -DRsP
Note that for security reasons phppgadmin expressly forbids the built in postgres user from logging on.
Recent Comments