Jan 20, 2001, 10:38 AM
Veteran (6956 posts)
Jan 20, 2001, 10:38 AM
Post #2 of 17
Views: 9091
It usually means the server needs to be restarted.
In the case of Raq's that may not be the 'default' location. Check... this has been discussed in one of the LSQL forums before.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
In the case of Raq's that may not be the 'default' location. Check... this has been discussed in one of the LSQL forums before.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 10:46 AM
Veteran (19537 posts)
Jan 20, 2001, 10:46 AM
Post #4 of 17
Views: 9074
OK when I try to shutdown the server I get....
connect to server at 'localhost' failed.
error: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111)
Check that mysqld is running and that /var/lib/mysql/mysql.sock exists.
This "/var/lib/mysql/mysql.sock " doesnt exist.....I wish to remove MySQL and start again...how do I do that.
rmdir wont work.
Paul Wilson.
(Dont blame me if I'm wrong!)
connect to server at 'localhost' failed.
error: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111)
Check that mysqld is running and that /var/lib/mysql/mysql.sock exists.
This "/var/lib/mysql/mysql.sock " doesnt exist.....I wish to remove MySQL and start again...how do I do that.
rmdir wont work.
Paul Wilson.
(Dont blame me if I'm wrong!)
Jan 20, 2001, 10:51 AM
Veteran (6956 posts)
Jan 20, 2001, 10:51 AM
Post #5 of 17
Views: 9080
That MySQL error message is probably where it thinks the tmp file should be on a Raq. That sounds pretty familiar.
You might need to 'kill' the server. Without the socket file, you can't connect to the server. I don't know why this happens, but it does. In general, I think the fix has been to just stop/restart MySQL and it fixes itself.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
You might need to 'kill' the server. Without the socket file, you can't connect to the server. I don't know why this happens, but it does. In general, I think the fix has been to just stop/restart MySQL and it fixes itself.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 10:59 AM
Veteran (6956 posts)
Jan 20, 2001, 10:59 AM
Post #7 of 17
Views: 9136
The mysql.sock file is created each time the server is started. It's similar to the pid file that many programs use. The pid file keeps track of the process ID, while the sock file keeps track of the socket connects.
The error shows the server may not be running. if a ps aux or ps -ef shows the server running, you'll need to 'kill' the server. Once it's killed, just restart it, and 90% chance thing swill work. If the server is not running, just restart it with the safemysqld command.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
The error shows the server may not be running. if a ps aux or ps -ef shows the server running, you'll need to 'kill' the server. Once it's killed, just restart it, and 90% chance thing swill work. If the server is not running, just restart it with the safemysqld command.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 11:13 AM
Veteran (6956 posts)
Jan 20, 2001, 11:13 AM
Post #11 of 17
Views: 9046
Paul,
With the ps aux command, do you see a process ID running with "mysqld" in it? If no process is running mysql, then the server isn't running.
You _cant_ shut down the server if you can't connect. You have to _KILL_ it as root or the mysql user. If you can't _KILL_ you'll have to reboot your whole physical server. That should restart it.
Ok... the mysql.host file. Did you run the start up script after installing MySQl to set up the default tables?? There is full step by step on how to do this in the mysql docs on the mysql.com site.
I think there is also a caveats section on setting up on a raq.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
With the ps aux command, do you see a process ID running with "mysqld" in it? If no process is running mysql, then the server isn't running.
You _cant_ shut down the server if you can't connect. You have to _KILL_ it as root or the mysql user. If you can't _KILL_ you'll have to reboot your whole physical server. That should restart it.
Ok... the mysql.host file. Did you run the start up script after installing MySQl to set up the default tables?? There is full step by step on how to do this in the mysql docs on the mysql.com site.
I think there is also a caveats section on setting up on a raq.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 11:20 AM
Veteran (6956 posts)
Jan 20, 2001, 11:20 AM
Post #13 of 17
Views: 9062
Well, then you need to run the "mysql_install_db" script. It's in the scripts directory of my version, it might be somewhere else on yours. it's a shell script, so it should just run.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 11:28 AM
Veteran (6956 posts)
Jan 20, 2001, 11:28 AM
Post #15 of 17
Views: 9063
Any time you add a user, change a database permission, or anything... restart the server!! Unless you use the 'grant' command from within the mysql interpreter, you _must_ restart the server, or the permissions won't take effect. It's a source of endless frustration :) Just remember, when in doubt, restart.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
Jan 20, 2001, 11:34 AM
Veteran (19537 posts)
Jan 20, 2001, 11:34 AM
Post #16 of 17
Views: 9078
(When you can)....lol
Phew....that got me tense....
Another problem.......
Im using phpMyAdmin and there is an error on the main page saying that magic_quotes needs to be enabled in php.ini for phpMyAdmin to work properly.
So I went into php.ini using pico and changed magic_quotes_gpc = No .....to Yes....but I still get the error.
Do I need to do something else?
Paul Wilson.
(Dont blame me if I'm wrong!)
Phew....that got me tense....
Another problem.......
Im using phpMyAdmin and there is an error on the main page saying that magic_quotes needs to be enabled in php.ini for phpMyAdmin to work properly.
So I went into php.ini using pico and changed magic_quotes_gpc = No .....to Yes....but I still get the error.
Do I need to do something else?
Paul Wilson.
(Dont blame me if I'm wrong!)
Jan 20, 2001, 11:40 AM
Veteran (6956 posts)
Jan 20, 2001, 11:40 AM
Post #17 of 17
Views: 9062
You have to check on their site. If you are running mod_php, you'll probably have to re-compile it. I never did figure it out, so I just switched to using MySQLMan, and except for the 'restart' button, which is now in Webmin, I like MySQLMan much better.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