Re: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 01:22:50 von Rudy Lippan

On Wed, 18 May 2005, Trevor Price wrote:

> When I try to connect to a 5.0 server with perl I get
>
> DBI connect(...) failed: Client does not support authentication protocol
> requested by server; consider upgrading MySQL client at ./test_db.pl
> line 7

Recompile DBD::mysql against the new client libraries, and make sure that
Makefile.PL is picking up the correct libraries, specifing --libs & friends if
you have to.

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 01:32:59 von Trevor Price

------_=_NextPart_001_01C55C01.ED01559C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

All,

On redhat es 3.0 taroon update 2

RPMS

MySQL-shared-compat-5.0.4-0
MySQL-server-4.0.21-0
MySQL-client-5.0.4-0
php-mysql-4.3.2-11.1.ent
MySQL-Max-4.0.21-0
MySQL-devel-4.0.21-0

Along with

Perl DBI 1.41
Perl DBD 2.9007

When I try to connect to a 5.0 server with perl I get=0D

DBI connect(...) failed: Client does not support authentication protocol
requested by server; consider upgrading MySQL client at ./test_db.pl
line 7

Which is strange because my mysql client can connect to the 5.0 server.
I reinstalled DBD after upgrading the client and shared-compat rpms.
Any ideas?

Thanks,

Trevor

Trevor Price | Production Operations Manager
DemandTec, Inc. | 1 Circle Star Way, Suite 200 | San Carlos, CA 94070
tel | +1.650.226.4805 fax | +1.650.556.1190 =0D
www.demandtec.com

=3D"font-size:8.0pt;font-family:Arial">--------------------- ---------------=
------------------------------------------------------------ ---------------=
------------------------------
DEMANDTEC EMAIL=
NOTICE:

NOTICE: This email=
transmission and all attached files contain information intended for the=
designated individual or entity to whom it is addressed and may contain=
information that is proprietary, privileged and/or exempt from disclosure=
under applicable law. If you are not the intended recipient or an=
employee or agent responsible for delivering this message to the intended=
recipient, you are hereby notified that any dissemination, distribution,=
copying, or other use of this email or its attachments is strictly=
prohibited. If you have received this email in error, please notify the=
sender immediately by replying to this message and please delete the=
original message without making any copies.

WARNING: Computer=
viruses can be transmitted via email. The recipient should check this=
email and any attachments for the presence of viruses. Although we have=
taken reasonable precautions to ensure that this email and all attachments=
are free from viruses, we accept no liability for any loss or damage=
arising from the use of this email or its attachments.

------_=_NextPart_001_01C55C01.ED01559C--

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 06:20:28 von Trevor Price

That is the best free service I have ever received. Thanks for the quick
reply. However I have the same problem. I tried

perl Makefile.PL --libs=3D"-L/usr/lib -L/usr/lib/mysql -lmysqlclient_r
-lpthread -lz -lcrypt -lnsl -lm -lpthread -lc -lnss_files -lnss_dns
-lresolv -lc -lnss_files -lnss_dns -lresolv"

The only change from mysql_config is -L/usr/lib which is where the
libmysqlclient.so's are, however isn't /usr/lib default? I also tried
without -L/usr/lib/mysql and without -lmysqlclient_r

All of these different combinations cause many failures in make test.

Is the problem DBD is choosing libmysqlclient.so.10 instead of
libmysqlclient.so.14 ? I thought the DBD driver actually chooses whether
to use libmysqlclient.so.10,12,14 depending upon the server it connects
to. Is their a way for me to specify explicitly the library to use?

In earnest,

Trevor=0D

-----Original Message-----
From: Rudy Lippan [mailto:rlippan@remotelinux.com]=0D
Sent: Wednesday, May 18, 2005 4:23 PM
To: Trevor Price
Cc: perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

On Wed, 18 May 2005, Trevor Price wrote:

> When I try to connect to a 5.0 server with perl I get
>=0D
> DBI connect(...) failed: Client does not support authentication
protocol
> requested by server; consider upgrading MySQL client at ./test_db.pl
> line 7

