Koozali.org: home of the SME Server

-CCR- How to Upgrade MySQL to 4.0.x for SME Server

haj


ergozd

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #1 on: March 27, 2004, 09:20:13 AM »
I've been running MySQL 4 since 4.0.13 with the settings you describe and NO PROBLEMs what so ever so far. ;-)

whistler

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #2 on: March 27, 2004, 02:44:48 PM »
rpm -e --nodeps mysql mysql-client mysql-server
gave
error: package mysql-client is not installed

I did install the fallowing and I think no problems.
MySQL-bench-4.0.18-0.i386.rpm  MySQL-server-4.0.18-0.i386.rpm
MySQL-client-4.0.18-0.i386.rpm  MySQL-shared-4.0.18-0.i386.rpm
MySQL-devel-4.0.18-0.i386.rpm   MySQL-shared-compat-4.0.18-0.i386.rpm

Everything seems OK.

Anonymous

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #3 on: April 08, 2004, 03:01:01 PM »
Followed the HOW-To exactly as described on a fresh 6.0 install as well as a 6.0.1 installation. The client version detected after the upgraded is still listed as 3.28. On my 6.0.1 installation, the upgraded MySQL 4.0.18 no longer starts itself after a reboot, and must be started manually.

haj

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #4 on: April 09, 2004, 12:06:24 AM »
Quote from: "Anonymous"
Followed the HOW-To exactly as described on a fresh 6.0 install as well as a 6.0.1 installation. The client version detected after the upgraded is still listed as 3.28.


When you installed the rpms, didn't you have any error message ?
It should....

Quote
On my 6.0.1 installation, the upgraded MySQL 4.0.18 no longer starts itself after a reboot, and must be started manually.


Verify that:

- you have the two files /etc/rc.d/rc7.d/S90mysqld and /etc/rc.d/init.d/mysqld

- /etc/rc.d/rc7.d/S90mysqld is a symbolic link to /etc/rc.d/init.d/mysqld

Anonymous

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #5 on: April 09, 2004, 05:29:56 AM »
haj,

Thank you for your response. Below is the error that I receive prior to installing the RPM files.

rpm -e --nodeps mysql mysql-client mysql-server  
error: package mysql-client is not installed .

Afterwards, when I install the client program, everything seems to go fine, but when I check the version that is installed on my machine, it still comes back as "Client API version 3.23.56"

haj

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #6 on: April 09, 2004, 06:14:07 AM »
Quote from: "Anonymous"
haj,

Thank you for your response. Below is the error that I receive prior to installing the RPM files.

rpm -e --nodeps mysql mysql-client mysql-server  
error: package mysql-client is not installed .

Afterwards, when I install the client program, everything seems to go fine, but when I check the version that is installed on my machine, it still comes back as "Client API version 3.23.56"


What do you have when you type:
#rpm -qa | grep -i mysql

and wich version do you have when you type:
#  mysql

Anonymous

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #7 on: April 09, 2004, 07:00:30 AM »
haj,
#rpm -qa | grep -i mysql

MySQL-shared-compat-4.0.18-0
MySQL-client-4.0.18-0
perl-DBD-MySQL-1.2219-6
php-mysql-4.1.2-7.3.6es1
e-smith-mysql-1.10.0-02
MySQL-shared-4.0.18-0
MySQL-server-4.0.18-0
MySQL-devel-4.0.18-0

#mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.18-standard

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

mysql>


Thanks again!

Offline Rigger

  • ***
  • 71
  • +0/-0
-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #8 on: April 12, 2004, 09:03:06 PM »
I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.

http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html

Quote
After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section


--
Doug M.
"Rigger"

Anonymous

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #9 on: April 14, 2004, 08:42:48 PM »
Rigger,

If you go to phpmyadmin and click on "Show PHP Information" what do you see under "mysql Client API Version" ?

Mine shows..

Client API version  3.23.58  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/lib/mysql/mysql.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib/mysql -lmysqlclien

haj

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #10 on: April 15, 2004, 08:33:04 AM »
Quote from: "Rigger"
I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.

http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html

Quote
After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section



You are right I did  this also but forgot to put it in the how to

HowTo updated

Quote
f you go to phpmyadmin and click on "Show PHP Information" what do you see under "mysql Client API Version" ?

Mine shows..

Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclien


The tip below should do it :)

Offline wyron

  • *
  • 275
  • +0/-0
    • http://www.ideast.dk
-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #11 on: April 15, 2004, 08:49:15 AM »
Fine !
I did this upgrade yesterday (because of other issues described in a cry for help elsewhere), and ran the mysql_fix_script as advised on dev.mysql.com.
Luckily I have a dbtools manager installed, and that helped with my specific problem creating a grant (Thx, Dan, for your pointers in the 'Change Mysql password-howto').
Alls well that ends well!
But my yum hasn't figured out the update. This morning it presented me with a possibility to upgrade mysql to version 3.23.56-1.73
Apparently yum checks only version difference, not whether the installed version number is actually higher than the proposed.
How about it, Darrell ? (Not that I don't love your work! It has helped me out more times than I can count!).
Greetings
wyron
...

haj

-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #12 on: April 15, 2004, 11:55:13 PM »
Quote from: "wyron"
Fine !

But my yum hasn't figured out the update. This morning it presented me with a possibility to upgrade mysql to version 3.23.56-1.73
Apparently yum checks only version difference, not whether the installed version number is actually higher than the proposed.


Noticed that.
Yum check for greatest version number but it seems that mysql 4 rpm spec differ from 3.x versions rpms....

All we need is a rpm guru to package mysql 4 rpms for SME :)

Offline wyron

  • *
  • 275
  • +0/-0
    • http://www.ideast.dk
-CCR- How to Upgrade MySQL to 4.0.x for SME Server
« Reply #13 on: April 16, 2004, 07:04:34 AM »
Quote from: "haj"
Noticed that.
Yum check for greatest version number but it seems that mysql 4 rpm spec differ from 3.x versions rpms....
Aaah, I see. Thanks, Laurent, and: Oops, sorry Darrell.
Quote from: "haj"
All we need is a rpm guru to package mysql 4 rpms for SME :)

I agree sincerely. Perhaps this is a job for Dan Brown ? It should be right up his alley.
Greetings
wyron
...

glenn-cns

MySQL v4.1.11-standard works as well...
« Reply #14 on: August 10, 2005, 04:32:55 AM »
FYI,

This how-to works fine with MySQL 4.1.11-standard on e-smith 5.6 as well.