D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Jaunty->Karmic upgrade gotcha

 

Martin Gautier wrote:
A couple of days ago I upgraded a server from Ubuntu Jaunty (9.04) to Karmic (9.10)

All seemed to be well apart from vnc4server not working anymore (but that's an aside which I've not looked into yet).

I tried accessing one of my development mysql databases today to find that mysqld wasn't running. A "/etc/init.d/mysql restart" followed by a "tail /var/log/syslog" gave my this error message "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock".

After googling and a lot of messing around with permissions etc. (to cut a long story short), I renamed my "/etc/mysql/my.cnf" replacing it with "my.cnf.dpkg-dist" and started mysqld. It failed first time with an error about event scheduler tables being damaged but running "/etc/init.d/mysql restart" straight afterwards got it going with no errors.

The only differences between the two "my.cnf"s were in my broken my.cnf which had these extra lines:

language    = /usr/share/mysql/english
bind-address = 192.168.1.3 (my server's IP address. the fixed file uses 127.0.0.1)
thread_stack        = 128K                  (the fixed file has 192K)
skip-bdb
skip-federated


Regs
Martin
I've upgraded 4 machines from 9.04 to 9.10 and had no problems with any of the MySql implementations.
Tom te tom te tom


--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html