Die Website phppgadmin gibt Fehler 500: Internal Server Error zurück

Hallo,
ich kann auf mein PostgreSQL Server über phppgadmin nicht zugreifen. Es kommt dann eine Fehlermeldung “500: Internal Server Error”.
Ich füge Euch den Apache Error.log bei.
Habt Ihr einen Tipp, wo ich nach dem Fehler suchen kann?

[Sat Nov 06 12:52:49.765345 2021] [socache_shmcb:debug] [pid 14443] mod_socache_shmcb.c(495): AH00831: socache_shmcb_store (0x0f -> subcache 15)
[Sat Nov 06 12:52:49.765392 2021] [socache_shmcb:debug] [pid 14443] mod_socache_shmcb.c(849): AH00847: insert happened at idx=0, data=(0:32)
[Sat Nov 06 12:52:49.765402 2021] [socache_shmcb:debug] [pid 14443] mod_socache_shmcb.c(854): AH00848: finished insert, subcache: idx_pos/idx_used=0/1, data_pos/data_used=0/214
[Sat Nov 06 12:52:49.765409 2021] [socache_shmcb:debug] [pid 14443] mod_socache_shmcb.c(516): AH00834: leaving socache_shmcb_store successfully
[Sat Nov 06 12:52:49.767743 2021] [ssl:debug] [pid 14443] ssl_engine_kernel.c(383): [client 192.168.30.67:55512] AH02034: Initial (No.1) HTTPS request received for child 1 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/intro.php
[Sat Nov 06 12:52:49.767864 2021] [authz_core:debug] [pid 14443] mod_authz_core.c(820): [client 192.168.30.67:55512] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/intro.php
[Sat Nov 06 12:52:49.767882 2021] [authz_core:debug] [pid 14443] mod_authz_core.c(820): [client 192.168.30.67:55512] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/intro.php
[Sat Nov 06 12:52:49.767897 2021] [gnutls:debug] [pid 14443] gnutls_hooks.c(1354): [client 192.168.30.67:55512] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/intro.php
[Sat Nov 06 12:52:49.769089 2021] [deflate:debug] [pid 14443] mod_deflate.c(856): [client 192.168.30.67:55512] AH01384: Zlib: Compressed 1986 to 803 : URL /servers.php, referer: https://mypgadmin.intern.example.com/intro.php
[Sat Nov 06 12:52:49.831416 2021] [ssl:debug] [pid 14443] ssl_engine_kernel.c(383): [client 192.168.30.67:55512] AH02034: Subsequent (No.2) HTTPS request received for child 1 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:49.831538 2021] [core:error] [pid 14443] [client 192.168.30.67:55512] AH00037: Symbolic link not allowed or link target not accessible: /var/www/html/phppgadmin/libraries/js/jquery.js, referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.208984 2021] [ssl:debug] [pid 14443] ssl_engine_kernel.c(383): [client 192.168.30.67:55512] AH02034: Subsequent (No.3) HTTPS request received for child 1 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.209129 2021] [authz_core:debug] [pid 14443] mod_authz_core.c(820): [client 192.168.30.67:55512] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.209148 2021] [authz_core:debug] [pid 14443] mod_authz_core.c(820): [client 192.168.30.67:55512] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.209163 2021] [gnutls:debug] [pid 14443] gnutls_hooks.c(1354): [client 192.168.30.67:55512] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.210037 2021] [deflate:debug] [pid 14443] mod_deflate.c(856): [client 192.168.30.67:55512] AH01384: Zlib: Compressed 2162 to 959 : URL /redirect.php, referer: https://mypgadmin.intern.example.com/servers.php
[Sat Nov 06 12:52:54.271389 2021] [ssl:debug] [pid 14443] ssl_engine_kernel.c(383): [client 192.168.30.67:55512] AH02034: Subsequent (No.4) HTTPS request received for child 1 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:52:54.271509 2021] [core:error] [pid 14443] [client 192.168.30.67:55512] AH00037: Symbolic link not allowed or link target not accessible: /var/www/html/phppgadmin/libraries/js/jquery.js, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:52:59.276796 2021] [ssl:debug] [pid 14443] ssl_engine_io.c(1106): [client 192.168.30.67:55512] AH02001: Connection closed to child 1 with standard shutdown (server mypgadmin.intern.example.com:443)
[Sat Nov 06 12:53:02.064336 2021] [socache_shmcb:debug] [pid 14475] mod_socache_shmcb.c(495): AH00831: socache_shmcb_store (0x5c -> subcache 28)
[Sat Nov 06 12:53:02.064368 2021] [socache_shmcb:debug] [pid 14475] mod_socache_shmcb.c(849): AH00847: insert happened at idx=1, data=(215:247)
[Sat Nov 06 12:53:02.064394 2021] [socache_shmcb:debug] [pid 14475] mod_socache_shmcb.c(854): AH00848: finished insert, subcache: idx_pos/idx_used=0/2, data_pos/data_used=0/429
[Sat Nov 06 12:53:02.064402 2021] [socache_shmcb:debug] [pid 14475] mod_socache_shmcb.c(516): AH00834: leaving socache_shmcb_store successfully
[Sat Nov 06 12:53:02.066499 2021] [ssl:debug] [pid 14475] ssl_engine_kernel.c(383): [client 192.168.30.67:55514] AH02034: Initial (No.1) HTTPS request received for child 5 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.066682 2021] [authz_core:debug] [pid 14475] mod_authz_core.c(820): [client 192.168.30.67:55514] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.066703 2021] [authz_core:debug] [pid 14475] mod_authz_core.c(820): [client 192.168.30.67:55514] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.066727 2021] [gnutls:debug] [pid 14475] gnutls_hooks.c(1354): [client 192.168.30.67:55514] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.068969 2021] [php7:warn] [pid 14475] [client 192.168.30.67:55514] PHP Warning:  include_once(./libraries/adodb/adodb.inc.php): failed to open stream: Datei oder Verzeichnis nicht gefunden in /var/www/html/phppgadmin/classes/database/ADODB_base.php on line 10, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.069026 2021] [php7:warn] [pid 14475] [client 192.168.30.67:55514] PHP Warning:  include_once(): Failed opening './libraries/adodb/adodb.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/phppgadmin/classes/database/ADODB_base.php on line 10, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.069057 2021] [php7:warn] [pid 14475] [client 192.168.30.67:55514] PHP Warning:  Use of undefined constant ADODB_FETCH_ASSOC - assumed 'ADODB_FETCH_ASSOC' (this will throw an Error in a future version of PHP) in /var/www/html/phppgadmin/classes/database/Connection.php on line 22, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.069114 2021] [php7:error] [pid 14475] [client 192.168.30.67:55514] PHP Fatal error:  Uncaught Error: Call to undefined function ADONewConnection() in /var/www/html/phppgadmin/classes/database/Connection.php:23\nStack trace:\n#0 /var/www/html/phppgadmin/classes/Misc.php(481): Connection->Connection('mypgadmin.inter...', 5432, 'allow', 'postgres', '##########', 'template1')\n#1 /var/www/html/phppgadmin/libraries/lib.inc.php(219): Misc->getDatabaseAccessor('template1')\n#2 /var/www/html/phppgadmin/redirect.php(7): include_once('/var/www/html/p...')\n#3 {main}\n  thrown in /var/www/html/phppgadmin/classes/database/Connection.php on line 23, referer: https://mypgadmin.intern.example.com/redirect.php?subject=server&server=mypgadmin.intern.example.com%3A5432%3Aallow&
[Sat Nov 06 12:53:02.069521 2021] [ssl:debug] [pid 14475] ssl_engine_io.c(1106): [client 192.168.30.67:55514] AH02001: Connection closed to child 5 with standard shutdown (server mypgadmin.intern.example.com:443)
[Sat Nov 06 12:53:05.173040 2021] [socache_shmcb:debug] [pid 14444] mod_socache_shmcb.c(495): AH00831: socache_shmcb_store (0x60 -> subcache 0)
[Sat Nov 06 12:53:05.173064 2021] [socache_shmcb:debug] [pid 14444] mod_socache_shmcb.c(849): AH00847: insert happened at idx=0, data=(0:32)
[Sat Nov 06 12:53:05.173073 2021] [socache_shmcb:debug] [pid 14444] mod_socache_shmcb.c(854): AH00848: finished insert, subcache: idx_pos/idx_used=0/1, data_pos/data_used=0/214
[Sat Nov 06 12:53:05.173096 2021] [socache_shmcb:debug] [pid 14444] mod_socache_shmcb.c(516): AH00834: leaving socache_shmcb_store successfully
[Sat Nov 06 12:53:05.174575 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Initial (No.1) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.174696 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.174714 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.174730 2021] [gnutls:debug] [pid 14444] gnutls_hooks.c(1354): [client 192.168.30.67:55516] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.175727 2021] [deflate:debug] [pid 14444] mod_deflate.c(856): [client 192.168.30.67:55516] AH01384: Zlib: Compressed 3008 to 1148 : URL /browser.php, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.238550 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Subsequent (No.2) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.238672 2021] [core:error] [pid 14444] [client 192.168.30.67:55516] AH00037: Symbolic link not allowed or link target not accessible: /var/www/html/phppgadmin/libraries/js/jquery.js, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.334321 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Subsequent (No.3) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.334555 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.334574 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.334588 2021] [gnutls:debug] [pid 14444] gnutls_hooks.c(1354): [client 192.168.30.67:55516] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.335468 2021] [deflate:debug] [pid 14444] mod_deflate.c(856): [client 192.168.30.67:55516] AH01384: Zlib: Compressed 404 to 209 : URL /servers.php, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.373637 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Subsequent (No.4) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.373871 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.373890 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.373915 2021] [gnutls:debug] [pid 14444] gnutls_hooks.c(1354): [client 192.168.30.67:55516] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.383989 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Subsequent (No.5) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.384189 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.384207 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.384221 2021] [gnutls:debug] [pid 14444] gnutls_hooks.c(1354): [client 192.168.30.67:55516] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.411152 2021] [socache_shmcb:debug] [pid 15239] mod_socache_shmcb.c(495): AH00831: socache_shmcb_store (0x19 -> subcache 25)
[Sat Nov 06 12:53:05.411185 2021] [socache_shmcb:debug] [pid 15239] mod_socache_shmcb.c(849): AH00847: insert happened at idx=0, data=(0:32)
[Sat Nov 06 12:53:05.411192 2021] [socache_shmcb:debug] [pid 15239] mod_socache_shmcb.c(854): AH00848: finished insert, subcache: idx_pos/idx_used=0/1, data_pos/data_used=0/215
[Sat Nov 06 12:53:05.411198 2021] [socache_shmcb:debug] [pid 15239] mod_socache_shmcb.c(516): AH00834: leaving socache_shmcb_store successfully
[Sat Nov 06 12:53:05.413816 2021] [ssl:debug] [pid 15239] ssl_engine_kernel.c(383): [client 192.168.30.67:55518] AH02034: Initial (No.1) HTTPS request received for child 6 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.413970 2021] [authz_core:debug] [pid 15239] mod_authz_core.c(820): [client 192.168.30.67:55518] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.413986 2021] [authz_core:debug] [pid 15239] mod_authz_core.c(820): [client 192.168.30.67:55518] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.414007 2021] [gnutls:debug] [pid 15239] gnutls_hooks.c(1354): [client 192.168.30.67:55518] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.415840 2021] [php7:warn] [pid 15239] [client 192.168.30.67:55518] PHP Warning:  include_once(./libraries/adodb/adodb.inc.php): failed to open stream: Datei oder Verzeichnis nicht gefunden in /var/www/html/phppgadmin/classes/database/ADODB_base.php on line 10, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.415888 2021] [php7:warn] [pid 15239] [client 192.168.30.67:55518] PHP Warning:  include_once(): Failed opening './libraries/adodb/adodb.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/phppgadmin/classes/database/ADODB_base.php on line 10, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.415916 2021] [php7:warn] [pid 15239] [client 192.168.30.67:55518] PHP Warning:  Use of undefined constant ADODB_FETCH_ASSOC - assumed 'ADODB_FETCH_ASSOC' (this will throw an Error in a future version of PHP) in /var/www/html/phppgadmin/classes/database/Connection.php on line 22, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.415967 2021] [php7:error] [pid 15239] [client 192.168.30.67:55518] PHP Fatal error:  Uncaught Error: Call to undefined function ADONewConnection() in /var/www/html/phppgadmin/classes/database/Connection.php:23\nStack trace:\n#0 /var/www/html/phppgadmin/classes/Misc.php(481): Connection->Connection('mypgadmin.inter...', 5432, 'allow', 'postgres', '##########', 'template1')\n#1 /var/www/html/phppgadmin/libraries/lib.inc.php(219): Misc->getDatabaseAccessor('template1')\n#2 /var/www/html/phppgadmin/all_db.php(10): include_once('/var/www/html/p...')\n#3 {main}\n  thrown in /var/www/html/phppgadmin/classes/database/Connection.php on line 23, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.416330 2021] [ssl:debug] [pid 15239] ssl_engine_io.c(1106): [client 192.168.30.67:55518] AH02001: Connection closed to child 6 with standard shutdown (server mypgadmin.intern.example.com:443)
[Sat Nov 06 12:53:05.430844 2021] [ssl:debug] [pid 14444] ssl_engine_kernel.c(383): [client 192.168.30.67:55516] AH02034: Subsequent (No.6) HTTPS request received for child 2 (server mypgadmin.intern.example.com:443), referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.430983 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of Require all granted: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.431005 2021] [authz_core:debug] [pid 14444] mod_authz_core.c(820): [client 192.168.30.67:55516] AH01626: authorization result of <RequireAny>: granted, referer: https://mypgadmin.intern.example.com/browser.php
[Sat Nov 06 12:53:05.431021 2021] [gnutls:debug] [pid 14444] gnutls_hooks.c(1354): [client 192.168.30.67:55516] request declined in mgs_hook_fixups, referer: https://mypgadmin.intern.example.com/browser.php

