Mini

Well-Known Member
Mar 4, 2005
98
0
156
Hello all,

I used the ELS script, http://www.nsonetworks.com/els.php to upgrade my MySQL version to 4.1 and did other things such as disable MySQL networking and made it a higher prioity and it seems as my PHP forums have stopped working.

An example of a PHP forum on my server is http://www.bigeyearts.co.uk/forum2.

I tried downgrading MySQL, but that doesn't help. I am thinking that it's a PHP issue and I will recompile PHP from scratch as a last resort, I have already recompiled it once with PHP support.

Thanks to anyone who can help me.
 

Blue|Fusion

Well-Known Member
Sep 12, 2004
378
0
166
Cleveland, Ohio
You have to recompile PHP after upgrading to MySQL 4.1 from 4.0 or else PHP will fail, thus apache fails to start. It will complain about a mysql library file not found, and that is the reason behind recompiling it with 4.1 support.
 

celliott

Well-Known Member
Jan 2, 2006
460
0
166
United Kingdom
Although these all-in-one scripts are good, I would always advise installing things manually, as its configured based on your server, and it also makes identifying problems much easier.

You cannot upgrade MySQL to 4.1 and then go back to 4.0 without having major database issues, since during the upgrade process your databases will have been modified.

Force a reinstall of MySQL 4.1 and then recompile apache

In your my.cnf add this:

[mysqld]
old-passwords

Then restart mysql and you should be ok.

You may also need to reinstall Perl so cPanel can properly control the new MySQL. Just grab the latest installer from http://layer2.cpanel.net, extract and execute.

If you are still unsure you could hire the services of Andy (www.servertune.com) or Chirpy's (www.configserver.com) which both have a very good reputation on these boards.

Chris