[rt-users] Can't connect to local MySQL server through socket

[Scott McClelland]

Thank you, that worked.  I modified the /etc/my.cnf as follows, and
everything works fine.

[root at redhat03 admin]# cat /etc/my.cnf 
[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
You have new mail in /var/spool/mail/root
[root at redhat03 admin]# 


/*------------------------------------------
Scott McClelland, CNE, MCP
Network Administrator
Vortex Data Systems 
http://www.vortexdata.com
--------------------------------------------*/



> -----Original Message-----
> From: stephen at acgroup.ucsc.edu [mailto:stephen at acgroup.ucsc.edu]
> Sent: Tuesday, May 08, 2001 12:40 PM
> To: Scott McClelland
> Subject: Re: [rt-users] Can't connect to local MySQL server through
> socket
> 
> 
> 
> I have heard that the mysql.sock directive socket= does not
> always work as advertise.
> 
> Try setting it to point at the default /tmp/mysql.sock
> 
> 
> 
> On Tue, 8 May 2001, Scott McClelland wrote:
> 
> > I setup MySQL 3.23 from an rpm, and created a /etc/my.cnf 
> file with the
> > parameter for the mysql.sock file
> > socket=/var/lib/mysql/mysql.sock
> >
> > I am able to connect with mysqladmin, as described in the mysql
> > documentation,
> > http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
> > but rt is still trying to connect through  /tmp/mysql.sock.
> >
> > Here is the output:
> >
> > [root at redhat03 bin]# ./rtadmin queue -create admin
> > Mysql->connect(database=rt;host=localhost) failed: Can't 
> connect to local
> > MySQL server through socket '/tmp/mysql.sock' (111) at
> > /usr/local/rt/lib/rt/database.pm line 24
> > [connectdb] Database connect failed: Can't connect to local 
> MySQL server
> > through socket '/tmp/mysql.sock' (111)
> > [root at redhat03 bin]#
> >
> > Any idea why?
> >
>