Topic: MySQL v4.0.21 upgrade script

[Rigger]

Down and dirty script to upgrade MySQL to ver 4.0.21 on SME 6.01-1. Based off my previous php upgrade script. If you try it on other SME versions and it works ok drop a note in the contribs.org forum.

Should recognize and upgrade mysql version 3.2.x and 4.0.(16-20). Look in the script for the real heros list. They did the hard part.

http://mirror.contribs.org/smeserver/contribs/dmusty/SME6.0/scripts/MySQL-4.0.21.sh


___
Doug M.
"Rigger"

[Henk]

Just used it on an SME 6.01. server. The server needed a reboot before everything was running. But as far as I can see the MySQL update runs like a charm now.

[edb]

I ran the script to upgrade from version 4.0.20 and all seems to go fine up to the last part then it gives me the error below and MySQL still reads version 4.0.20. Any help would be appreciated. Thanks

Killing mysqld with pid 29662
Wait for mysqld to exit........... done
Preparing...                ########################################### [100%]
package MySQL-shared-compat-4.0.20-0 is already installed
error reading information on service mysql: No such file or directory
ln: /usr/libexec//mysqld': File exists
No mysqld pid file found. Looked for /var/lib/mysql/mail.pid.
Done.....
[root@mail root]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.20-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \q
Bye
[root@mail root]#

[edb]

Just to let you know ... the problem for some reason was with the MySQL-shared-compat-4.0.20-0.i386.rpm since it was already installed. This seems to have stopped the script from running completely.
I installed the remaining -4.0.21rpms manually and all is well now.
The MySQL now reads the proper version.
I'm curious as to why phpinfo is reading the clientAPI version as 3.23.58? Should this not read 4.0.21 as well?
By the way, I used your PHP upgrade script to version 4.3.8 and it worked perfectly.  

Great work ...I'm truely impressed with the power of these scripts and your dedication to helping the community. Sure makes things easier.

[Rigger]

Thanks for the feedback edb. Both the problems you noted should be fixed now.

Didn't notice that the MySQL-shared-compat is still version 4.0.20 on this release. Script now should recognize that 4.0.20 is already installed and skips the MySQL-shared-compat package. Also checks to see if the /usr/libexec/mysqld link already exists and will not try to create it again.


Doug M.
"Rigger"

I ran the script to upgrade from version 4.0.20 and all seems to go fine up to the last part then it gives me the error below and MySQL still reads version 4.0.20. Any help would be appreciated. Thanks

Killing mysqld with pid 29662
Wait for mysqld to exit........... done
Preparing...                ########################################### [100%]
package MySQL-shared-compat-4.0.20-0 is already installed
error reading information on service mysql: No such file or directory
ln: /usr/libexec//mysqld': File exists
No mysqld pid file found. Looked for /var/lib/mysql/mail.pid.
Done.....
[root@mail root]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.20-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \q
Bye
[root@mail root]#

[Henk]

Updating from the orginal MySQL on SME 6.01.01 I had some problems. I cannot recall the errors exactly, but the commands after rpm -Uvh *.rpm didn't execute without errors. Had to do these steps manual. I remember something about a socket error.

[thedude]

Well the script installed ok, but it killed my connection between php and mysql:

From phpmyadmin:
cannot load mysql extension,
please check PHP Configuration

From a script:
Call to undefined function: mysql_connect()

SME 6.01.01
mysql 4.0.21
PHP Version 4.3.8

Crud, reformat here I come. Unless anyone has a suggestion?

[Normando]

Uninstall 4.0.21 and reinstall 4.0.20. See my last post here:
http://forums.contribs.org/index.php?topic=23920.0

PicsOne