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

Arthur,
----- Original Message ----- 
From: "Arthur H Wakida" <[email protected]>
To: "Mike Blezien" <[email protected]>; <[email protected]>
Sent: Wednesday, May 03, 2006 3:51 PM
Subject: 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

is the entire mysql folder and database folders owned by 'mysql.mysql' ??

Mike


>> 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]
>
> 


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