Eric's picture

I want my phpPGADmin back.

I have just installed TurnKey PostgreSQL version (14.0) and everything seems to be working  fine.  I see that phpPGADmin has been replaced with Adminer.  Though Adminer may be a great tool, I don't know it and I don't want to learn something new right now.  I have installed phpPGAdmin on the 14.0 install but when I go to access it remotely through my web browser I either get "try again" or "404-Page Not Found". I have tried suggestions from Google search to fix the problem with no joy.

http://192.168.1.x:5432             returns "try again"
http://192.168.1.x/phppgadmin  returns "try again"
https://192.168.1.x/phppgadmin returns "404 - Not Found"
https://192.168.1.x:5432             returns "try again"

Please, What is the recipe for installing phpPGAdmin on TurnKey PostgreSQL version (14.0) and getting it to work?

Also, where can I find help documentation on Adminer?  I can't seem to find that either.

 

Thanks

Forum: 
Jeremy Davis's picture

According to the Debian docs install with:
apt-get update && apt-get install phppgadmin
Then adjust the Apache config file for it: /etc/phppgadmin/apache.conf

You'll need to restart Apache to apply the changed conf file

Sorry I can't give the exact steps as I don't know them (without actually doing it). Also WRT docs, I just had a google and must admit it seems pretty sparse... :(

If you're interested, the discussion and feedback regarding move to Adminer on PostgreSQL for v14.0 is on GitHub here.

PS Digital Ocean have a tutorial for installing on Ubuntu. It may not be exactly the same (Ubuntu and Debian aren't identical) but should be close...

Also it'd be great if you can share what ends up working for you as others will probably be interested.

Eric's picture

The following is my WORKAROUND not a/the SOLUTION to installing and accessing phpPGAdmin after installing TurnKey PostgreSQL version (14.0).  I did not try this out on LAPP (14.0).

THIS IS WHAT I DID:
Installed and configure TurnKey PostgreSQL version (14.0)
FROM CONSOLE:
Installed security updates using turnkey-install-security-updates
rebooted
Ran apt-get update
Then ran apt-get upgrade
rebooted
Ran apt-get phppgadmin
rebooted

EDIT (however you edit):
/etc/lighttpd/conf-available/50-tklcp.conf
COMMENT OUT:
#server.document-root = "/var/www/"
ADD LINE:
server.document-root = "/usr/share/phppgadmin"

EDIT:
/etc/apache2/conf-available/phppgadmin.conf
CHANGE:
$conf['extra_login_security'] = true;
TO:
$conf['extra_login_security'] = false;
MAKE SURE THIS LINE IS FALSE:
$conf['owned_only'] = false;

EDIT:
/etc/confconsole/service.txt
CHANGE:
Control Panel: https://$ipaddr
TO:
phpPGAdmin: https://$ipaddr  (or any name you want)

REBOOT

You should now be able to enter the server IP address and access phpPGAdmin.

I modified the TKLCP (TurnKeyLinuxControlPanel) as anything on the control panel can be accessed by other means.  Sorry, I was not savey enough to ADD phpPGAdmin rather than modify the existing TKLCP to get to it.  Maybe someone else can tweak/build on this and figure it out.  If anyone wants me to elaborate on how I even got this far I'll be glad to share. Basicly I started out looking at TurnKey PostgreSQL version (13.0) and figured some things out from there.

Jeremy Davis's picture

Thanks for sharing :)

Add new comment