Recompile DBD::mysql against the new client libraries, and make sure
that=0D
Makefile.PL is picking up the correct libraries, specifing --libs &
friends if=0D
you have to.

Rudy

=3D"font-size:8.0pt;font-family:Arial">--------------------- ---------------=
------------------------------------------------------------ ---------------=
------------------------------
DEMANDTEC EMAIL=
NOTICE:

Re: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 06:30:55 von pgollucci

Trevor Price wrote:
> That is the best free service I have ever received. Thanks for the quick
> reply. However I have the same problem. I tried
>
> perl Makefile.PL --libs="-L/usr/lib -L/usr/lib/mysql -lmysqlclient_r
> -lpthread -lz -lcrypt -lnsl -lm -lpthread -lc -lnss_files -lnss_dns
> -lresolv -lc -lnss_files -lnss_dns -lresolv"
>
> The only change from mysql_config is -L/usr/lib which is where the
> libmysqlclient.so's are, however isn't /usr/lib default? I also tried
> without -L/usr/lib/mysql and without -lmysqlclient_r
>
> All of these different combinations cause many failures in make test.
>
> Is the problem DBD is choosing libmysqlclient.so.10 instead of
> libmysqlclient.so.14 ? I thought the DBD driver actually chooses whether
> to use libmysqlclient.so.10,12,14 depending upon the server it connects
> to. Is their a way for me to specify explicitly the library to use?
>
> In earnest,
>
> Trevor
DBD does not choose the library in run time :)

If both libraries are in your -L paths which ever one it finds first
will be used.

You might try temporarily renaming/moving the ones you don't want out of
the way while you compile.

END
------------------------------------------------------------ ---------------
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 06:45:34 von Trevor Price

Thanks Phillip,

I just deleted /usr/lib/libmysql*so.10* and /usr/lib/libmysql*so.12*

This leaves only so.14 and the libmysqlclient.so,libmysqlclient_r.so
which are a soft links to libmysqlclient.so.14

However, this did not work after recompiling DBD and reinstalling.
Which I find confusing, unless it is using the libs in /usr/lib/mysql?
Keep the ideas coming. I am ready to try them.

Trevor

-----Original Message-----
From: Philip M. Golllucci [mailto:pgollucci@p6m7g8.com]=0D
Sent: Wednesday, May 18, 2005 9:31 PM
To: Trevor Price
Cc: Rudy Lippan; perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

Trevor Price wrote:
> That is the best free service I have ever received. Thanks for the
quick
> reply. However I have the same problem. I tried
>=0D
> perl Makefile.PL --libs=3D"-L/usr/lib -L/usr/lib/mysql -lmysqlclient_r
> -lpthread -lz -lcrypt -lnsl -lm -lpthread -lc -lnss_files -lnss_dns
> -lresolv -lc -lnss_files -lnss_dns -lresolv"
>=0D
> The only change from mysql_config is -L/usr/lib which is where the
> libmysqlclient.so's are, however isn't /usr/lib default? I also tried
> without -L/usr/lib/mysql and without -lmysqlclient_r
>=0D
> All of these different combinations cause many failures in make test.
>=0D
> Is the problem DBD is choosing libmysqlclient.so.10 instead of
> libmysqlclient.so.14 ? I thought the DBD driver actually chooses
whether
> to use libmysqlclient.so.10,12,14 depending upon the server it
connects
> to. Is their a way for me to specify explicitly the library to use?
>=0D
> In earnest,
>=0D
> Trevor
DBD does not choose the library in run time :)

If both libraries are in your -L paths which ever one it finds first=0D
will be used.

You might try temporarily renaming/moving the ones you don't want out of

the way while you compile.

END
------------------------------------------------------------ ------------
---
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

=3D"font-size:8.0pt;font-family:Arial">--------------------- ---------------=
------------------------------------------------------------ ---------------=
------------------------------
DEMANDTEC EMAIL=
NOTICE:

Re: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 07:03:23 von pgollucci

