problem installing DBD::mysql 2.9004

its been quite a while i am trying to test and install DBD::mysql 2.9004 on
my system under windows 2000.
here's some test id made.

to jan eden would you pls help how to make some script same as you are
doing with your project queried via perl script to generate my website.
because i am trying make some query tools like you did.
any reply would be appreciated
nsoXI@skyinet.net

installation and test of DBI 1.45 ------- ok success
installation and test of dbd::mysql 2.9004 ------- failed.

C:\dbdmy2.9004>perl makefile.pl --cflags="-IC:\tmp\mysql-static\Imysql.h"
--libs
="-LC:\tmp\mysql-static\Lmysqlclient.lib"
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
I will use the following settings for compiling and testing:
cflags (Users choice) = -IC:\tmp\mysql-static\Imysql.h
libs (Users choice) = -LC:\tmp\mysql-static\Lmysqlclient.lib
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.45 (for perl 5.008004 on MSWin32-x86-multi-thread) installed in
c:/P
erl/site/lib/auto/DBI/
Writing Makefile for DBD::mysql
in dos shell while trying to test and install dbd::mysql
i dont know if it is same error when u combine 32 and 64 bit libraries?
it is probably related to the usage of my shared libraries like:
mysqlclient.lib and mysql.h
------------------------------------------------------------ --------------------------

------------------------------------------------------------ --------------------------

----------------oooooooooooooo------------------------------ --------
sample script to test the connection of dbd::mysql

#!/usr/bin/perl-w
use DBI;
use strict;
my($dsn)= "DBI:mysql:mysql:user:localhost";
my($user_name)="test";
my($password)="test";
my($dbh);
$dbh=DBI->connect($dsn,$user_name,$password)
or die"Could not connect";
if($dbh)
{
print"connected na po sa mysql\n";
}
exit(0);


------------------------------------------------------------ -------------------------

------------------------------------------------------------ -------------------------

output: failed with dsiplayed available drivers:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains: . c:/Perl/lib c:/Perl/site/lib .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at C:\Perl\SAMPLE\connect.pl line 11

thanks very much
any reply would be greatly appreciated
naz,


--
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: problem installing DBD::mysql 2.9004

National Stistics Office - Region XI wrote:
> its been quite a while i am trying to test and install DBD::mysql 2.9004
> on my system under windows 2000.

Why aren't you simply using PPM to install the driver?

--
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: DBD::mysql on Win32

On Sun, 27 Feb 2005, Randy Kobes wrote:

> Most of the failures involve a memory access violation in
> the shared library mysql.dll of DBD::mysql. Use of
> mysql-4.0.23 leads to no such problems.
>
> Before trying to track this down, I just wanted to confirm
> that DBD-mysql is OK on unix with mysql-4.1? Thanks.

I just compiled 2.9004 on linux, and all of the test passed.

And if you get a good build of DBD::mysql using the 4.10 libaries (or anything
that uses the new mysql auth) for Active Perl, I'll put it up somewhere so that
people can download it.


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

DBD::mysql on Win32

I'm trying to build DBD::mysql (2.9004) on Win32 (ActivePerl
811, based on perl-5.8.6), and am running into problems with
mysql-4.1.10. mysql built OK (with VC++ 6), with just a few
warnings, but DBD::mysql fails a number of its tests:
============================================================
t\00base...........ok
t\10dsnlist........ok
t\20createdrop.....ok
t\30insertfetch....ok
t\40bindparam......dubious
Test returned status 5 (wstat 1280, 0x500)
t\40blobs..........ok
t\40listfields.....ok
t\40nulls..........ok
t\40numrows........ok
t\50chopblanks.....ok
t\50commit.........ok
t\60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t\ak-dbd...........dubious
Test returned status 5 (wstat 1280, 0x500)
DIED. FAILED tests 13-90
Failed 78/90 tests, 13.33% okay
t\akmisc...........dubious
Test returned status 5 (wstat 1280, 0x500)
DIED. FAILED tests 73-351
Failed 279/351 tests, 20.51% okay
t\dbdadmin.........ok
t\insertid.........dubious
Test returned status 5 (wstat 1280, 0x500)
t\mysql............DBD::mysql::st execute failed: Table 'table01' already exists at C:\CPAN~1\build\DBD-MY~2.900\blib\lib/Mysql.pm line 175.
DBD::mysql::st execute failed: Table 'table02' already exists at C:\CPAN~1\build\DBD-MY~2.900\blib\lib/Mysql.pm line 175.
DBD::mysql::st execute failed: Table 'table03' already exists at C:\CPAN~1\build\DBD-MY~2.900\blib\lib/Mysql.pm line 175.
DBD::mysql::st execute failed: Table 'table04' already exists at C:\CPAN~1\build\DBD-MY~2.900\blib\lib/Mysql.pm line 175.
DBD::mysql::st execute failed: Table 'table05' already exists at C:\CPAN~1\build\DBD-MY~2.900\blib\lib/Mysql.pm line 175.
dubious
Test returned status 5 (wstat 1280, 0x500)
t\mysql2...........ok
Failed 5/18 test scripts, 72.22% okay. 357/659 subtests failed, 45.83% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t\40bindparam.t 5 1280 ?? ?? % ??
t\ak-dbd.t 5 1280 90 156 173.33% 13-90
t\akmisc.t 5 1280 351 558 158.97% 73-351
t\insertid.t 5 1280 ?? ?? % ??
t\mysql.t 5 1280 ?? ?? % ??
1 test skipped.
NMAKE : fatal error U1077: 'D:\Perl\bin\perl.exe' : return code '0xff'
Stop.
============================================================ =============
Most of the failures involve a memory access violation in
the shared library mysql.dll of DBD::mysql. Use of
mysql-4.0.23 leads to no such problems.

Before trying to track this down, I just wanted to confirm
that DBD-mysql is OK on unix with mysql-4.1? Thanks.

--
best regards,
randy kobes

--
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: DBD::mysql on Win32

On Sun, 27 Feb 2005, Rudy Lippan wrote:

> On Sun, 27 Feb 2005, Randy Kobes wrote:
>
> > Before trying to track this down, I just wanted to confirm
> > that DBD-mysql is OK on unix with mysql-4.1? Thanks.
>
> I just compiled 2.9004 on linux, and all of the test passed.
>
> And if you get a good build of DBD::mysql using the 4.10
> libaries (or anything that uses the new mysql auth) for
> Active Perl, I'll put it up somewhere so that people can
> download it.

Thanks for checking that. As it is a Win32 problem, I
compared how mysql was built for 4.0.23 vs 4.1.10, and I
think the fix is needing to add another lib (libcmt.lib) to
the link stage, after msvcrt.lib. Anyway, I did that, and it
built fine, and all tests passed. I've put up Win32 ppm
packages (of DBD-mysql-2.9005_3) at
http://theoryx5.uwinnipeg.ca/ppms/
for ActivePerl 8xx, and
http://theoryx5.uwinnipeg.ca/ppmpackages/
for 6xx - these were built against mysql-4.1.10.

--
best regards,
randy

--
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