Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Normando on November 29, 2004, 11:29:12 PM

Title: [Announce] How to Downgrade from mysql 4.1.x sucessfully
Post by: Normando on November 29, 2004, 11:29:12 PM

SME don't support mysql 4.1.x and above because that version
utilizes diferent hash password and other issues.
So please, don't upgrade to this version till SME developers fix this issue.
When I upgrade to 4.1.7 mysql apparently run ok, but when I execute post-upgrade
(after upgrade horde and imp webmail) I discover the mysql error.

After hours and hours I found a solution for downgrade 4.1.x to 4.0.x.

Some people trying to downgrade not been sucessfully, because they didn't delete
mysql database in /var/lib/mysql/.

So, follow this intructions (my case is for 4.1.7 downgrade to 4.0.2)

-------------------------------------
service mysqld stop
rpm -e --nodeps MySQL-client-4.1.7-0
rpm -e --nodeps MySQL-devel-4.1.7-0
rpm -e --nodeps MySQL-shared-compat-4.1.7-0
rpm -e --nodeps MySQL-server-4.1.7-0

;;may be you have errors when uninstalling, don't worry

cd /var/lib/mysql/mysql
rm -f *

;;Now go to your 4.0.x rpm directory and then

rpm -Uvh --force *

chkconfig --levels 2345 mysql on

mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld

;;answer y for replace mysqld old file.

rm /etc/rc.d/rc7.d/S90mysqld

;;answer y for delete

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 if you want.

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

ln -s /usr/sbin/mysqld /usr/libexec/

;;if the file exist, don't worry.

service mysqld restart

;;tipe now 'mysql' without cuotes and you get:

;;ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

;;follow this commands to restore root password

/etc/rc.d/init.d/mysqld stop

/etc/e-smith/events/actions/conf-mysql-password

/etc/rc.d/init.d/mysqld start

;;that's all
;;If you have upgrade webmail:
/sbin/e-smith/signal-event post-upgrade
;; and then
reboot

;;ENJOYYYYYYYYYYYYYYYYYYY
thanks...thanks...thanks....

Title: [Announce] How to Downgrade from mysql 4.1.x sucessfully
Post by: mvdlinden on January 19, 2005, 10:04:43 PM

PicsOne, you're the best!
Several (VMWare) SME's I've been fooling around with to test updates, contribs etc gave MySQL errors.
Following your steps made it work again!
THX a million!
Maarten

Title: [Announce] How to Downgrade from mysql 4.1.x sucessfully
Post by: gregswallow on January 20, 2005, 12:17:56 AM

MySQL 4.1.8 does work - http://forums.contribs.org/index.php?topic=25414.0

Title: [Announce] How to Downgrade from mysql 4.1.x sucessfully
Post by: Normando on January 21, 2005, 04:35:04 AM

Thanks Marteen for your commentaries, but now MySQL 4.1.8 work ok, thanks to Greg