Incompatibility Mysql 4.0.x and NPTL please clarify

eva2000

Well-Known Member
Aug 14, 2001
339
15
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
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.cgi?name=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename.cgi?name=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 <[email protected]> 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 ???
 
Last edited:

eva2000

Well-Known Member
Aug 14, 2001
339
15
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
Last edited:

nocser

Member
Jan 13, 2006
10
0
151
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

Well-Known Member
Aug 14, 2001
339
15
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
nocser said:
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/en/upgrading-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/en/upgrading-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 :)
 
Last edited:

nocser

Member
Jan 13, 2006
10
0
151
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
 

nocser

Member
Jan 13, 2006
10
0
151
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

Well-Known Member
Jan 22, 2005
1,880
0
166
nocser said:
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

Well-Known Member
May 31, 2002
139
0
316
nocser said:
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

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
nocser said:
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.
 

MaxPowers

Member
Feb 3, 2006
8
0
151
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?
 
Last edited:

katmai

Well-Known Member
Mar 13, 2006
562
2
168
Brno, Czech Republic
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

Member
Feb 3, 2006
8
0
151
Using that specific method (instead of buildapache) got me somewhere... it's not where I want to be, but I think I can get it from here... Thanks for the advice.

CPanel text on the upgrade area is ambiguous as to which method to use... or I'm just a special case :)
 

dawntreader

Registered
Feb 10, 2006
2
0
151
okay, I've been having a few problems with(I believe) software on my server
I think it's a problem with php/msql because when I go into the root WHM I get an error about mysql but when I do what it says to fix it it stays the same. I also have been having trouble installing some php scripts, and I'm not entirely sure, but I think they've all been ones that used mysql and a few other scripts I had installed and working fine have just stopped working. My server is running CentOS 4.3

when I login to my WHM cpanel, I get the following message;

"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.cgi?name=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1517 "

I've done what it suggested two or three times, and it seems to show no change. I did the getconf and confirmed that the system is NPTL.

when I get to the install script on a php program, whether or not I've entered details manually into the config file, it'll usually show the first page that you're supposed to see but when I click next, in firefox it tries to save the install.php file but can't open it, in IE it says the connection was lost. I get the same result on my Windows XP desktop and laptop and on my Kubuntu Linux machine.

I tried to upgrade mysql to version 5, by searching the CentOS forums for info on it, but it didn't work, I think I didn't have the right addresses or something, and it just... didn't work(never installed it or anything) and I'm not sure why.

I restarted mysql and apache and I tried to reboot the server, first a graceful restart which failed, then a forceful reboot, which also failed.

Another small problem I've been having is with ftp accounts created through other accounts. Like, the main ftp account for a domain or whatever works fine, but when I try to create another one in the cpanel, I get a 530 Login incorrect error when I try to use it. I've tried this with several created ftp accounts, so it can't just be a typo. I don't know if this could possibly be related, so I included it as well.

I've contacted the company I rent my server from, and they indicated that updating and restarting all those things *should* have fixed the message at least, but it didn't, so short of reformatting and starting over, they suggested that I look at the cpanel forum.

any help would be appreciated, thanks!
 
Last edited:

rs-freddo

Well-Known Member
May 13, 2003
834
1
168
Australia
cPanel Access Level
Root Administrator
dawntreader said:
...I've contacted the company I rent my server from, and they indicated that updating and restarting all those things *should* have fixed the message at least...
LOL, the message is generic and will stay there till cPanel takes it off. It has nothing to do with the version of Mysql you're running.
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
dawntreader said:
when I login to my WHM cpanel, I get the following message;

"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,
Did you follow the instructions given on how to upgrade MySQL at WHM >> Server Configuration >> Tweak Settings >> MySQL
1) Seclect either v4.x or v5.x
2) check "Use old style (4.0) passwords with mySQL 4"

When doen, run these commands at the prompt:

3) /scripts/mysqlup
4) /scripts/easyapache
5) /scripts/perlinstaller --force Bundle::DBD::mysql

If every thing goes fine, you shouldn't have any problem with either MySQL and/or Php.


when I click next, in firefox it tries to save the install.php file but can't open it, in IE it says the connection was lost. I get the same result.
That means Php wasn't compiled successfully.

I tried to upgrade mysql to version 5, by searching the CentOS forums for info on it, but it didn't work
Follow the 5 steps mentioned above.

I've contacted the company I rent my server from, and they indicated that updating and restarting all those things *should* have fixed the message at least, but it didn't
:eek: :confused:
 

dawntreader

Registered
Feb 10, 2006
2
0
151
The first two steps were the ones that I'd done so many times with no effect. I did them again, and followed with the last three of the five.

3 and 4 worked fine, but when I tried 5 I got

Warning: Cannot install Bundle:BD::mysql, don't know what it is
Try the command

i /Bundle:BD::mysql/

but when I tried to use i /Bundle:BD::mysql/ I got command not found

but I tested things and they seem to be working now. It doesn't seem like I need to reinstall scripts or anything, so I guess that's enough steps for that for now at least.

I'm a bit new still at Linux and command line, so thanks for all the help!