Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Normando on January 01, 2005, 12:05:02 AM

Title: Upgrades Year!!!!
Post by: Normando on January 01, 2005, 12:05:02 AM

This year (2004) is full for updates...PHP...SAMBA...APACHE...MYSQL...IMP and more.

Now, that is the question..Any one can upgrade MYSQL to 4.1.x???
THis version has a lot of usesfull changes, and more complicated to upgrade.

Title: Upgrades Year!!!!
Post by: gregswallow on January 01, 2005, 01:32:21 AM

Good luck - read this post before you think about trying it.
http://forums.contribs.org/index.php?topic=24998.0

If you really want to try then start here I guess:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html

I have yet to *need* 4.1 over 4.0... what good stuff is out there that requires 4.1?

EDIT:  LOL, I just realized that was your post  :lol:

Title: Upgrades Year!!!!
Post by: Normando on January 01, 2005, 09:56:08 PM

Greg. Thanks for the reply  :-D

Title: Upgrades Year!!!!
Post by: gregswallow on January 02, 2005, 11:44:17 PM

You inspired/challenged me to try it myself :-P  You still never told me what you wanted to use that required 4.1 though...but I had fun, so its ok.

I think I have figured it out (mostly).  You need to make a template fragment saved as

Code: [Select]

/etc/e-smith/templates-custom/etc/my.cnf/010oldpasswords
containing just the text:

Code: [Select]

old-passwords
This will make the mysql daemon start with support for older style passwords (as suggested on their website).  After you do that run:

Code: [Select]

/sbin/e-smith/expand-template /etc/my.cnf

You also need to run /usr/bin/mysql_fix_privilege_tables --password=(76 character default ldap password).  This is trickier than with the 4.0 upgrade because it will not run without specifying the password.  The 76 character password can be found by installing the phpmyadmin contrib and looking in the file /opt/administration/phpmyadmin/config.inc.php

After those things are done, post-upgrade and reboot and you will have mysql 4.1.8.

There are some other notes on the Mysql page I quoted abouve such as needing updated DBD or DBI packages or something, but webmail still works and phpmyadmin works after doing this - no other testing done yet.  I will work on that.

Just a note - it is normal that the mysql update changes collation of tables to latin_swedish from latin after the upgrade - don't ask me whay, but I read it on their website.  I'll post some more detialed step by step instruction in a bit.

EDIT:More instructions here - http://forums.contribs.org/index.php?topic=25414.0 - lets move discussion to that thread.