mysql/perl confusion

am 22.07.2003 01:03:36 von Peter Stoddard

Hi folks

I am trying to get mysql to work. I have downloaded and compiled the
code using both fink (v.3.23.54a) and the Mac OS X Package Installer
(v.4.0.13) from www.mysql.com, and I get the same errors either way.

I get mysql running fine. Then I try to run the benchmark tests called
run-all-tests:

The computer says:

[peter12:local/mysql/sql-bench] peter12# ./run-all-tests
Can't locate loadable object for module DBI in @INC (@INC contains:
/System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
/Library/Perl /Library/Perl /Network/Library/Perl/darwin
/Network/Library/Perl /Network/Library/Perl .) at
/System/Library/Perl/darwin/DBI.pm line 250
BEGIN failed--compilation aborted at /System/Library/Perl/darwin/DBI.pm
line 250.
Compilation failed in require at ./run-all-tests line 36.
BEGIN failed--compilation aborted at ./run-all-tests line 36.

I say:

I thought there must be something wrong with my version of DBD, so I
downloaded and tried to build DBD-mysql-2.9002, and found the following:

The computer says:

# perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/sw/include/mysql'
libs (mysql_config) = -L/sw/lib/mysql -lmysqlclient -lz -lm
-L/sw/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'.

Checking if your kit is complete...
Looks good

Warning: prerequisite DBI failed to load: DBI object version 1.37 does
not match $DBI::VERSION 1.31 at
/System/Library/Perl/darwin/DynaLoader.pm line 219, line 50.
BEGIN failed--compilation aborted at /System/Library/Perl/darwin/DBI.pm
line 250, line 50.
Compilation failed in require at (eval 4) line 3, line 50.
Using DBI 1.31 installed in /Library/Perl/darwin/auto/DBI
Writing Makefile for DBD::mysql

I say:

Line 219 of /System/Library/Perl/darwin/DynaLoader.pm says

# See comment block above
&$xs(@args);

.... and the comment block they refer to says:

# Many dynamic extension loading problems will appear to come from
# this section of code: XYZ failed at line 123 of DynaLoader.pm.
# Often these errors are actually occurring in the initialisation
# C code of the extension XS file. Perl reports the error as being
# in this perl code simply because this was the last perl code
# it executed.

I am running Mac OSX v.10.2.6. I don't know where to post this, so I
will start here first.

Thanks in advance.

Pete
--
Peter Stoddard -- GnuPG ID 0x303F62AC

--
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: mysql/perl confusion

am 22.07.2003 02:24:35 von Greg Meckes

Looks like you have to install DBI.

Try from the command line:
perl -MCPAN -e shell

Then after you get the cpan prompt:
cpan> install DBI

Then try your tests again.

Greg

--- Peter Stoddard wrote:
> Hi folks
>
> I am trying to get mysql to work. I have downloaded and compiled the
> code using both fink (v.3.23.54a) and the Mac OS X Package Installer
> (v.4.0.13) from www.mysql.com, and I get the same errors either way.
>
> I get mysql running fine. Then I try to run the benchmark tests called
> run-all-tests:
>
> The computer says:
>
> [peter12:local/mysql/sql-bench] peter12# ./run-all-tests
> Can't locate loadable object for module DBI in @INC (@INC contains:
> /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
> /Library/Perl /Library/Perl /Network/Library/Perl/darwin
> /Network/Library/Perl /Network/Library/Perl .) at
> /System/Library/Perl/darwin/DBI.pm line 250
> BEGIN failed--compilation aborted at /System/Library/Perl/darwin/DBI.pm
> line 250.
> Compilation failed in require at ./run-all-tests line 36.
> BEGIN failed--compilation aborted at ./run-all-tests line 36.
>
> I say:
>
> I thought there must be something wrong with my version of DBD, so I
> downloaded and tried to build DBD-mysql-2.9002, and found the following:
>
> The computer says:
>
> # perl Makefile.PL
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) = -I'/sw/include/mysql'
> libs (mysql_config) = -L/sw/lib/mysql -lmysqlclient -lz -lm
> -L/sw/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'.
>
> Checking if your kit is complete...
> Looks good
>
> Warning: prerequisite DBI failed to load: DBI object version 1.37 does
> not match $DBI::VERSION 1.31 at
> /System/Library/Perl/darwin/DynaLoader.pm line 219, line 50.
> BEGIN failed--compilation aborted at /System/Library/Perl/darwin/DBI.pm
> line 250, line 50.
> Compilation failed in require at (eval 4) line 3, line 50.
> Using DBI 1.31 installed in /Library/Perl/darwin/auto/DBI
> Writing Makefile for DBD::mysql
>
> I say:
>
> Line 219 of /System/Library/Perl/darwin/DynaLoader.pm says
>
> # See comment block above
> &$xs(@args);
>
> ... and the comment block they refer to says:
>
> # Many dynamic extension loading problems will appear to come from
> # this section of code: XYZ failed at line 123 of DynaLoader.pm.
> # Often these errors are actually occurring in the initialisation
> # C code of the extension XS file. Perl reports the error as being
> # in this perl code simply because this was the last perl code
> # it executed.
>
> I am running Mac OSX v.10.2.6. I don't know where to post this, so I
> will start here first.
>
> Thanks in advance.
>
> Pete
> --
> Peter Stoddard -- GnuPG ID 0x303F62AC
>
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=gregmeckes@yahoo.com
>

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.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: mysql/perl confusion

