Gossamer Forum
Home : General : Databases and SQL :

MySQL annoying me again!

Quote Reply
MySQL annoying me again!
Argh..this is really annoying me now! For some reason, MySQL is working fine in WebMin, but as soon as I try and access it via PHP I get an error! However, with PHP (not perl for some reason Unsure) I get an error! See http://www.ace-installer.com/sell/send.php?id=24 for an example. It ONLY seems to be PHP having a problem!

Anyone seen this before? IS it a setting in PHP that I need to configure?

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL annoying me again! In reply to
Its one of the most common mysql errors...I guess you didn't look very hard into finding a solution before posting?

http://google.yahoo.com/...27&hc=0&hs=0
Quote Reply
Re: [Paul] MySQL annoying me again! In reply to
Paul..this is coming from me! The one who doesn't have a clue...remember? What exactly are you saying the problem is? Its not the fact that MySQL isn't running, cos it is, so what did you think it was? I can't see anything on those sites that tells me other wise (well, in a language I can understand Tongue)

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL annoying me again! In reply to
Find out where your current sock file is...

locate mysql.sock

...then symlink it to the one it is trying to find.

ls -s /whereever/mysql.sock /var/lib/mysql/mysql.sock

Also look in /etc/my.cnf to see where mysql is looking for the sock.

Its probably in /tmp

Last edited by:

Paul: Jul 1, 2002, 1:30 PM
Quote Reply
Re: [Paul] MySQL annoying me again! In reply to
Still got a problem. I ran the command;

sh-2.04$ ls -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
0 /tmp/mysql.sock 0 /var/lib/mysql/mysql.sock

But I'm still getting the error Unsure

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL annoying me again! In reply to
Try it the other way around I may have go it wrong.....put /var/lib... first and /tmp... second.

I assume you checked /tmp/mysql.sock existed?

Last edited by:

Paul: Jul 1, 2002, 3:15 PM
Quote Reply
Re: [Paul] MySQL annoying me again! In reply to
Nope..still not going Frown

[root@www /]# cd tmp
[root@www /tmp]# ls
lost+found mysql.sock tclx8.3 uscreens

That proves that the file exists in /tmp/. Are you sure its ls -s to link a file? I always thought 'ls' was to list the directory Unsure

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL annoying me again! In reply to
That was a typo, its ln not ls
Quote Reply
Re: [Paul] MySQL annoying me again! In reply to
Yup.I guessed that :o Either way, I now have a mysql.sock file in /tmp/ and /var/lib/mysql, but I'm still getting the error Frown

Any more ideas? Unsure

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] MySQL annoying me again! In reply to
So did you symlink it properly?....use the webmin file manager if you want to check it is a proper link.

You can't just copy the sock file to another location like it sounds like you did.

Last edited by:

Paul: Jul 2, 2002, 2:45 AM
Quote Reply
Re: [Paul] MySQL annoying me again! In reply to
Paul..your a genious! Smile I deleted the mysql.sock file from /var/lib/mysql, and then re-symlinked it...all working fine now :)

Thaks for your help :)

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!