Topic: MySQL 4.0.21-0.i386 Upgrade for SME 6.0 HowTo:

[SharedMedia]

(Revised HowTO: SOON TO BE UPDATED)
This HowTO: has been posted many times, with numerous suggestions and error reporting. I have revised this HowTO: and WILL enable you to upgrade MySQL 3.23 to MySQL 4.0.20 (or later Versions) FLAWLESSLY on SME 6.0 Unsupported Release and show NEW version in any version of phpMyAdmin.

(Example)
Welcome to phpMyAdmin 2.6.0-alpha2
MySQL 4.0.20-standard running on localhost.....

1) DOWNLOAD MySQL 4.0.20-0.i386.rpm(s) or latest "Stable" Versions
Download MySQL 4.0 rpms from mysql.com (Linux x86 RPM downloads section) to
/home/e-smith/files/users/admin/home/MySQL-Upgrade-SME.6.0 directory. ( I created "MySQL-Upgrade-SME.6.0" to use)

Download the following:
MySQL-shared-compat-4.0.20-0.i386.rpm
 (Dynamic client libraries
(including 3.23.x libraries)  4.0.20-0 479.7K link)
MySQL-server-4.0.x-0.i386.rpm
(Server  4.0.20-0 9.8M link)
MySQL-client-4.0.x-0.i386.rpm
(Client programs  4.0.20-0 2.6M link)
MySQL-devel-4.0.x-0.i386.rpm
 (Libraries and header files  4.0.20-0 925.7K link)

  Note: replace 4.0.x with current MySql STABLE version availaible (was 4.0.20 at time of writing)

2) STOP MYSQL
service mysqld stop

3) REMOVE OLD RPMS
rpm -e --nodeps mysql mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

4) INSTALL NEW RPMS
Cd to the directory where you downloaded the rpms:
rpm -Uvh MySQL-*.rpm

