Koozali.org: home of the SME Server

MySQL5.X on SME 7rc2

Offline mike_mattos

  • *
  • 313
  • +0/-0
MySQL5.X on SME 7rc2
« Reply #15 on: May 30, 2006, 05:19:51 PM »
DID IT!  I'm posting this as a new thread , maybe someone can test it and it can be set up as a how to?   Anyway , for search purposes, I'm reposting as How To install MySQL5 on SME7



NOTE :  Do this on a fresh install, because it is likely to destroy some settings and data!

1   #  mysql
         logs in as version 4.1.12

2   mysql> quit;

3  # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: run (pid 29128) 53510 seconds, normally down

4 # /etc/rc.d/init.d/supervise/mysqld stop
Stopping mysqld:                                           [  OK  ]

5 # /etc/rc.d/init.d/supervise/mysqld status
/service/mysqld: down 6 seconds

6 #   rpm -e mysql-server  --nodeps

7 # rpm -e mysql  --nodeps

8  Download
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-5.0.18-1.c4.i386.rpm
http://dev.centos.org/centos/4/testing/i386/RPMS/mysql-server-5.0.18-1.c4.i386.rpm

Do NOT get the versions with 5.0.18-2.1, they fail dependecies!

9 #  rpm -Uvh mysql-5.0.18-1.c4.i386.rpm

10 #   rpm -Uvh mysql-server-5.0.18-1.c4.i386.rpm

11 #  mysql  ( see what happens )
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

13 reboot

14  #  mysql   ( make sure it restarted automatically! )
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

15 Check Web Mail
A fatal error has occurred
DB Error: insufficient permissions
Details have been logged for the administrator.

16 Reset  per Charly Brady   , destroys data!!
# cd /service/mysqld
# runsvctrl d .
# /etc/e-smith/events/actions/mysql-delete-db-files
# signal-event post-upgrade
# signal event reboot

15 Check Web Mail
GOT LOGIN!!!
...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
MySQL5.X on SME 7rc2
« Reply #16 on: May 30, 2006, 11:03:29 PM »
Quote from: "mike_mattos"
NOTE :  Do this on a fresh install, because it is likely to destroy some settings and data!

How about making a backup and restoring that at the moment you have MySQL running again... have you tested that as well?
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)