Incompatibility Mysql 4.0.x and NPTL please clarify

[eva2000]

As i understand the latest WHM notice below means there are 2 issues to deal with for NPTL based systems ?

Important Notice: Incompatible versions of Mysql 4.0.x and NPTL based systems.
If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*), we recommend upgrading to MySQL 4.1.x as we have determined that there are compatibility issues on these platforms. You can easily upgrade to 4.1.x by changing the Mysql Version in Tweak Settings
If you are worried about compatibility with MySQL 4.0, be sure to check the box labeled: Use old style (4.0) passwords with mySQL 4.1. in Tweak Settings.
If you are unsure if your system is NPTL based, run getconf GNU_LIBPTHREAD_VERSION at the command line and see if it displays NPTL.
* 4.0.23 does not have any known issues, but is subject to security vulnerabilities: http://cve.mitre.org/cgi-bin/cvename...=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename...=CVE-2006-1517

-----------------------------------------------------------
Issue 1.

For security issues fix is to update to MySQL 4.0.27 or 4.1.19 or 5.0.21 according to the mysql.com changelogs

i.e.

4.0.27
http://dev.mysql.com/doc/refman/4.1/en/news-4-0-27.html

4.1.19
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-19.html

5.0.21
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-21.html

all list

Security fix: A malicious client, using specially crafted invalid login or COM_TABLE_DUMP packets was able to read uninitialized memory, which potentially, though unlikely in MySQL, could have led to an information disclosure. (CVE-2006-1516, CVE-2006-1517) Thanks to Stefano Di Paola <stefano.dipaola@wisec.it> for finding and reporting this bug.

-----------------------------------------------------------
Issue 2.

Compatibility issues with NPTL based systems with MySQL 4.0.24 and higher 4.0.xx versions. But only some folks are affected and some have no problems ? As you stated in what i highlighted in bold

If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*)

Can you elaborate on the 2nd issue ? there's been hundreds of CentOS 4 based servers running for ages with 4.0.25 at least with WHM users and most don't seem to have issues that I am aware of ???

[eva2000]

Also just heads up if you do plan to upgrade from MySQL 4.0.xx to 4.1.xx system read http://dev.mysql.com/doc/refman/4.1/...-from-4-0.html FIRST

Best way to eliminate the listed incompatibilities between 4.0.xx and 4.1.xx tables at http://dev.mysql.com/doc/refman/4.1/...-from-4-0.html is to mysqldump your databases to sql files and reimport them into newly updated MySQL 4.1.xx server created new empty databases

[nocser]

Hello

I need help. I follow as per instruction in WHM to upgrade my MYSQL from 4.0.x to 4.1.18-standard. After the upgrade seem all my script not working correctly. Some never load, some not fully load and some loaded to login page but not login after enter correct password and user name.

I able to access via ssh and whm. No use even after I force update mysql. Server status all fine (green)

Urgent help needed please

[eva2000]

Hello

I need help. I follow as per instruction in WHM to upgrade my MYSQL from 4.0.x to 4.1.18-standard. After the upgrade seem all my script not working correctly. Some never load, some not fully load and some loaded to login page but not login after enter correct password and user name.

I able to access via ssh and whm. No use even after I force update mysql. Server status all fine (green)

Urgent help needed please

read http://dev.mysql.com/doc/refman/4.1/...-from-4-0.html

1. Important backup mysql databases on 4.0.xx server first via mysqldump to sql files
2. Run mysql_fix_privileges_tables script

After upgrading, update the grant tables to obtain the new longer Password column that is needed for more secure handling of passwords. The procedure uses mysql_fix_privilege_tables and is described in Section 5.5.1, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”. If you do not do this, MySQL does not use the new more secure protocol to authenticate. Implications of the password-handling change for applications are given later in this section.

On WHM based servers with CentOS, you'll find it at

/usr/bin/mysql_fix_privilege_tables

3. Best way to eliminate the listed incompatibilities between 4.0.xx and 4.1.xx tables at http://dev.mysql.com/doc/refman/4.1/...-from-4-0.html is to mysqldump your databases to sql files and reimport them into newly updated MySQL 4.1.xx server created new empty databases

[nocser]

Can I know how to mysqldump the old version 4.0? I already upgraded to 4.1.x?

When I run mysql_fix_privileges_tables, I got this error

================
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
================

many thanks

[gemby]

Ok, all my 4.0.x boxes are succefuly upgraded to 4.0.27, but 4.1 boxes a still waiting for list to be updated: http://updates.cpanel.net/mysqlinstall/version
Please, vote for http://bugzilla.cpanel.net/show_bug.cgi?id=4213

[nocser]

I update php to 4.4.2. Some of the script seem like ok. Some are not. Some show "Internal Server Error"

Any help?

[webignition]

I update php to 4.4.2. Some of the script seem like ok. Some are not. Some show "Internal Server Error"

Any help?

I doubt you'd get much help posting such a vague question in a thread that isn't relevant to PHP.

If you have phpsuexec enabled, which is likely if you're getting HTTP 500 errors with PHP scripts, search the forums for solutions as they're all out there somewhere!

[ctbhost]

Can I know how to mysqldump the old version 4.0? I already upgraded to 4.1.x?

When I run mysql_fix_privileges_tables, I got this error

================
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
================

many thanks

i have the same problem and get the same error when i run mysql_fix_privileges_tables

[AndyReed]

Can I know how to mysqldump the old version 4.0? I already upgraded to 4.1.x?

When I run mysql_fix_privileges_tables, I got this error

================
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

If you didn't mysqldump before upgrading to MySQL 4.1.x, then it is a little too late. You'll have to get your databses from the backup.

[rs-freddo]

i have the same problem and get the same error when i run mysql_fix_privileges_tables

mysql_fix_privileges_tables --password=[mysql root password]

[Tapan]

Hi,

So the issue is that one should update or not ?
Atleast PSM suggested me not to update unless i am having problems which i am not.

Thanks.

[MaxPowers]

4.0.26 worked great for me until I tried to install software that required at least 4.1.13

I installed 4.1.19 and went through every process outlined here and at the MySQL site... restored my backup DB's, rebuilt Apache/PHP, ran the code to get longer password fields (successfully), I even rebooted the server...

Every login on my server is dead (500 HTTP). From phpBB to CubeCart to my own homegrown login scripts. The stores show products, stats from the DB show on my pages, everything else is fine...

I've toggled 4.0 and 4.1 passwords back and forth with no joy.

Any additional input?

Should I try 5.0 or will that just worsen matters? how would I go about reverting to 4.0.26?

[katmai]

usually rebuilding apache with /scripts/easyapache should do the trick ... worked for me as for dozens of users here on the forum.

i ment after mysql upgrade, apache rebuilding is compulsory if you want your pages to load.

[MaxPowers]

I did rebuild Apache, but not using that method... I used the CPanel web interface to do it. I'm rebuilding again with easyapache and I'll get back to you on what happens.