Trevor Price wrote:
> Thanks Phillip,
>
>
> I just deleted /usr/lib/libmysql*so.10* and /usr/lib/libmysql*so.12*
>
> This leaves only so.14 and the libmysqlclient.so,libmysqlclient_r.so
> which are a soft links to libmysqlclient.so.14
>
> However, this did not work after recompiling DBD and reinstalling.
> Which I find confusing, unless it is using the libs in /usr/lib/mysql?
> Keep the ideas coming. I am ready to try them.
most likely its using /usr/lib/mysql

I might have missed this in the start of the thread, but can you paste
the first 10 lines or so of the errors.

also a

find /usr/lib -type f -name "*mysql*"

--
END
------------------------------------------------------------ ---------------
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 07:07:59 von Trevor Price

I don't see any other .so's. Do I need to remove current DBD
installation before compiling next DBD?

[tprice@thumper tprice]$ find /usr/lib -type f -name "*mysql*"
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/my
sql.so
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/my
sql.bs
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/Bundl e/DBD/mysql.
pm
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/m ysql.pm
/usr/lib/mysql/mysqld-max.sym
/usr/lib/mysql/mysqld.sym
/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.la
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.la
/usr/lib/php4/mysql.so
/usr/lib/nagios/plugins/check_mysql
/usr/lib/libmysqlclient.so.14.0.0
/usr/lib/libmysqlclient_r.so.14.0.0

-----Original Message-----
From: Philip M. Golllucci [mailto:pgollucci@p6m7g8.com]=0D
Sent: Wednesday, May 18, 2005 10:03 PM
To: Trevor Price
Cc: perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

Trevor Price wrote:
> Thanks Phillip,
>=0D
>=0D
> I just deleted /usr/lib/libmysql*so.10* and /usr/lib/libmysql*so.12*
>=0D
> This leaves only so.14 and the libmysqlclient.so,libmysqlclient_r.so
> which are a soft links to libmysqlclient.so.14
>=0D
> However, this did not work after recompiling DBD and reinstalling.
> Which I find confusing, unless it is using the libs in /usr/lib/mysql?
> Keep the ideas coming. I am ready to try them.
most likely its using /usr/lib/mysql

I might have missed this in the start of the thread, but can you paste=0D
the first 10 lines or so of the errors.

also a

find /usr/lib -type f -name "*mysql*"

--=0D
END
------------------------------------------------------------ ------------
---
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

=3D"font-size:8.0pt;font-family:Arial">--------------------- ---------------=
------------------------------------------------------------ ---------------=
------------------------------
DEMANDTEC EMAIL=
NOTICE:

Re: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 07:12:26 von pgollucci

Trevor Price wrote:
>
> I don't see any other .so's. Do I need to remove current DBD
> installation before compiling next DBD?
>
>
> [tprice@thumper tprice]$ find /usr/lib -type f -name "*mysql*"
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/my
> sql.so
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/ DBD/mysql/my
> sql.bs
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/Bundl e/DBD/mysql.
> pm
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/m ysql.pm
> /usr/lib/mysql/mysqld-max.sym
> /usr/lib/mysql/mysqld.sym
> /usr/lib/mysql/libmysqlclient.a
> /usr/lib/mysql/libmysqlclient.la
> /usr/lib/mysql/libmysqlclient_r.a
> /usr/lib/mysql/libmysqlclient_r.la
> /usr/lib/php4/mysql.so
> /usr/lib/nagios/plugins/check_mysql
> /usr/lib/libmysqlclient.so.14.0.0
> /usr/lib/libmysqlclient_r.so.14.0.0
>
Can you paste the actual error message again. Thanks for the output.

--
END
------------------------------------------------------------ ---------------
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 07:20:49 von pgollucci

Trevor Price wrote:
> I might have missed this in the start of the thread, but can you paste
> the first 10 lines or so of the errors.
Okay I looked back in the archives:

>>DBI connect(...) failed: Client does not support authentication
>>protocol requested by server; consider upgrading MySQL client at
>>./test_db.pl line 7

My next thought is try:

ldd mysql
ldd mysqld

make sure the libmysql match up accordingly.

