PhpPgAdmin: Difference between revisions
(replace /etc/init.d with rc-service) |
|||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
[ | [https://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL. | ||
== Install lighttpd, PHP, and postgresql == | == Install lighttpd, PHP, and postgresql == | ||
| Line 9: | Line 9: | ||
== Configuring postgresql == | == Configuring postgresql == | ||
{{Cmd| | {{Cmd|rc-service postgresql setup}} | ||
Starting http service and adding to boot. | Starting http service and adding to boot. | ||
{{Cmd| | {{Cmd|rc-service postgresql start && rc-update add postgresql default}} | ||
== Installing phpPgAdmin == | == Installing phpPgAdmin == | ||
Create a directory named {{Path|webapps}} | |||
{{Cmd|mkdir -p /usr/share/webapps/}} | {{Cmd|mkdir -p /usr/share/webapps/}} | ||
| Line 24: | Line 24: | ||
{{Cmd|cd /usr/share/webapps/ | {{Cmd|cd /usr/share/webapps/ | ||
wget | wget https://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}} | ||
Unpack and delete tar file | Unpack and delete the tar file | ||
{{Cmd|tar zxvf phpPgAdmin-5.0.2.tar.gz | {{Cmd|tar zxvf phpPgAdmin-5.0.2.tar.gz | ||
rm phpPgAdmin-5.0.4.tar.gz}} | rm phpPgAdmin-5.0.4.tar.gz}} | ||
Change folder name | Change the folder name | ||
{{Cmd|mv phpPgAdmin-5.0.4 phppgadmin}} | {{Cmd|mv phpPgAdmin-5.0.4 phppgadmin}} | ||
| Line 39: | Line 39: | ||
{{Cmd|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 permissions | Change the folder permissions | ||
{{Cmd|chmod -R 777 /usr/share/webapps/}} | {{Cmd|chmod -R 777 /usr/share/webapps/}} | ||
Create a symlink to the {{Path|phpPgAdmin}} folder | |||
{{Cmd|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}} | {{Cmd|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}} | ||
| Line 49: | Line 49: | ||
== Log on your phpPgAdmin == | == Log on your phpPgAdmin == | ||
Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password. | Browse to: <nowiki>http://WEBSERVER_IP_ADDRESS/phppgadmin</nowiki> and logon to phpPgAdmin using postgresql user and password. | ||
{{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: <nowiki>http://WEBSERVER_IP_ADDRESS:8080/phppgadmin</nowiki> }} | ||
[[Category:PHP]] | [[Category:PHP]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
Latest revision as of 09:43, 17 November 2023
phpPgAdmin is a web-based administration tool for PostgreSQL.
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
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
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
rc-service postgresql setup
Starting http service and adding to boot.
rc-service postgresql start && rc-update add postgresql default
Installing phpPgAdmin
Create a directory named webapps
mkdir -p /usr/share/webapps/
Download the latest release of phpPgAdmin.
cd /usr/share/webapps/ wget https://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz
Unpack and delete the tar file
tar zxvf phpPgAdmin-5.0.2.tar.gz rm phpPgAdmin-5.0.4.tar.gz
Change the folder name
mv phpPgAdmin-5.0.4 phppgadmin
Copy the sample config file name
cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php
Change the folder permissions
chmod -R 777 /usr/share/webapps/
Create a 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.