[rt-users] Re: can't connect to mysql.sock?

[Drew Mooney]

Moses,

You were probably right. Unforturnately I took a heavy-handed approach
to fixing the problem BEFORE I read your reply. I was leaning towards a
permissions thing - and after reading your reply, found that
/usr/local/mysql/var was set to drwx------. 

Even with /urs/local/mysql/var/mysql.sock set to srwxrwxrwx, the parent
directory probably locked out the apache-DBI user's attempts to connect.

Thanks for your reply - The webUI is fine now - I'm just getting around
to playing with solaris 8 sendmail and wishing I was still running RT on
SuSE linux... :-)

regards,

Drew

Moses Leslie wrote:
> 
> Hi,
> 
> marmoset at chupacabra:~$ perror 13
> Error code  13:  Permission denied
> marmoset at chupacabra:~$
> 
> Probably means that whatever UID the webserver is running as doesn't have
> permission to write to the mysql.sock file (or perhaps the directory).
> 
> Moses
> 
> On Fri, 6 Sep 2002,  Drew Mooney wrote:
> 
> > Further to this - I AM able to connect to mysql via the command line as user
> > 'rtadm' [the rt user and group name at my site]. Which 'user' is trying to
> > connect to mysql via the apache DBI?
> >
> > On Fri, 06 Sep 2002 11:52:36 -0700 dmmooney at earthlink.net wrote:
> >
> > Apache & Mysql both _appear_ to be running fine.
> >
> >
> >
> > However, whenever I attempt to connect to the webui, I get this message:
> >
> >
> >
> > DBI->connect(dbname=rt2;host=localhost) failed: Can't connect to local MySQL
> > server through socket '/usr/local/mysql/var/mysql.sock'
> >
> >  (13) at /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
> > line 117
> >
> > [Fri Sep  6 13:36:32 2002] [error] Connect Failed Can't connect to local MySQL
> > server through socket '/usr/local/mysql/var/mysql.soc
> >
> > k' (13)
> >
> >  at /opt/rt/rt2/lib/RT.pm line 27
> >
> >
> >
> > [sorry if this comes in a bit scrambled - I'm on a webmail interface and it
> > looks ugly]
> >
> >
> >
> > Any ideas? If more input [config files, file permissions, etc.] needed, please
> > let me know!
> >
> >
> >
> > Best regards,
> >
> >
> >
> > Drew M. Mooney
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
> > Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> >