Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Mike,

Thank you very much for your quick response.
Unfortunately, mysql.sock is owned by mysql and on top of that I have
it opened for all (rwx).  One more info, in messages log I see following
error : ... denied {connectto } for pid=7678 exe=/usr/bin/perl 
path=/var/lib/mysql/mysql.sock
              scontext=root:system_r:httpd_sys_script_t 
tcontext=root:system_r:unconfied_t tclass=
              unix_stream_socket
My data directory and /var/lib/mysql/mysql.sock is both owned by mysql. 
Firewall is completely
disabled (lokkit). I don't know what else maybe blocking this connection.

Arthur

> Arthur,
>
> the Error 13 means Permission Denied. check the ownership of the sock 
> file, is should be owned by the "mysql" user if owned by 'root', then this 
> maybe causing your problems.
>
> Mike
> ----- Original Message ----- 
> From: "Arthur H Wakida" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, May 03, 2006 2:29 PM
> Subject: Can't connect to local MySQL server through socket 
> '/var/lib/mysql/mysql.sock' (13)
>
>
> OS RH Enterprise V4 (kernel 2.5.9-5.EL), Perl 5.8.5, DBI-1.46, 
> DBD-MySQL-2.9004-3.1, MySQL 4.1.7 installed
>
> I can access/update MySQL db via webmin (port 10000) and SQLyog (port 
> 3306) without any problem.
>
> When I try to connect to MySQL db via ;
>     my $hndl = DBI->connect("DBI:mysql:$database", $user, $password) or 
> db_err("Unable to contect to $database", $DBI::errstr);
>
> I get the following message : "Can't connect to local MySQL server through 
> socket '/var/lib/mysql/mysql.sock' (13)"
>
> Socket in question does exist in /var/lib/mysql and all directories 
> involved is completely open (777).  I've other servers up
> and running without any problem (albeit different versions).  Did I miss 
> something?  Any help/ideas is greatly appreciated!
>
>
> -- 
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/[email protected] 


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]