Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 21:53:12 von Hal Vaughan

I'm using Mandrake Linux 8.2 (upgraded the RPMs to 9.0). It originally h=
ad=20
MySQL 3.23 and I had no trouble using it from Perl.

Last night I upgraded to MySQL 4.0.x. It wasn't a straight upgrade -- I=20
basically copied the old files to backup directories and installed 4.0.x =
new.

Now whenever I try to access MySQL from Perl (using the DBI interface), I=
get=20
this error:

DBI connect('database=3Dlopas','hal',...) failed: Can't connect to local =
MySQL=20
server through socket '/var/lib/mysql/mysql.sock' (2) at test.pl line 11
Can't connect

There is no socket file (mysql.sock) in the /var/lib/mysql directory (thi=
s is=20
the MySQL data dir on this system). (I can't find one in the backup=20
directory either, but it is possible I outsmarted myself and somehow dele=
ted=20
it.)

I searched mysql.com and found a few things similar to my situation. One=
is=20
to check on the socket with this command line:

mysqladmin --protocol=3Dsocket --socket=3D/tmp/mysql.sock version

which I did, and got this error:

mysqladmin: ERROR: unknown variable 'protocol=3Dsocket'

So why am I getting this error for something mysql.com is telling me to d=
o (I=20
notice when I do mysqladmin --help, --protocol is no mentioned at all)?

And, most important, how do I get Perl working with MySQL again?

Thanks for any help or suggestions (or even a URL for the M to RTF!)

Hal

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2100@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 22:26:13 von Greg Meckes

It sounds like MySql isn't running. Did you start it after you installed it?

--- Hal Vaughan wrote:
> I'm using Mandrake Linux 8.2 (upgraded the RPMs to 9.0). It originally had
> MySQL 3.23 and I had no trouble using it from Perl.
>
> Last night I upgraded to MySQL 4.0.x. It wasn't a straight upgrade -- I
> basically copied the old files to backup directories and installed 4.0.x new.
>
> Now whenever I try to access MySQL from Perl (using the DBI interface), I get
> this error:
>
> DBI connect('database=lopas','hal',...) failed: Can't connect to local MySQL
> server through socket '/var/lib/mysql/mysql.sock' (2) at test.pl line 11
> Can't connect
>
> There is no socket file (mysql.sock) in the /var/lib/mysql directory (this is
> the MySQL data dir on this system). (I can't find one in the backup
> directory either, but it is possible I outsmarted myself and somehow deleted
> it.)
>
> I searched mysql.com and found a few things similar to my situation. One is
> to check on the socket with this command line:
>
> mysqladmin --protocol=socket --socket=/tmp/mysql.sock version
>
> which I did, and got this error:
>
> mysqladmin: ERROR: unknown variable 'protocol=socket'
>
> So why am I getting this error for something mysql.com is telling me to do (I
> notice when I do mysqladmin --help, --protocol is no mentioned at all)?
>
> And, most important, how do I get Perl working with MySQL again?
>
> Thanks for any help or suggestions (or even a URL for the M to RTF!)
>
> Hal
>
> ------------------------------------------------------------ ---------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail msql-mysql-modules-thread2100@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.
>

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2101@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 22:26:13 von Greg Meckes

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 22:39:56 von Christian Hammers

On Wed, Mar 19, 2003 at 01:26:13PM -0800, Greg Meckes wrote:
> It sounds like MySql isn't running. Did you start it after you installed it?

> > mysqladmin --protocol=socket --socket=/tmp/mysql.sock version
> > which I did, and got this error:
> > mysqladmin: ERROR: unknown variable 'protocol=socket'

It's not supported in at least 3.23. Let the "--protocol=socket" away.

bye,

-christian-

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2102@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 22:39:56 von Christian Hammers

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 23:05:49 von Hal Vaughan

On Wednesday 19 March 2003 04:39 pm, Christian Hammers wrote:
> On Wed, Mar 19, 2003 at 01:26:13PM -0800, Greg Meckes wrote:
> > It sounds like MySql isn't running. Did you start it after you instal=
led
> > it?

Yep. Works fine from the console

> > > mysqladmin --protocol=3Dsocket --socket=3D/tmp/mysql.sock version
> > > which I did, and got this error:
> > > mysqladmin: ERROR: unknown variable 'protocol=3Dsocket'
>
> It's not supported in at least 3.23. Let the "--protocol=3Dsocket" away=

I'm not using 3.23 anymore. I'm using 4.0 and getting the same error.

> bye,
>
> -christian-
>
>
> ------------------------------------------------------------ ---------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" befo=
re
> posting. To request this thread, e-mail
> msql-mysql-modules-thread2102@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2104@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 19.03.2003 23:05:49 von Hal Vaughan

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 20.03.2003 08:04:48 von Jochen Wiedmann

Zitiere Hal Vaughan :

> DBI connect('database=lopas','hal',...) failed: Can't connect to local
> MySQL
> server through socket '/var/lib/mysql/mysql.sock' (2) at test.pl line
> 11
> Can't connect

Recompile the driver with the new client libraries. The
new path of the mysql.sock file will be inherited automatically.

Alternatively, use the DSN option mysql_socket.

Jochen

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2108@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)

am 20.03.2003 08:04:48 von Jochen Wiedmann