mysql 4.0.24 and mysql4.1.10a released

[Chrysalis]

These both fix a bug that allows someone to crash the mysql process.

[vandal]

thank you!

[servertweak]

sorry , i need how to upgrade by shh.

centos 3.4

[vandal]

the following assumes you have the official MySQL rpms installed (i.e. 4.0.23)

cd /usr/src/redhat/RPMS/i386

Grab MySQL Server Rpm

wget http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-server-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/


Grab the MySQL Client Rpm


wget http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-client-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/


Grab the MySQL Libraries/headers Rpm


wget http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-devel-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/


Grab the MySQL dynamic libs (shared) Rpm


wget http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-shared-4.0.24-0.i386.rpm/from/http://mysql.serenitynet.com/


*note i gave you direct links from a MySQL mirrors page (normally this is bad, and you should check your hash), from http://dev.mysql.com/downloads/mysql/4.0.html

now to install them. The following assumes that those are the only MySQL rpms you downloaded to this directory.


rpm -Uvh MySQL*


this automatically restarts mysql but it's also safe after to run


service mysqld restart


and then test a few sites that use mysql and make sure everything is running smooth and you are done.

[Newbee]

Hi

For some reason I couldn't do a 'direct' wget (was very slow) so I downloaded the files to my computer then ftp'd them to the server and did a wget from there.

I used cuteftp to upload the rpms, but I don't think they were uploaded in ascii (as its not in the ascii list) is that ok?

on installation i got the errors below. Should I re-install?


warning: MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-shared ########################################### [ 25%]
2:MySQL-client ########################################### [ 50%]
3:MySQL-devel ########################################### [ 75%]
4:MySQL-server ########################################### [100%]
Installing all prepared tables
050323 20:02:24 Warning: Asked for 196608 thread stack, but got 126976
050323 20:02:24 /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h mydomainname.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

[Newbee]

p.s I don't think its worked because I have restarted the box but it phpmyinfo it still says:

Client API version 4.0.17

:-/

[Newbee]

I tried it again but this time it says:

warning: MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
package MySQL-shared-4.0.24-0 is already installed
package MySQL-client-4.0.24-0 is already installed
package MySQL-devel-4.0.24-0 is already installed
package MySQL-server-4.0.24-0 is already installed
:-(

[mjm]

Is this a remotely executable bug?

[Chrysalis]

client API version will be the version compiled into php, so if you update mysql and leave php be then it will still show the same version. A easy way to check is to login to phpmyadmin and see at the top what version is running eg. mine says.

MySQL 4.0.24-log running on localhost as xxxxxxxx@localhost

[Newbee]

Yup it says:

MySQL 4.0.24-standard running on localhost as my_test@localhost

Does this mean I have to do anything to php tho (ie is it using the new or old version?) Or is it just the version 'name' that is compiled into the phpinfo?

[tribal-dolphin]

Originally posted by Newbee
p.s I don't think its worked because I have restarted the box but it phpmyinfo it still says:

Client API version 4.0.17

:-/

It's normal, you don't have compile PHP to use external client of MySQL.
Just modify configure.php for do this.

[Newbee]

thanks :-)

[sander815]

Originally posted by tribal-dolphin
It's normal, you don't have compile PHP to use external client of MySQL.
Just modify configure.php for do this.

and how could i do that? can you describe?

[tribal-dolphin]

Very simple, take a look to PHP configuration help
(./configure -- help ine the PHP source directory)

You see that :
--with-mysql => For the included client
--with-mysql=[DIR] => For an external client.

In my case (RH9 box with official Mysql 4.1.10a RPM) the value is :
--with-mysql=/usr/lib/

Just modifiy the line in configure.php and do a ./build -n php

That's all folk :)

[sander815]

so included client = mysql 4.0.x?

[tribal-dolphin]

Originally posted by sander815
so included client = mysql 4.0.x?


That depends of your version of PHP.
The last 4.3.x et 5.0.x are runing a 4.0.x client.

[sander815]

4.3.10

[Chrysalis]

included client in php 4.3.10 is actually quite old I believe its 3.x

[sander815]

phpinfo says Client API version 4.0.18

[Chrysalis]

Client API version => 3.23.49

thats what I got from a box using built in mysql client.

4.0.18 is using your mysql 4.0.18 client.

[sander815]

hmm, ok
i get it now: in configure.php i have this:
--with-mysql=/usr \

but the mysqlclient is in /usr/lib, if i am right?:

[root@server01 mysql]# ls
libdbug.a libmerge.a libmyisammrg.a libmysqlclient.la libmysqlclient_r.la libmysys.a libvio.a
libheap.a libmyisam.a libmysqlclient.a libmysqlclient_r.a libmystrings.a libnisam.a mysqld.sym
[root@server01 mysql]# pwd
/usr/lib/mysql
[root@server01 mysql]#

[tribal-dolphin]

Originally posted by sander815
hmm, ok
i get it now: in configure.php i have this:
--with-mysql=/usr \

but the mysqlclient is in /usr/lib, if i am right?:

You're right.
The configure of PHP scan subdirectories i think. (in other RH box, i've inidicate only /usr and it was OK)

[Rook]

Does anyone know how to delete the installed version then install a fresh copy?

It's telling me I already have the latest version but I'd like a fresh/clean install because I think the last one messed up a bit - because of the errors it reported.

Regards.

[jmstacey]

It depends on what Operating System your using. If it's rpm based it's probably possible to simply have your rpm manager do the cleanup for you.

[Rook]

Hi Jmstacey

Could you eloborate please?

I'm on a red hat 9 - how do I get the rpm manager to do this?

Cheers.

[jmstacey]

Unfortunately I can't give you detailed instructions since I haven't used RedHat, Mandrake (desktop) is the closest I've gotten that uses an rpm manager (besides the port for slackware).

The manual would be the best place to start.
Here's a sample of what turned up searching google for "uninstall redhat rpm":
http://www.rt.com/man/rpm.8.html
http://www.faqs.org/docs/securing/chap4sec23.html

[Rook]

Thanks - I'll take a look. :)

[redeye]

While upgrading I get this:

rpm -Uvh MySQL-server-4.0.24-0.i386.rpm
warning: MySQL-server-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
1:MySQL-server ########################################### [100%]
error: unpacking of archive failed on file /etc/init.d/mysql;425b5263: cpio: open failed - Permission denied
[root@ws01 root]# rpm -Uvh MySQL-client-4.0.24-0.i386.rpm
warning: MySQL-client-4.0.24-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
error: unpacking of archive failed on file /usr/bin/msql2mysql;425b527e: cpio: open failed - Permission denied


Running FC1, rebooted with a checking of the FS. What can this be?

df -k:
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda2 76984708 62302104 10771984 86% /
/dev/sda1 101086 17247 78620 18% /boot
none 515988 0 515988 0% /dev/shm
/dev/tmpMnt 483886 85 458801 1% /tmp

enougn diskspace, other packages install correct :(

[jmstacey]

I would suggest attempting to upgrade MySQL by hand since it seems that several people have had problems with l0rdphi1's upgrade script, which could possibly be because there are small differences between RedHat and Fedora Core x.
Best thing to do is go through the process manually writing your own script as you go that way you may be able to submit any modifications to l0rdphi1 for the public.

[spirit]

Is there already a new updatescript?

[jmstacey]

I haven't heard any news of an updated one for Fedora Core yet :(