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

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=ahwakida@xxxxxxxxxx
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/perl?unsub=mickalo@xxxxxxxxxxxxxxx


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