5) CONFIGURE
chkconfig --levels 2345 mysql on
mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (to enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
ln -s /usr/sbin/mysqld /usr/libexec/ (for conf-mysql-password script)
service mysqld restart

Then to make sure that your grant tables are current when you update to the new version:
/usr/bin/mysql_fix_privilege_tables

Upgrade Complete ( No Errors )

[cydonia]

Has anyone tried the above and if so, how did it go?

I am going to need to upgrade since the current exported data causes problems with my virtual hosts server (running 4.0.x).

Also, do you lose your data in upgrading?*

Should you backup before the upgrade?

THanks.

[Normando]

work fine!!!!!!!!!!! No backups are necesary, no lose data!!!
Thanks SharedMedia

[cydonia]

Thanks for that.

Will give it a shot and let you know who it goes.

Cheers.
Tristan

[edb]

Thanks alot for the HowTo SharedMedia your instructions worked absolutely perfect.
I like no brainers ... do you have a HowTo on upgrading PHP to version 4.3

[cydonia]

Upgrade couldn't have gone smoother!  

Thanks for the HowTo.  It worked perfectly.


Thanks again.
Tristan

[SharedMedia]

Safe to Delete Posting.

[mbachmann]

Did you join the devinfo mailing list, SharedMedia?

[wyron]

Upgrade couldn't have gone smoother!  
Thanks for the HowTo.  It worked perfectly.
Thanks again.
Tristan

I really wish I could express the same sentiment.
I can't, though.
The upgade went smoothly (Howto followed to the letter), but in my case the result was 'package mysql is not installed' when I rpm -q mysql.
Whatever happened ??

[cydonia]

I really wish I could express the same sentiment.
I can't, though.
The upgade went smoothly (Howto followed to the letter), but in my case the result was 'package mysql is not installed' when I rpm -q mysql.
Whatever happened ??

Very strange indeed.  Apart from leaving two steps in the config stage out, i also followed it exactly.

I am running plain old 6.0.1, newly installed.

[wyron]

=cydonia
I am running plain old 6.0.1, newly installed.

Yeah - me too.
And I even went through the command line history to make sure I hadn't wet myself somewhere along the line.
The strange thing is, that the rpm's are installed (I tried to -Uvh them again).
Well then, I guess I'll have Yum install 3.23.58 for me, when I've reinstalled the server. Thank Linus I hadn't put it into production yet.

[SharedMedia]

Safe to Delete Posting.

[SharedMedia]

Safe to Delete Posting.

[Normando]

Hi SharedMedia. Thanks for the script, run ok, but I have one issue: After update to 4.0.21 with your script I have the following error when I execute mysql_setpermission:
[root@servidor bin]# mysql_setpermission
password=/SV1aAwt3ouMzYvEA+lMoEp0mS6T3bhInAsI1pkvo6+mObj8n1qmdPfooW1xnb/E6rvVgtEAWM7S


#------------------------------------------------------------
# TEMPLATE END
#------------------------------------------------------------
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
 at (eval 7) line 3
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/bin/mysql_setpermission line 70

[root@servidor bin]#

What happens? I use very much mysql_setpermission.
In your first howto about upgrade mysql, I have no trouble with mysql_setpermission. The first howto you write based in 4.0.20, and this script is based in 4.0.21 What you think
My webmail have error now and I don't login. PHPMyAdmin, have the same error:
1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

Well, my server run ok before I use this script.

Please, if you can help me because I tested in the production server, and now is crash!!!!

[Normando]

I have fix this.........ufffffffffffffff
Well, I downgrade from 4.21.0 to 4.20.0 and now run ok!!!! Please, to the comunity, test this script (for 4.21.0) in test server.
I don't know if it's important, but I have php 4.3.9
PicsOne

[TrevorB]

Upgrade couldn't have gone smoother!  
Thanks for the HowTo.  It worked perfectly.
Thanks again.
Tristan

I really wish I could express the same sentiment.
I can't, though.
The upgade went smoothly (Howto followed to the letter), but in my case the result was 'package mysql is not installed' when I rpm -q mysql.
Whatever happened ??

Try rpm -q MySQL (that is what you installed - you removed mysql...)

Trevor B

[miked]

Dear PicsOne,

I did the same as you and installed  the latest package and run into the same error.

How did you downgrade the package ?

I used the command "rpm -e --nodeps MySQL-server-4.1.11-0"


And I get the following message:"error reading information on service mysql: No such file or directory
error: execution of %preun scriptlet from MySQL-server-4.1.11-0 failed, exit status 1"

Any help would be highly appreciated.

Thank You!
Mike

[moleboy]

I see that the latest version of MySQL is 4.0.24 - has anyone used this How-To to upgrade to 4.0.24?

I'll be using MySQL primarily with PHP (version 4.1.2).

Given the comments previously made in this thread, might it be better to install 4.0.20 ?

Thanks in advance.

[gaarons]

Not sure about anyone else, but I was having problems with mysql retstarting on boot after running this update and using the script, I found that the link;
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld
was creating a link to a non-existent script. It should have been pointing to /etc/rc.d/init.d/mysql

I changed this and it retstarts fine.

[thedude]

Whew, this one saved my butt. I followed instructions for an older sme version, and my sme version wouldn't work with that HowTo.

this one worked like a charm.

Haven't tried the reboot yet

[artful]

Hi

I got an error trying to upgrade to either 4.1.14-0.i386.rpm or
4.0.26-0.i386.rpm

it need 'coreutils', whatever that may be

[root@brussels mysql]# rpm -Uvh MySQL-*.rpm
error: failed dependencies:
        coreutils is needed by MySQL-server-4.1.14-0
[root@brussels mysql]#

Any suggestions?

[ergozd]

Description of coreutils

Code: [Select]

These are the GNU core utilities.  This package is the combination of
the old GNU fileutils, sh-utils, and textutils packages.

If I am not mistaken all these 3 paclages are installed by default so you can install MySQL with --nodeps option.

Good luck.

[dmajwool]

A supplier has written an application that requires MySQL 4.1.  Has anyone done a sucessful upgrade to that version on SME 6.0.1.  ATM, I'm running 4.0.22-0

Many thanks, David

[ergozd]

I've had MySQL-4.1.x running for some time, no issues what so ever...

Check upgrade script at my homepage
http://ergin.dyndns.org/download/?q=node/4

PS: Don't forget to backup before you do anyting...

[dmajwool]

Check upgrade script at my homepage
http://ergin.dyndns.org/download/?q=node/4

Very many thanks for this.  
The script is failing to find the rpm MySQL-shared-compat-4.1.14-0.i386.rpm on the mirror.trouble-free.net, and I can't see it there either. I don't find it on Google either.
Has this rpm been renamed since you last upgraded the script?

Thanks again
David

[ergozd]

You're correct! MySQL-shared-compat-4.1.13 is the latest released RPM providing shared libraries for 3.23.x, 4.0.x and 4.1.x

Anyway, I've modified the script to download files from my own server and hopefully that'll slove the issue. Good luck...

[dmajwool]

That seems to have fixed the error.  MySQL version 4.1.14 now installed on SME6.0.1
Very many thanks.  David.