phpMyAdmin gives 500 after update

wtfbrb

Verified User
Joined
Oct 11, 2009
Messages
71
I have automatic updates on...guess that was my first mistake...but I really liked them until now. phpMyAdmin updated on 12/2/2011 and it has been throwing a 500 error ever since. This is really bad timing for me...so I haven't been able to do much as far as tracking down the error but it has been a month and i hoped another update would come through and fix it...I tried ./build phpmyadmin to no avail. Anyone else have this same issue? 500 are usually a quick fix... i also chmod f/d to 644/755 as I do run php-cgi.
 
Apache error log doesn't show much.

[Sun Jan 01 06:25:17 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Sun Jan 01 06:25:17 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Sun Jan 01 06:25:17 2012] [notice] Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8g DAV/2 configured -- resuming normal operations
[Sun Jan 01 13:14:47 2012] [error] [client 175.45.25.87] File does not exist: /var/www/html/fastenv
[Sun Jan 01 13:14:47 2012] [error] [client 175.45.25.87] File does not exist: /var/www/html/404.shtml
[Sun Jan 01 18:55:39 2012] [error] [client 208.80.194.33] request failed: error reading the headers
[Sun Jan 01 22:19:34 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Sun Jan 01 22:19:34 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Sun Jan 01 22:19:34 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Sun Jan 01 22:19:34 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Mon Jan 02 00:11:05 2012] [notice] SIGHUP received. Attempting to restart
[Mon Jan 02 00:11:08 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Jan 02 00:11:08 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Mon Jan 02 00:11:09 2012] [notice] Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8g DAV/2 configured -- resuming normal operations
[Mon Jan 02 00:23:01 2012] [notice] caught SIGTERM, shutting down
[Mon Jan 02 00:23:04 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Jan 02 00:23:04 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Mon Jan 02 00:23:04 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Mon Jan 02 00:23:05 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Jan 02 00:23:05 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Mon Jan 02 00:23:05 2012] [notice] Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8g DAV/2 configured -- resuming normal operations
[Mon Jan 02 00:47:02 2012] [error] [client 150.70.75.35] File does not exist: /var/www/html/Themes
[Mon Jan 02 00:47:02 2012] [error] [client 150.70.75.35] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 00:47:02 2012] [error] [client 150.70.75.35] File does not exist: /var/www/html/Themes
[Mon Jan 02 00:47:02 2012] [error] [client 150.70.75.35] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 03:56:16 2012] [error] [client 208.80.194.26] request failed: error reading the headers
[Mon Jan 02 04:23:29 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Mon Jan 02 04:23:29 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Mon Jan 02 04:23:29 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Mon Jan 02 04:23:29 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Mon Jan 02 09:22:51 2012] [error] [client 178.154.161.29] File does not exist: /var/www/html/robots.txt
[Mon Jan 02 09:22:51 2012] [error] [client 178.154.161.29] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 14:39:06 2012] [error] [client 180.76.5.61] File does not exist: /var/www/html/robots.txt
[Mon Jan 02 14:39:06 2012] [error] [client 180.76.5.61] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 18:42:59 2012] [error] [client 180.76.6.232] File does not exist: /var/www/html/robots.txt
[Mon Jan 02 18:42:59 2012] [error] [client 180.76.6.232] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 19:55:12 2012] [error] [client 220.181.108.114] File does not exist: /var/www/html/robots.txt
[Mon Jan 02 19:55:12 2012] [error] [client 220.181.108.114] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 19:56:46 2012] [error] [client 24.207.194.87] No user or group set - set suPHP_UserGroup
[Mon Jan 02 19:56:46 2012] [error] [client 24.207.194.87] File does not exist: /var/www/html/500.shtml
[Mon Jan 02 19:56:46 2012] [error] [client 24.207.194.87] File does not exist: /var/www/html/favicon.ico
[Mon Jan 02 19:56:46 2012] [error] [client 24.207.194.87] File does not exist: /var/www/html/404.shtml
[Mon Jan 02 22:21:46 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Mon Jan 02 22:21:46 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Mon Jan 02 22:21:46 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Mon Jan 02 22:21:46 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Tue Jan 03 00:10:03 2012] [notice] SIGHUP received. Attempting to restart
[Tue Jan 03 00:10:05 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Tue Jan 03 00:10:05 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Tue Jan 03 00:10:05 2012] [notice] Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8g DAV/2 configured -- resuming normal operations
[Tue Jan 03 00:31:09 2012] [warn] child process 27950 still did not exit, sending a SIGTERM
[Tue Jan 03 00:31:13 2012] [notice] caught SIGTERM, shutting down
[Tue Jan 03 00:31:17 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Tue Jan 03 00:31:17 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Tue Jan 03 00:31:17 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Tue Jan 03 00:31:18 2012] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Tue Jan 03 00:31:18 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Tue Jan 03 00:31:18 2012] [notice] Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8g DAV/2 configured -- resuming normal operations
[Tue Jan 03 02:50:28 2012] [error] [client 208.80.194.29] request failed: error reading the headers
[Tue Jan 03 04:21:18 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Tue Jan 03 04:21:18 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
[Tue Jan 03 04:21:18 2012] [error] [client 199.16.130.48] Invalid URI in request GET HTTP/1.1
[Tue Jan 03 04:21:18 2012] [error] [client 199.16.130.48] File does not exist: /var/www/html/400.shtml
 
Try:

chown -R webapps:webapps /var/www/html/phpmyadmin

Or whatever the folder is for phpmyadmin. If you use suphp it might be an ownership problem.

The error might be logged to the actual domain log you are accessing too.

Those files are in /var/log/httpd/domains/domain.com.error.log
 
Ok, yes I had already tried chown webapps...here is the log for when I try to access:


199.21.99.112 - - [11/Jan/2012:15:48:28 -0600] "GET /privacy-policy.html HTTP/1.1" 200 5297 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
24.207.194.87 - - [11/Jan/2012:15:59:00 -0600] "GET /phpmyadmin/ HTTP/1.1" 404 901 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7"
24.207.194.87 - - [11/Jan/2012:15:59:00 -0600] "GET /favicon.ico HTTP/1.1" 404 594 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7"
180.76.5.94 - - [11/Jan/2012:16:01:23 -0600] "GET / HTTP/1.1" 200 4078 "-" "Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)"
24.207.194.87 - - [11/Jan/2012:16:06:27 -0600] "GET /phpmyadmin/ HTTP/1.1" 404 901 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7"
24.207.194.87 - - [11/Jan/2012:16:06:27 -0600] "GET /favicon.ico HTTP/1.1" 404 594 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7"


This is seriously starting to affect my work :(
 
no

no it's not working...i just don't think that phpmyadmin errors get logged to the domains error log. I don't know where they are logged...thats why i gave the general apache log earlier...
 
Huh, just found out squirrel mail is broken too. Maybe issue with webapp user? What could have changed?
 
Rebuilt, same issue...found an old script in the process...in the scripts folder if you run the phpmyadmin script it install 2.11. If you build it using custombuild/build phpmyadmin it install 3.4.9. Sad thing for me is neither of them work.
 
suPHP...not sure about giving root access to my server...never used roundcube, if I install it how will I test to see if it works? You did see that squirrel mail isn't working either right? That probably happened around the same time but I have no idea as no one uses it.
 
roundcube is a webmail client no worries about that, if it work just remove it from /var/www/html/roundcube*

for test it just go to website/roundcube

Actually i think is a permission user somewhere in /var/www or /var/www/ntml

could you post an ls -l to those directory?

Regards
 
here is the html dir

-rw-r--r-- 1 root root 44 2010-10-20 17:05 index.html
lrwxrwxrwx 1 webapps webapps 44 2012-01-12 08:31 phpMyAdmin -> /var/www/html/phpMyAdmin-3.4.9-all-languages
drwxr-xr-x 10 webapps webapps 4.0K 2012-01-12 08:31 phpMyAdmin-3.4.9-all-languages
-rwxr-xr-x 1 root root 68 2010-10-20 16:53 redirect.php
lrwxrwxrwx 1 webapps webapps 19 2011-11-21 11:43 squirrelmail -> squirrelmail-1.4.22
drwxr-xr-x 16 webapps webapps 4.0K 2011-11-21 11:43 squirrelmail-1.4.22

for the www everything there is owned by root (including the html dir) but that is the same permissions as my other da server which is working fine. Just as a test I did chown the html dir to webapps:webapps but that did not help.
 
This should fix it:

Code:
chown -R webapps:webapps /var/www/html

You might want to check for errors in /var/log/suphp.log or /var/log/suphp/suphp.log
 
Last edited:
That is what I did, mentioned that in the last line of last post...guess I didn't say I did -R but, I did...anyhow nothing in suphp log either.
 
I fix my same problem

Hi,
I fix my same problem if have "ini_set" in "disable_functions" on "php.ini" just remove it and save "php.ini"

on ssh you can find your "php.ini" path with below command
php -i | grep php.ini
 
Thnx for me again

This problem occure again for me and I see this reply (mine) and solved.

After save php.ini run below commnd to restart httpd.
service httpd restart
 
Back
Top