RE: [PHP] mysql.sock file location

2003-09-25 Thread Jay Blanchard
[snip] I meant mysql.sock, sorry. Does anyone know how to tell PHP to look in a different location for the mysql.lock file? It's currently looking in /tmp/ and that's wrong. [/snip] But MySQL is running? PHP AFAIK doesn't care where mysql.sock is, unless it is not the default. locate mysql.sock

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
-Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 9:06 AM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location [snip] I meant mysql.sock, sorry. Does anyone know how to tell PHP to look in a different location

RE: [PHP] mysql.sock file location

2003-09-25 Thread Jay Blanchard
[snip] Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/apache2/htdocs/dbtest.php on line 3 [/snip] Can we see your connection string? My bet would be permissions... -- PHP General Mailing List (http://www.php.net/) To

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
print 'Failure'; ? -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 9:44 AM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location [snip] Warning: mysql_connect(): Can't connect to local MySQL

RE: [PHP] mysql.sock file location

2003-09-25 Thread Didier McGillis
ohohohohohoo or you can delete that and restart mysql and it will recreate. i have seen that before and that worked. From: Jay Blanchard [EMAIL PROTECTED] To: Donald Tyler [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location Date: Thu, 25 Sep 2003 09:43:33 -0500

Re: [PHP] mysql.sock file location

2003-09-25 Thread Brad Pauly
Donald Tyler wrote: Yeah I thought so to. But I did a chmod 755 on the sock file and it didn't help. Here's the test script I am using: (Presume that's what you meant by connection string? ?PHP if($Connection = mysql_connect('localhost', '**', '**')) print

RE: [PHP] mysql.sock file location

2003-09-25 Thread Jay Blanchard
[snip] Here's the test script I am using: (Presume that's what you meant by connection string? ?PHP if($Connection = mysql_connect('localhost', '**', '**')) print 'Success!'; else print 'Failure'; ? [/snip] Let's get a hair more info,

RE: [PHP] mysql.sock file location

2003-09-25 Thread Didier McGillis
yes like the user and the password ** and ** arent working for me. ;) From: Jay Blanchard [EMAIL PROTECTED] To: Brad Pauly [EMAIL PROTECTED], Donald Tyler [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location Date: Thu, 25 Sep 2003 10:12:50 -0500 [snip

RE: [PHP] mysql.sock file location

2003-09-25 Thread Jay Blanchard
[snip] yes like the user and the password ** and ** arent working for me. ;) [/snip] Not to head way off topic, well, OTOH, yes I am... Didier, is that pronounced did-i-A or did-i-er, or am I way off base. I knew someone with the first iteration. -- PHP General Mailing List

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
Yes, I ping it and it says its alive. -Original Message- From: Brad Pauly [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:07 AM To: Donald Tyler Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql.sock file location Donald Tyler wrote: Yeah I thought so to. But I did a chmod

RE: [PHP] mysql.sock file location

2003-09-25 Thread Didier McGillis
d-d-a is the proper way to say it but I pretty much go by everything including 'Hey you!' From: Jay Blanchard [EMAIL PROTECTED] To: Didier McGillis [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location Date: Thu, 25 Sep 2003

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
:13 AM To: Brad Pauly; Donald Tyler Cc: [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location [snip] Here's the test script I am using: (Presume that's what you meant by connection string? ?PHP if($Connection = mysql_connect('localhost', '**', '**')) print

RE: [PHP] mysql.sock file location

2003-09-25 Thread Jay Blanchard
[snip] I wasn't worried about short code =0P I would have done this if I was: $Connection = mysql_connect('localhost','**','**') or die(mysql_error()); =0P [/snip] Cool, but do you get errors? -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
and everything (including ibdata1) is set to root:mysql 755 I am going to headbut the screen in a minute! -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:32 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location Yes, I ping

Re: [PHP] mysql.sock file location

2003-09-25 Thread Brad Pauly
Donald Tyler wrote: Yes, I ping it and it says its alive. I don't understand. What did you ping? How does that mean it is running? Getting a response from a ping does not mean MySQL is running. Did you try connecting with a MySQL client from the command line? Have you looked at the running

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
No not a network IP ping. A mysqladmin ping: Mysqladmin --user=root ping -Original Message- From: Brad Pauly [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:53 AM To: Donald Tyler Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql.sock file location Donald Tyler wrote: Yes

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
Don't know yet, I've managed to stop mysql from loading now! (See my previous mail) -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:40 AM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location [snip] I

RE: [PHP] mysql.sock file location

2003-09-25 Thread Donald Tyler
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:40 AM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: [PHP] mysql.sock file location [snip] I wasn't worried about short code =0P I would have done this if I was: $Connection = mysql_connect('localhost