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

Mike,

Yes, mysql:mysql plus just for the heck of it 'rwx' for all.

Arthur

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