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