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

Valdimir!,

That's it!  Thank you all soooo much!
Mike, Vladamir, Marco your efforts just saved my
sanity (of what I have remaining)!  Thanks again.

Arthur

----- Original Message ----- 
From: "Vladimir V. Kolpakov" <[email protected]>
To: <[email protected]>
Sent: Wednesday, May 03, 2006 2:47 PM
Subject: Re: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (13)


> Arthur, --
>
> Could disabled SELinux work for you?
>  (/usr/sbin/setenforce Permissive)
>
> Details:
>  http://bugs.mysql.com/bug.php?id=12676
>
> --w
>
>
> On Wed, May 03, 2006 at 02:15:38PM -0700, Arthur H Wakida wrote:
>> 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]