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