--
END
------------------------------------------------------------ ---------------
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 07:48:24 von Trevor Price

And the saga continues...

mysql is not a dynamic binary, so says ldd

[tprice@thumper tprice]$ ldd /usr/sbin/mysqld-max
=0D
librt.so.1 =3D> /lib/tls/librt.so.1 (0xb75cf000)
libdl.so.2 =3D> /lib/libdl.so.2 (0xb75cc000)
libpthread.so.0 =3D> /lib/tls/libpthread.so.0 (0xb75bc000)
libz.so.1 =3D> /usr/lib/libz.so.1 (0xb75ae000)
libcrypt.so.1 =3D> /lib/libcrypt.so.1 (0xb7580000)
libnsl.so.1 =3D> /lib/libnsl.so.1 (0xb756b000)
libm.so.6 =3D> /lib/tls/libm.so.6 (0xb7549000)
libc.so.6 =3D> /lib/tls/libc.so.6 (0xb7411000)
libnss_files.so.2 =3D> /lib/libnss_files.so.2 (0xb7405000)
libnss_dns.so.2 =3D> /lib/libnss_dns.so.2 (0xb7400000)
libresolv.so.2 =3D> /lib/libresolv.so.2 (0xb73ed000)
/lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0xb75eb000)

no libmysqlclient mentioned.

-----Original Message-----
From: Philip M. Golllucci [mailto:pgollucci@p6m7g8.com]=0D
Sent: Wednesday, May 18, 2005 10:21 PM
To: Trevor Price
Cc: perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

Trevor Price wrote:
> I might have missed this in the start of the thread, but can you paste
> the first 10 lines or so of the errors.
Okay I looked back in the archives:

>>DBI connect(...) failed: Client does not support authentication=0D
>>protocol requested by server; consider upgrading MySQL client at=0D
>>./test_db.pl line 7

My next thought is try:

ldd mysql
ldd mysqld

make sure the libmysql match up accordingly.

--=0D
END
------------------------------------------------------------ ------------
---
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

=3D"font-size:8.0pt;font-family:Arial">--------------------- ---------------=
------------------------------------------------------------ ---------------=
------------------------------
DEMANDTEC EMAIL=
NOTICE:

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 08:11:49 von david.logan

Hi Trevor,

I think your problem may be the version of the mysql client library. You
mentioned your rpm version was 4.0.21. Please note the libmysqlclient.so
comes in the MySQL-devel-4.0.21-0 rpm NOT in the MySQL-client-5.0.4-0
package. The mysql client would have connected because it was
precompiled with a version 5 library.

When you rebuilt the DBD::MySQL it would have picked up a version 4.0.21
library which would produce the error message that you describe. You may
have to install the version 5 development rpm rather than the one that
you have.

http://dev.mysql.com/doc/mysql/en/old-client.html

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax

=20
-----Original Message-----
From: Philip M. Golllucci [mailto:pgollucci@p6m7g8.com]

Sent: Wednesday, May 18, 2005 10:21 PM
To: Trevor Price
Cc: perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

Trevor Price wrote:
> I might have missed this in the start of the thread, but can you paste
> the first 10 lines or so of the errors.
Okay I looked back in the archives:

>>DBI connect(...) failed: Client does not support authentication

>>protocol requested by server; consider upgrading MySQL client at

>>./test_db.pl line 7

My next thought is try:

ldd mysql
ldd mysqld

make sure the libmysql match up accordingly.

--

END
------------------------------------------------------------ ------------
---
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

style=3D"font-size:8.0pt;font-family:Arial">---------------- -------------=
-
------------------------------------------------------------ ------------
---------------------------------------
DEMANDTEC EMAIL
NOTICE:

NOTICE: This =
email
transmission and all attached files contain information intended for the
designated individual or entity to whom it is addressed and may contain
information that is proprietary, privileged and/or exempt from
disclosure under applicable law. If you are not the intended recipient
or an employee or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any dissemination,
distribution, copying, or other use of this email or its attachments is
strictly prohibited. If you have received this email in error, please
notify the sender immediately by replying to this message and please
delete the original message without making any copies.