am 22.07.2003 02:24:35 von Greg Meckes

Re: mysql/perl confusion

am 22.07.2003 05:47:32 von Peter Stoddard

Thanks for several suggestions, which can be summarized as "having
various, possibly incomplete versions of DBI floating around." (Jochen
Wiedmann). I have followed instructions but I am still having problems.

I reinstalled DBI from ~/.cpan/build/DBI-1.37 as follows:

perl Makefile.PL
make
make test
make install UNINST=1

Then I ran my test again:

The computer said:

[peter12:local/mysql/sql-bench] peter12# ./run-all*
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains: /System/Library/Perl/darwin /System/Library/Perl
/Library/Perl/darwin /Library/Perl /Library/Perl
/Network/Library/Perl/darwin /Network/Library/Perl
/Network/Library/Perl .) at (eval 50) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Multiplex, Proxy.
at
/usr/local/mysql-standard-4.0.13-apple-darwin6.4-powerpc/sql -bench/
server-cfg line 240

I say:

I figured there might be a problem with DBD-mysql-2.9002 so I removed
the old Makefile and did perl Makefile.PL

The computer said:

[peter12:~/.cpan/build/DBD-mysql-2.9002] peter12# perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/sw/include/mysql'
libs (mysql_config) = -L/sw/lib/mysql -lmysqlclient -lz -lm
-L/sw/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'.

Checking if your kit is complete...
Looks good
Using DBI 1.37 installed in /Library/Perl/darwin/auto/DBI
Writing Makefile for DBD::mysql

I say:

Then I did a make on the resulting Makefile, which seemed to go OK, and
then a make test, and that's where I continued to get these errors:

The computer said:

BEGIN failed--compilation aborted at
/System/Library/Perl/darwin/darwin/DBI.pm line 250.
Compilation failed in require at t/00base.t line 28.
t/00base...........dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/10dsnlist........DBI object version 1.37 does not match $DBI::VERSION
1.31 at /System/Library/Perl/darwin/DynaLoader.pm line 219.

I say:

The above happened a number of times and the test ended badly:

The computer said:

DIED. FAILED tests 1-68
Failed 68/68 tests, 0.00% okay
t/mysql2...........Can't locate auto/DBI/install_dri.al in @INC (@INC
contains: blib/arch blib/lib /System/Library/Perl/darwin/darwin
/System/Library/Perl/darwin/darwin /System/Library/Perl/darwin
/System/Library/Perl/darwin/darwin /System/Library/Perl/darwin
/System/Library/Perl/darwin /System/Library/Perl
/System/Library/Perl/darwin/darwin /System/Library/Perl/darwin
/System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin
/Library/Perl/darwin /Library/Perl /Library/Perl/darwin /Library/Perl
/Network/Library/Perl/darwin /Network/Library/Perl
/Network/Library/Perl . /System/Library/Perl/darwin
/System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl
/Network/Library/Perl/darwin /Network/Library/Perl
/Network/Library/Perl .) at blib/lib/Mysql.pm line 68
t/mysql2...........dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/00base.t 2 512 5 10 200.00% 1-5
t/10dsnlist.t 2 512 ?? ?? % ??
t/20createdrop.t 2 512 ?? ?? % ??
t/30insertfetch.t 2 512 ?? ?? % ??
t/40bindparam.t 2 512 ?? ?? % ??
t/40blobs.t 2 512 ?? ?? % ??
t/40listfields.t 2 512 ?? ?? % ??
t/40nulls.t 2 512 ?? ?? % ??
t/40numrows.t 2 512 ?? ?? % ??
t/50chopblanks.t 2 512 ?? ?? % ??
t/50commit.t 2 512 ?? ?? % ??
t/ak-dbd.t 2 512 ?? ?? % ??
t/akmisc.t 255 65280 351 702 200.00% 1-351
t/dbdadmin.t 2 512 ?? ?? % ??
t/mysql.t 2 512 68 136 200.00% 1-68
t/mysql2.t 255 65280 ?? ?? % ??
1 test skipped.
Failed 17/18 test scripts, 5.56% okay. 424/424 subtests failed, 0.00%
okay.
make: *** [test_dynamic] Error 2

I say:

So I continue to have the problem with DBI, and now I am having a
problem with DBD-mysql. I feel like I am getting in deeper and deeper
into something I don't understand.

Pete

--
Peter Stoddard -- GnuPG ID 0x303F62AC

--
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: mysql/perl confusion

am 22.07.2003 05:47:32 von Peter Stoddard