DBI and sockets

[Don Stefani]

I'm looking for a better way to fix my problem.

I'm using Perl, DBI, DBD::mysql,
I was getting this error...
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"

the default setting for looking for mysql.sock in either DBI or DBD is
/var/lib/mysql/mysql.sock
(at least on my install), yet the real location is /tmp/mysql.sock

I never had a problem until I tried a simple CGI program.

This fixed the problem by adding the mysql_socket attribute to my
connection...
$dbh =
DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"...

Do you know of a way to avoid adding this attribute to my connection string?

Thanks,

Don

[Don Stefani]

Don Stefani wrote:

I'm looking for a better way to fix my problem.

I'm using Perl, DBI, DBD::mysql,
I was getting this error...
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"

the default setting for looking for mysql.sock in either DBI or DBD is
/var/lib/mysql/mysql.sock
(at least on my install), yet the real location is /tmp/mysql.sock

I never had a problem until I tried a simple CGI program.

This fixed the problem by adding the mysql_socket attribute to my
connection...
$dbh =
DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"...
Do you know of a way to avoid adding this attribute to my connection
string?

Thanks,

Don

I also added a ln -s from /tmp/mysql.sock to /var/lib/mysql/

But I'd sure like to fix this the right way..
Thanks,

Don

[Don Stefani]

Don Stefani wrote:

I'm looking for a better way to fix my problem.

I'm using Perl, DBI, DBD::mysql,
I was getting this error...
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"

the default setting for looking for mysql.sock in either DBI or DBD is
/var/lib/mysql/mysql.sock
(at least on my install), yet the real location is /tmp/mysql.sock

I never had a problem until I tried a simple CGI program.

This fixed the problem by adding the mysql_socket attribute to my
connection...
$dbh =
DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"...
Do you know of a way to avoid adding this attribute to my connection
string?

Thanks,

Don

I also added a ln -s from /tmp/mysql.sock to /var/lib/mysql/

But I'd sure like to fix this the right way..
Thanks,

Don

[Don Stefani]

Don Stefani wrote:

Don Stefani wrote:

I'm looking for a better way to fix my problem.

I'm using Perl, DBI, DBD::mysql,
I was getting this error...
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"

the default setting for looking for mysql.sock in either DBI or DBD is
/var/lib/mysql/mysql.sock
(at least on my install), yet the real location is /tmp/mysql.sock

I never had a problem until I tried a simple CGI program.

This fixed the problem by adding the mysql_socket attribute to my
connection...
$dbh =
DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"...
Do you know of a way to avoid adding this attribute to my connection
string?

Thanks,

Don

I also added a ln -s from /tmp/mysql.sock to /var/lib/mysql/

But I'd sure like to fix this the right way..
Thanks,

Don

OK, so I'm answering all of my own posts, sorry.

I reinstalled both DBI and DBD::mysql by hand.
I think I had used Yast (suse9) to install DBD originally.

After removing the sym-link everything works fine.
I guess I'll avoid the packages when it comes to Perl and MySQL.

Thanks, I hope this helps someone else.

Don

[Don Stefani]

Don Stefani wrote:

Don Stefani wrote:

I'm looking for a better way to fix my problem.

I'm using Perl, DBI, DBD::mysql,
I was getting this error...
"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"

the default setting for looking for mysql.sock in either DBI or DBD is
/var/lib/mysql/mysql.sock
(at least on my install), yet the real location is /tmp/mysql.sock

I never had a problem until I tried a simple CGI program.

This fixed the problem by adding the mysql_socket attribute to my
connection...
$dbh =
DBI->connect("DBI:mysql:host=localhost:mysql_socket=/tmp/mysql.sock;database=business"...
Do you know of a way to avoid adding this attribute to my connection
string?

Thanks,

Don

I also added a ln -s from /tmp/mysql.sock to /var/lib/mysql/

But I'd sure like to fix this the right way..
Thanks,

Don

OK, so I'm answering all of my own posts, sorry.

I reinstalled both DBI and DBD::mysql by hand.
I think I had used Yast (suse9) to install DBD originally.

After removing the sym-link everything works fine.
I guess I'll avoid the packages when it comes to Perl and MySQL.

Thanks, I hope this helps someone else.

Don