Gossamer Forum: General: Databases and SQL: MySQL annoying me again!

Jul 1, 2002, 12:51 PM

Andy

Veteran / Moderator (17297 posts)

Jul 1, 2002, 12:51 PM

Post #1 of 11

Shortcut

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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jul 1, 2002, 12:59 PM

Paul

Veteran (19537 posts)

Jul 1, 2002, 12:59 PM

Post #2 of 11

Shortcut

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

Jul 1, 2002, 1:09 PM

Andy

Veteran / Moderator (17297 posts)

Jul 1, 2002, 1:09 PM

Post #3 of 11

Shortcut

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

Jul 1, 2002, 1:29 PM

Paul

Veteran (19537 posts)

Jul 1, 2002, 1:29 PM

Post #4 of 11

Shortcut

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

Jul 1, 2002, 2:01 PM

Andy

Veteran / Moderator (17297 posts)

Jul 1, 2002, 2:01 PM

Post #5 of 11

Shortcut

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

Jul 1, 2002, 3:14 PM

Paul

Veteran (19537 posts)

Jul 1, 2002, 3:14 PM

Post #6 of 11

Shortcut

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

Jul 2, 2002, 2:24 AM

Andy

Veteran / Moderator (17297 posts)

Jul 2, 2002, 2:24 AM

Post #7 of 11

Shortcut

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

Jul 2, 2002, 2:33 AM

Paul

Veteran (19537 posts)

Jul 2, 2002, 2:33 AM

Post #8 of 11

Shortcut

Re: [Andy] MySQL annoying me again! In reply to

That was a typo, its ln not ls

Jul 2, 2002, 2:42 AM

Andy

Veteran / Moderator (17297 posts)

Jul 2, 2002, 2:42 AM

Post #9 of 11

Shortcut

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

Jul 2, 2002, 2:45 AM

Paul

Veteran (19537 posts)

Jul 2, 2002, 2:45 AM

Post #10 of 11

Shortcut

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

Jul 2, 2002, 2:54 AM

Andy

Veteran / Moderator (17297 posts)

Jul 2, 2002, 2:54 AM

Post #11 of 11

Shortcut

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