Missing MySQL.sock file

Missing MySQL.sock file

by Christopher Phillips -
Number of replies: 4
I just ran the upgrade from 1.1.1 to 1.2.1 and somehow my mysql.sock file was deleted-
It is supposed to be located at /var/lib/mysql/mysql.sock

but when I try to connect through phpmyadmin I get:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

and it is as if none of my databases exist when I try to connect to them.

This problem actually happened to me before when I was upgrading another open source CMS (Before I'd found Moodle wink ), so I'm guessing it's some kind of problem with my configuration rather than a Moodle issue-

Does anyone have any insight into what might have caused this? I'm reinstalling mysql right now, so I think that'll fix the problem, but I'm a little hesitant to run the upgrade again- any advice or insights are greatly appreciated- let me know if you need more info about my setup-

Christopher
Average of ratings: -
In reply to Christopher Phillips

Re: Missing MySQL.sock file

by Christopher Phillips -
I'm still trying to figure this one out and thought I would pass on a little information that might give anyone some insight-
My course is run on a virtual private server (VPS) (http://www.westhost.com/vps.html) on an Apache server, with PHP 4.3.0 and MySQL 3.23.43. I am working on Mac OS X. I did a search on mysql.sock on the Moodle forums and found these threads having to do with mysql.sock:
http://moodle.org/mod/forum/discuss.php?d=5361
http://moodle.org/mod/forum/discuss.php?d=1062

but didn't find anything having to do with the file actually being deleted- in fact, I'm not finding anything anywhere on what might cause this to be deleted. I'm wondering if this might have something to do with the unique VPS technology that my host uses or if it was just some kind of fluke accident- does anyone have any insight into what the problem might be? If not, I'll keep looking and maybe just try again later this evening- I'll keep anyone who might be reading this posted on my progress- thanks!

Christopher

(is there any other info I could pass on that would be helpful to anyone?)
Average of ratings: -
In reply to Christopher Phillips

Re: Missing MySQL.sock file

by Gunther Dippe -
Have you searched http://www.mysql.com/ for possible reasons what might cause it to be deleted?
Average of ratings: -
In reply to Gunther Dippe

Re: Missing MySQL.sock file

by Christopher Phillips -
I have been to mysql.com and have learned a lot about mysql.sock, but haven't figured out why it was deleted. I have a couple of posts in at other forums to see if anyone else has any ideas- if not then I guess I'll just try again- maybe it was just a freak accident?!
Average of ratings: -
In reply to Christopher Phillips

Re: Missing MySQL.sock file

by Christopher Phillips -
I just tried running the upgrade again and everything went flawless- there must have been something happening with my server when I did it earlier- Thanks!
Average of ratings: -