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

You may also want to take a look at the following fixes for the  
SELinux policy:

https://rhn.redhat.com/errata/RHBA-2005-251.html (it lists what looks  
like your problem) and the update that supercedes it:
https://rhn.redhat.com/errata/RHBA-2006-0049.html

Good luck!

- marco

On May 3, 2006, at 2:47 PM, Vladimir V. Kolpakov wrote:

> 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" <ahwakida@xxxxxxxxxx>
> > > To: "Mike Blezien" <mickalo@xxxxxxxxxxxxxxx>; <perl@xxxxxxxxxxxxxxx>
> > > 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" <ahwakida@xxxxxxxxxx>
> > > > > To: <perl@xxxxxxxxxxxxxxx>
> > > > > 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/perl? 
> unsub=marco.wise@xxxxxxxxxxxx


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@xxxxxxxxxxx