Posted by Martin Norland on 02/08/05 21:19

My intention of setting the reply-to was not to offend, or claim you
were wrong - merely to move the discussion to the list I felt (and still
feel - as I've done it again) is most appropriate for the question.

anyway, back to the task at hand

( first: I'm assuming you restarted apache after changing your php.ini -
otherwise, that's your problem. )

Whatever the case, the error message clearly shows that it is not
reading the value, however it's set - because the error is still showing
a blank string for the socket. If it were a permissions problem with
the socket, you wouldn't be getting that exact error - at the very
least, it would still show the correct socket path. More likely, it
would also error with a "cannot open socket" or equivalent.

You may wish to examine ini_get(), ini_get_all(), phpinfo(), or
php_ini_scanned_files(), to verify if it is set, or to see if it's being
overwritten somewhere.

Cheers,

Denis Gerasimov wrote:
> Didn't help me. MySQL socket does exist - /var/lib/mysql/mysql.sock (default
> location).
> mysqli.default_socket is NOT set to null but to this value (manually, as you
> advised)
>
> Again,
>
> 1. Connection to localhost still fails with message "Can't connect to local
> MySQL server through socket '' (111)"
>
> 2. Connection to server's domain name fails too (!) with message "Access
> denied for user 'user'@'example.com' (using password: YES)"
>
> 3. Connection to localhost through mysql shows the following config
>
> mysql> status
> --------------
> mysql Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686)
>
> Connection id: 42
> Current database:
> Current user: root@localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Using delimiter: ;
> Server version: 4.1.9-standard
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: latin1
> Client characterset: latin1
> Conn. characterset: latin1
> UNIX socket: /var/lib/mysql/mysql.sock
> Uptime: 1 day 3 hours 1 min 7 sec
>
> Threads: 3 Questions: 272 Slow queries: 0 Opens: 64 Flush tables: 1
> Open tables: 26 Queries per second avg: 0.003
> --------------
>
> Seems to be a security issue... Any more ideas about these symptoms?
>
>
>>-----
>>I can't see any reason why you wouldn't be able to use the same socket -
>>you're connecting to the same exact server, it's just a path. You
>>should be perfectly able to set your mysqli.default_socket to the same
>>as the mysql.default_socket. I can't tell you what the default for your
>>system is, but there are php functions to get configuration options, if
>>you don't have it in any obvious places.
>>
>>Cheers,
>>--
>>- Martin Norland, Database / Web Developer, International Outreach x3257
>>The opinion(s) contained within this email do not necessarily represent
>>those of St. Jude Children's Research Hospital.
>>
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>>http://lists.mysql.com/mysql?unsub=denis.gerasimov@vekos.ru
>
>


--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.

[Back to original message]