WARNING: Computer
viruses can be transmitted via email. The recipient should check this
email and any attachments for the presence of viruses. Although we have
taken reasonable precautions to ensure that this email and all
attachments are free from viruses, we accept no liability for any loss
or damage arising from the use of this email or its attachments.

--=20
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: =
http://lists.mysql.com/perl?unsub=3Ddavid.logan@hp.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

RE: Accessing Mysql 5.0 from 4.0 server

am 19.05.2005 17:28:13 von Trevor Price

Mr. Logan,

Alright more help to the fracas. Thanks for the response. The devel
rpm includes /usr/lib/mysql and /usr/include/mysql. However the
shared-compat includes all the libmysqlclient.so. I installed the 5.0.4
devel package and recompiled. I got different results to make test.
16/18 scripts pass but I get a=20

Make: *** [test_dynamic] Error 29

Here is the entire output

[tprice@thumper DBD-mysql-2.9007]$ make test
PERL_DL_NONLAZY=3D1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
14/30 skipped: Unable to detect a transactional table type;
Skipping transaction tests
t/60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable
not installed
t/ak-dbd...........ok
t/akmisc...........ok 93/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........ok 96/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........ok 109/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........ok 117/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........ok 122/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........ok 175/352DBD::mysql::st execute failed: You have an
error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/akmisc...........FAILED tests 94, 97, 110, 118, 123, 176, 341
Failed 7/352 tests, 98.01% okay
t/dbdadmin.........ok
t/insertid.........ok
t/mysql............DBD::mysql::st execute failed: You have an error in
your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '')' at line 1 at
/home/tprice/DBD-mysql-2.9007/blib/lib/Mysql.pm line 175.
t/mysql............FAILED test 66
Failed 1/68 tests, 98.53% okay
t/mysql2...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/akmisc.t 352 7 1.99% 94 97 110 118 123 176 341
t/mysql.t 68 1 1.47% 66
1 test and 14 subtests skipped.
Failed 2/18 test scripts, 88.89% okay. 8/769 subtests failed, 98.96%
okay.
make: *** [test_dynamic] Error 29

Can I ignore?

-----Original Message-----
From: Logan, David (SST - Adelaide) [mailto:david.logan@hp.com]=20
Sent: Wednesday, May 18, 2005 11:12 PM
To: Trevor Price; perl@lists.mysql.com
Subject: RE: Accessing Mysql 5.0 from 4.0 server

Hi Trevor,

I think your problem may be the version of the mysql client library. You
mentioned your rpm version was 4.0.21. Please note the libmysqlclient.so
comes in the MySQL-devel-4.0.21-0 rpm NOT in the MySQL-client-5.0.4-0
package. The mysql client would have connected because it was
precompiled with a version 5 library.

When you rebuilt the DBD::MySQL it would have picked up a version 4.0.21
library which would produce the error message that you describe. You may
have to install the version 5 development rpm rather than the one that
you have.

http://dev.mysql.com/doc/mysql/en/old-client.html

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax

=20
-----Original Message-----
From: Philip M. Golllucci [mailto:pgollucci@p6m7g8.com]

Sent: Wednesday, May 18, 2005 10:21 PM
To: Trevor Price
Cc: perl@lists.mysql.com
Subject: Re: Accessing Mysql 5.0 from 4.0 server

Trevor Price wrote:
> I might have missed this in the start of the thread, but can you paste
> the first 10 lines or so of the errors.
Okay I looked back in the archives:

>>DBI connect(...) failed: Client does not support authentication

>>protocol requested by server; consider upgrading MySQL client at

>>./test_db.pl line 7

My next thought is try:

ldd mysql
ldd mysqld

make sure the libmysql match up accordingly.

--

END
------------------------------------------------------------ ------------
---
What doesn't kill us can only make us stronger.

Philip M. Gollucci pgollucci@p6m7g8.com 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com

style=3D"font-size:8.0pt;font-family:Arial">---------------- -------------=
-
------------------------------------------------------------ ------------
---------------------------------------
DEMANDTEC EMAIL
NOTICE: