You are not logged in.
- Topics: Active | Unanswered
#1 2009-12-08 18:38:54
- Arcath
- Member
- Registered: 2008-04-08
- Posts: 27
Mysql Doesnt work after an update
After an update over the weekend apache+php+mysql+rails have stopped working (might not be when the version of mysql was relesed, i haven't updated this server in ages for this very reason).
After a couple of hours work ive got apache working again and php seems fine as does rails but both php and rails cant see mysql. Wordpress seems to think ive not got the php mysql extension installed.... which i do the config files havent been overwritten by pacman so it should still be working.
mysql is running and restarts fine (/etc/rc.d/mysqld restart) but nothing can see it.
Rails says:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
so has it been moved? or is it a permissions thing thats changed?
Offline
#2 2009-12-08 18:42:56
- wonder
- Developer
- From: Bucharest, Romania
- Registered: 2006-07-05
- Posts: 5,941
- Website
Re: Mysql Doesnt work after an update
Give what you have. To someone, it may be better than you dare to think.
Offline
#3 2009-12-08 19:17:14
- Arcath
- Member
- Registered: 2008-04-08
- Posts: 27
Re: Mysql Doesnt work after an update
Thanks!
ive got rails pointed at the net socket fine
how do i point php at the new socket?
Offline
#4 2009-12-08 20:48:02
- xxxspuddy
- Member
- Registered: 2007-05-15
- Posts: 57
Re: Mysql Doesnt work after an update
Edit your /etc/php/php.ini file and look for the value 'mysql.default_socket' and update it to reflect the path. Don't forget to restart apache after making the change
A temporary file is just a pipe with an attitude and a will to live.
Offline
#5 2009-12-08 21:24:42
- Arcath
- Member
- Registered: 2008-04-08
- Posts: 27
Re: Mysql Doesnt work after an update
Done that but it still doesnt work.
Offline
#6 2009-12-08 22:20:52
- foutrelis
- Developer
- From: Athens, Greece
- Registered: 2008-07-28
- Posts: 705
- Website
Re: Mysql Doesnt work after an update
Wordpress seems to think ive not got the php mysql extension installed.... which i do the config files havent been overwritten by pacman so it should still be working.
There's your problem right there. In the new PHP packages (version 5.3) the modules have been moved to a different location (and are built with a new API version). Apply any changes to the .pacnew configuration file and replace the old php.ini with it (of course, take a backup of the latter first).
Also, you shouldn't have to specify the socket path in php.ini. This was an old bug and was resolved in FS#17179.
Offline