RE: Accessing Mysql 5.0 from 4.0 server
"Trevor Price" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
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
Make: *** [test_dynamic] Error 29
Here is the entire output
[tprice@thumper DBD-mysql-2.9007]$ make test
PERL_DL_NONLAZY=1 /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:[email protected]]
Sent: Wednesday, May 18, 2005 11:12 PM
To: Trevor Price; [email protected]
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
-----Original Message-----
From: Philip M. Golllucci [mailto:[email protected]]
Sent: Wednesday, May 18, 2005 10:21 PM
To: Trevor Price
Cc: [email protected]
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 [email protected] 301.254.5198
Consultant / http://p6m7g8.net/Resume/resume.shtml
Senior Developer - Liquidity Services Inc.
http://liquidityservicesinc.com
<html>
<body>
<span
style="font-size:8.0pt;font-family:Arial">------------------------------
------------------------------------------------------------------------
---------------------------------------</span>
<span style="font-size:8.0pt;font-family:Arial">DEMANDTEC EMAIL
NOTICE:</span>
<p><span style="font-size:8.0pt;font-family:Arial">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.</span>
<p><span style="font-size:8.0pt;font-family:Arial">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.</span>
</body>
</html>
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]