For Programmers: Free Programming Magazines  


Home > Archive > PERL Beginners > July 2007 > installing DBD::mysql









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author installing DBD::mysql
Octavian Rasnita

2007-07-11, 7:59 am

Hi,

I am trying to install DBD::mysql and I see that it tries to connect to the
server using the socket
/var/lib/mysql/mysql.sock

This is because another version of MySQL was installed on the server, and I
have installed another one that uses the socket /tmp/mysql.sock.

What should I change if I want to use the socket /tmp/mysql.sock?
Where does DBD::mysql find the old socket path?

(I have a single my.cnf in /etc/ and it specifies the socket
/tmp/mysql.sock).

Thank you very much.

Octavian

Stephen Kratzer

2007-07-12, 9:58 pm

On Wednesday 11 July 2007 07:31:30 Octavian Rasnita wrote:
> Hi,
>
> I am trying to install DBD::mysql and I see that it tries to connect to the
> server using the socket
> /var/lib/mysql/mysql.sock
>
> This is because another version of MySQL was installed on the server, and I
> have installed another one that uses the socket /tmp/mysql.sock.
>
> What should I change if I want to use the socket /tmp/mysql.sock?
> Where does DBD::mysql find the old socket path?
>
> (I have a single my.cnf in /etc/ and it specifies the socket
> /tmp/mysql.sock).
>
> Thank you very much.
>
> Octavian


Try man DBD::mysql and search for mysql_socket.
usenet@DavidFilmer.com

2007-07-12, 9:59 pm

On Jul 11, 4:31 am, orasn...@gmail.com (Octavian Rasnita) wrote:

> I am trying to install DBD::mysql and I see that it tries to connect to the
> server using the socket /var/lib/mysql/mysql.sock
>
> This is because another version of MySQL was installed on the server, and I
> have installed another one that uses the socket /tmp/mysql.sock.
>
> What should I change if I want to use the socket /tmp/mysql.sock?


I had this same problem. Surely there is an elegant and correct way
to solve this problem, but I solved it by simply creating a symbolic
link /var/lib/mysql/mysql.sock -> /tmp/mysql.sock

It's a kludge, but it worked for me.

--
David Filmer (http://DavidFilmer.com)

usenet@DavidFilmer.com

2007-07-12, 9:59 pm

On Jul 11, 4:31 am, orasn...@gmail.com (Octavian Rasnita) wrote:

> I am trying to install DBD::mysql and I see that it tries to connect to the
> server using the socket /var/lib/mysql/mysql.sock
>
> This is because another version of MySQL was installed on the server, and I
> have installed another one that uses the socket /tmp/mysql.sock.
>
> What should I change if I want to use the socket /tmp/mysql.sock?


I had this same problem. Surely there is an elegant and correct way
to solve this problem, but I solved it by simply creating a symbolic
link /var/lib/mysql/mysql.sock -> /tmp/mysql.sock

It's a kludge, but it worked for me.

--
David Filmer (http://DavidFilmer.com)

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2009 codecomments.com