can't connect

[Shelly]

(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

[Steve]

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

[Shelly]

"Steve" <Th*****@Aint.Valid> wrote in message
news:pa****************************@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

There are no MYSQL entries in php.ini. There are several mysql entries, but
none of those. The mysql_default_socket is empty, which should take it to
/var/lib/mysql -- which is where I found it.

Shelly

[Shelly]

"Shelly" <sh************@asap-consult.com> wrote in message
news:sp********************@comcast.com...

"Steve" <Th*****@Aint.Valid> wrote in message
news:pa****************************@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

[David Haynes]

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

I don't know if you've already checked this, but you mention changing
ownership and group but not permissions.

Your web server will be running as a certain user. For example, apache
runs as user 'nobody' unless you change it. Are your permissions open
enough to allow user nobody to use the socket file?

It should probably have full read/write/execute permissions for user,
group and world.

-david-

[sheldonlg]

Solution: The problem was in SELinux. It was too restrictive.