Topic: Upgrades Year!!!!

[Normando]

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.

[gregswallow]

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  

[Normando]

Greg. Thanks for the reply  

[gregswallow]

You inspired/challenged me to try it myself  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.