'502 Bad Gateway' after MySQL upgrade

celsum

Hi.

I was running MySQL 4.0.something with PHP 4.3.9 with Zeus Web server before, and everything was OK, until I decided to upgrade MySQL.
I did 'emerge mysql' and got MySQL 4.1.19 installed succesfuly on my box.
That's when I started to have problems.

The first problem was that MySQL was failing right after start, and it turned out that it was due to the users table being in an unsupported format. I fixed that problem starting MySQL with skip-grant-tables, and then ran mysql_fix_privilege_tables, because during start 'Fatal error: mysql.user table is damaged or in unsupported 3.20 format. ' line appeared in the logs.

One problem solved, but now when I try to open any php page that involves a mysql script, I get a '502 Bad Gateway' error page.

Any help would be appreciated.

magic919 · Posted: Wed May 31, 2006 4:15 pm Post subject:

This error makes no sense on its own. I'm not saying you don't have a problem here, of course. I'd expect you to see this generic error from a proxy in the middle. It doesn't tell you what the webserver problem is.

Can you examine the webserver and MYSQL error logs for hints?

lxg · Posted: Wed May 31, 2006 4:55 pm Post subject:

celsum,

could it be your configuration is to access the MySQL server not over its Unix socket, but via port 3306 (or some other)? The Bad Gateway error suggests this, and it seems that this technique has worked before and now it doesn't anymore.

Also, did you follow the MySQL upgrade guide to 4.1.x?
_________________
lxg.de – codebits and tech talk

celsum · Posted: Thu Jun 01, 2006 12:41 pm Post subject:

Hmm. After reconfiguring PHP everything is OK.

Thnx everyone.