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....