|
|
Posted by Shelly on 10/01/78 11:37
"Shelly" <sheldonlg.news@asap-consult.com> wrote in message
news:spudncf2lpoHslPeRVn-hA@comcast.com...
>
> "Steve" <ThisOne@Aint.Valid> wrote in message
> news:pan.2006.01.18.08.22.51.691382@Aint.Valid...
>> On Tue, 17 Jan 2006 22:24:54 -0500, Shelly wrote:
>>
>>> (also posted to alt.php.sql and comp.databases.mysql)
>>>
>>> This is an old problem. I extensively researched the postings on the
>>> internet and have found no solution. So, perhaps someone here can help.
>>>
>>> The problem is that from my index.php file I get:
>>>
>>> Can't connect to local MySQL server through socket
>>> '/var/lib/mysql/mysql.sock'
>>>
>>> Now, when I do an ls -l '/var/lib/mysql/mysql.sock it shows that the
>>> daemon
>>> is running. It shows it there (size 0, as it should be). Furthermore,
>>> I
>>> can connect from command line and can do mysql commands. The mysql is
>>> on
>>> the same machine as the web server, so I use localhost as the host. php
>>> is
>>> running on the server as well. The ini file shows the default location
>>> of
>>> be empty, so it should default to the installation default of
>>> /var/lib/mysql/, and it does since it shows up with an ls.
>>>
>>> One post suggested changing ownership and group to mysql. I did that,
>>> but
>>> in reality that is how was originally anyhow.
>>>
>>> So, I am stumped. Are there any suggestions?
>>>
>>> Shelly
>>
>> What relevant entries do you have in php.ini? Dos it redefine the socket
>> to use?
>>
>> There are off my test server, which works fine...
>>
>> Client API version 4.1.14
>> MYSQL_MODULE_TYPE external
>> MYSQL_SOCKET /var/run/mysqld/mysqld.sock
>> MYSQL_INCLUDE -I/usr/include/mysql
>> MYSQL_LIBS -L/usr/lib -lmysqlclient
From phpinfo() I get:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
Navigation:
[Reply to this message]
|