PhpPgAdmin: Difference between revisions

From Alpine Linux
m (update to use Setting Up Lighttpd With FastCGI template)
m (minor layout changes)
Line 13: Line 13:
== Install lighttpd, PHP and postgresql ==
== Install lighttpd, PHP and postgresql ==
{{:Setting Up Lighttpd With FastCGI}}
{{:Setting Up Lighttpd With FastCGI}}
Install extra packages
Install extra packages
apk add postgresql postgresql-client php-pgsql
{{Cmd|apk add postgresql postgresql-client php-pgsql}}


== Configuring postgresql ==
== Configuring postgresql ==


/etc/init.d/postgresql setup
{{Cmd|/etc/init.d/postgresql setup}}


'''Starting http service and adding to boot'''
'''Starting http service and adding to boot'''


/etc/init.d/postgresql start && rc-update add postgresql default
{{Cmd|/etc/init.d/postgresql start && rc-update add postgresql default}}


== Installing phpPgAdmin ==
== Installing phpPgAdmin ==
Line 30: Line 31:
Make webapps folder
Make webapps folder


mkdir /usr/share/webapps/ -p
{{Cmd|mkdir /usr/share/webapps/ -p}}


Download  
Download  


cd /usr/share/webapps/
{{Cmd|cd /usr/share/webapps/
wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.2.3.tar.gz
wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.2.3.tar.gz}}


Unpack and delete tar file
Unpack and delete tar file


tar zxvf phpPgAdmin-4.2.3.tar.gz
{{Cmd|tar zxvf phpPgAdmin-4.2.3.tar.gz
rm phpPgAdmin-4.2.3.tar.gz
rm phpPgAdmin-4.2.3.tar.gz}}


Change Folder Name
Change Folder Name


mv phpPgAdmin-4.2.3 phppgadmin
{{Cmd|mv phpPgAdmin-4.2.3 phppgadmin}}


Change Config File Name
Change Config File Name


cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php
{{Cmd|cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php}}


Change Folder Persmissions
Change Folder Persmissions


chmod -R 777 /usr/share/webapps/
{{Cmd|chmod -R 777 /usr/share/webapps/}}


Make Symlink to the phpPgAdmin folder
Make Symlink to the phpPgAdmin folder


ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin
{{Cmd|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}}


== Log on your phpPgAdmin ==
== Log on your phpPgAdmin ==
Line 65: Line 66:
'''Note:''' If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.
'''Note:''' If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.
e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin
e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin
== License ==
'''phpPgAdmin License'''
phpPgAdmin is released under GNU General Public License.The GNU Public License

Revision as of 06:13, 23 June 2011

What is phpPgAdmin?

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Set up phpPgAdmin on Alpine Linux

This document will be a very quick c/p guide to setup phpPgAdmin on Alpine linux. What we will setup is the following:

  • Lighttpd with PHP
  • postgresql
  • phpPgAdmin

Install lighttpd, PHP and postgresql

Basic Installation

For installing the additional packages first activate community packages and update the package index

Install the required packages:

# apk add lighttpd php82 fcgi php82-cgi

Configure Lighttpd

Edit lighttpd.conf (/etc/lighttpd/lighttpd.conf) and uncomment the line:

Contents of /etc/lighttpd/lighttpd.conf

... include "mod_fastcgi.conf" ...

Edit mod_fastcgi.conf (/etc/lighttpd/mod_fastcgi.conf), find and change /usr/bin/php-cgi to /usr/bin/php-cgi82.

Contents of /etc/lighttpd/mod_fastcgi.conf

... "bin-path" => "/usr/bin/php-cgi82" # php-cgi ...

Start lighttpd service and add it to default runlevel

# rc-service lighttpd start # rc-update add lighttpd default

Install extra packages

apk add postgresql postgresql-client php-pgsql

Configuring postgresql

/etc/init.d/postgresql setup

Starting http service and adding to boot

/etc/init.d/postgresql start && rc-update add postgresql default

Installing phpPgAdmin

Install phpPgAdmin

Make webapps folder

mkdir /usr/share/webapps/ -p

Download

cd /usr/share/webapps/ wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.2.3.tar.gz

Unpack and delete tar file

tar zxvf phpPgAdmin-4.2.3.tar.gz rm phpPgAdmin-4.2.3.tar.gz

Change Folder Name

mv phpPgAdmin-4.2.3 phppgadmin

Change Config File Name

cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php

Change Folder Persmissions

chmod -R 777 /usr/share/webapps/

Make Symlink to the phpPgAdmin folder

ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin

Log on your phpPgAdmin

Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password. And enjoy this nice and useful tool.

Note: If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set. e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin