Gossamer Forum
Home : Gossamer Threads Inc. : Discussion :

Post deleted by PaulWilson

Quote Reply
Post deleted by PaulWilson
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
Quote Reply
Re: MySQL In reply to
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. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
Hi,

Please read the post obove the one you just posted..(which I probably posted as you were writing that last post so you didnt see it).

The mysql.sock file doesnt exist basically. :(



Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
Using ps aux gives me a list of info like USER %CPU START TIME COMMAND...etc

Trying to shutdown the server/restarting/connectiong etc all give me the error.

Please could you just take a quick look....Im desperate... ;(



Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
Hmmmm.......

When I type mysqld, I get....

Table 'mysql.host' doesnt exist.

Is this messed up or what..

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
I actually just restarted the whole server a few mins ago.

I installed MySQL as a .pkg file from cobalt.com...it installs itself automatically.


...and yes...there is a process ID going from 0 - 1600

Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
OH THANKYOU Pugdog........I think that has worked....it created all the tables and told me to set a new root password.

THANKS.......

Yep.........Just had to restart mysqld but it is working now!











Paul Wilson. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
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


Quote Reply
Re: MySQL In reply to
(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. Shocked
(Dont blame me if I'm wrong!)
Quote Reply
Re: MySQL In reply to
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