Gruß von Stefan Harbich

Da würd ich anfangen… Scheinbar findet er da was nicht bzw. hat dein PHP eine Funktion nicht…

Hallo,
leider sagt mir die Fehlermeldung nichts. Meinst Du das ein PHP Modul nicht geladen ist?
Gruß von Stefan Harbich

Hallo,

ich geh eher davon aus, dass du es nicht sauber installiert hast. Dir fehlen irgendwelche Dateien…

cu tb

Welche Distribution benutzt du? Funktionieren andere PHP-Apps mit der gleichen Installation? Mir scheint ein Modulproblem am wahrscheinlichsten.

Gruß Uwe

Hallo Ihr Lieben,
ich konnte das Problem lösen. Folgende Fehler habe ich gemacht. Bei der Installation von phppgadmin habe ich folgende PHP Module nicht aktiviert. Das habe ich wie folgt nachgeholt:

a2enconf php7.3-fpm
a2enmod proxy_fcgi setenvif

Zusätzlich hatte ich das Verzeichnis “/usr/share/phppgadmin” ins Verzeichnis “/var/www/html/” verschoben, weil ich dort alle Web Verzeichnisse habe.

Habt Ihr eine Lösung wie ich bei der Installation das Verzeichnis anpassen kann?

Danke für Eure Unterstützung.

Mit freundlichen Grüßen

Stefan Harbich

Eigentlich ist das wurscht wo die PHP-App ist. Du muß nur in der Apache-Config den Pfad zur App richtig setzen. Das jeweilige Paketmanagment der Distri hat da natürlich eigene Vorstellungen, weiß nicht ob man da dran drehen kann (oder will ;))
Gruß Uwe