*** ERROR: PERL module DBD::mysql is not installed ! (Completed install Bundle::DBD::mysql)

------=_Part_31193_32487220.1162422040824
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Greetings,

Looking for some help with ensuring proper installation of DBD::mysql. It is
required for http://ocsinventory.sourceforge.net/index.php?page=Englishwh ich
is my ultimate goal but the installer erors out with:

>
> > +----------------------------------------------------------+
> > | Checking for required Perl Modules... |
> > +----------------------------------------------------------+
> >
> > Checking for DBI PERL module...
> > Found that PERL module DBI is available.
> > Checking for Apache::DBI PERL module...
> > Found that PERL module Apache::DBI is available.
> > Checking for DBD::mysql PERL module...
> > *** ERROR: PERL module DBD::mysql is not installed !
>

>
>
As you can see I was able to get many modules working with CPAN installs but
it does not recognize DBD. I ran a normal cpan install line:\

install Bundle::DBD::mysql

Which ends with:

Running make install
Appending installation info to /usr/local/lib/perl/5.8.4/perllocal.pod
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Writing /usr/local/lib/perl/5.8.4/auto/DBD/mysql/.packlist
/usr/bin/make install -j3 -- OK

I reran the installer and got the same error:

*** ERROR: PERL module DBD::mysql is not installed !

I thought that perhaps since I have my own mySQL build and not the binary
that it perhaps wasn't finding it. I downloaded the
DBD-mysql-3.0008.tar.gzunpacked it and ran:

perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
--testdb=test --testuser=test --testpassword=***** --testhost=localhost
--testport=3306

Outputs:

I will use the following settings for compiling and testing:

cflags (mysql_config ) = -I/usr/local/mysql/include
-mcpu=pentiumpro
embedded (mysql_config ) =
libs (mysql_config ) = -L/usr/local/lib -L/usr/local/mysql/lib
-lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc
-lnss_files -lnss_dns -lresolv
mysql_config (Users choice ) = /usr/local/mysql/bin/mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (User's choice) = test
testhost (User's choice) = localhost
testpassword (User's choice) = *****
Use of uninitialized value in printf at Makefile.PL line 172, line
63.
testport ( ) = 3306
testsocket (default ) =
testuser (User's choice) = test

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Multiple copies of Driver.xst found in: /usr/local/lib/perl/5.8.4/auto/DBI/
/usr/lib/perl5/auto/DBI/ at Makefile.PL line 727
Using DBI 1.52 (for perl 5.008004 on i386-linux-thread-multi) installed in
/usr/local/lib/perl/5.8.4/auto/DBI/
Writing Makefile for DBD::mysql

I Run Make... no problem then run make test and it fails most of the tests:

Failed Test Stat Wstat Total Fail List of Failed
------------------------------------------------------------ -------------------
t/00base.t 255 65280 5 4 4-5
t/10dsnlist.t 255 65280 3 6 1-3
t/20createdrop.t 255 65280 5 10 1-5
t/30insertfetch.t 255 65280 11 22 1-11
t/35limit.t 255 65280 113 226 1-113
t/35prepare.t 255 65280 30 60 1-30
t/40bindparam.t 255 65280 28 56 1-28
t/40bindparam2.t 255 65280 13 26 1-13
t/40blobs.t 255 65280 11 22 1-11
t/40listfields.t 255 65280 18 36 1-18
t/40nulls.t 255 65280 11 22 1-11
t/40numrows.t 255 65280 25 50 1-25
t/41bindparam.t 255 65280 11 22 1-11
t/41blobs_prepare.t 255 65280 24 48 1-24
t/42bindparam.t 255 65280 11 22 1-11
t/50chopblanks.t 255 65280 35 70 1-35
t/50commit.t 255 65280 30 60 1-30
t/dbdadmin.t 255 65280 21 42 1-21
t/insertid.t 255 65280 12 24 1-12
t/param_values.t 255 65280 8 16 1-8
t/prepare_noerror.t 255 65280 ?? ?? ??
t/texecute.t 255 65280 9 18 1-9
1 test skipped.
Failed 22/23 test scripts. 431/434 subtests failed.
Files=23, Tests=434, 7 wallclock secs ( 1.70 cusr + 0.34 csys = 2.04 CPU)
Failed 22/23 test programs. 431/434 subtests failed.
make: *** [test_dynamic] Error 255


I am at a loss as to what my next step should be. It appears that the CPAN
install has gone through yet I cannot find the appropriate linking librarys,
or rather the installer I am using can't. Any suggestions as to either
diagnostic or correctional steps would be greatly appreciated.

------=_Part_31193_32487220.1162422040824--

Re: *** ERROR: PERL module DBD::mysql is not installed ! (Completed install Bundle::DBD::mysql)

------=_Part_8520_28610496.1162488784345
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I should also point out that DBD using cpan does appear to complete without
error. It is only if I try to build/compile it outside of CPAN that it
fails.

cpan> install Bundle::DBD::mysql
DBI is up to date (1.52).
Data::ShowTable is up to date (undef).
Mysql is up to date (1.2401).
DBD::mysql is up to date (3.0008).

I installed just the base binary, mysql-max-5.0.26-linux-i686

mysql_config does link to the appropriate libararys:
bin/mysql_config --libs
-L/usr/local/lib -L/usr/local/mysql-max-5.0.26-linux-i686 /lib -lmysqlclient
-lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files
-lnss_dns -lresolv

Though I did notice that in /mysql/lib there is no libmysqlclient.so just a
libmysqclient.a
/usr/local/mysql- max-5.0.26-linux-i686/lib$ ls
libdbug.a libmysqlclient.a libmysql.imp libmysys.a
libndbclient.la
libmygcc.a libmysqlclient_r.a libmystrings.a libndbclient.a

I don't know what the difference here is and if this is causing the problem.
Moreover since I installed just the base binary I am not sure what I would
need to install/compile to get it to a shared object rather than .a

Just so you know my original setup. I am on Debian. Obviously I didn't use
the debian package since it was 4.1 tree. I used the base non-rpm
download... mysql-max-5.0.26-linux-i686

Thanks to Yair and anyone else who can throw me some help.


On 11/1/06, Yair Lapin < yairl@savion.huji.ac.il> wrote:
>
> If you use the CPAN shell
> Perl -MCPAN -e shell
> You must install the modules in some order
> >install DBI (this is the database interface, without a correct version of
> interface anything will not work)
> ............
> When you have DBI installed
> >install DBD::mysql (this is the mysql driver)
> It looks like problems with your linked mysql libraries. Check if your
> mysql_config points to correct libraries directories. Did you compiled or
> installed the mysql client libraries? You can install the libraries with
> binaries rpm files.
>
>
>
> -----Original Message-----
> From: Taylor [mailto:gray.race@gmail.com]
> Sent: Thursday, November 02, 2006 1:01 AM
> To: perl@lists.mysql.com
> Subject: *** ERROR: PERL module DBD::mysql is not installed ! (Completed
> install Bundle::DBD::mysql)
>
> Greetings,
>
> Looking for some help with ensuring proper installation of DBD::mysql. It
> is
> required for
> http://ocsinventory.sourceforge.net/index.php?page=Englishwh ich
> is my ultimate goal but the installer erors out with:
>
> >
> > > +----------------------------------------------------------+
> > > | Checking for required Perl Modules... |
> > > +----------------------------------------------------------+
> > >
> > > Checking for DBI PERL module...
> > > Found that PERL module DBI is available.
> > > Checking for Apache::DBI PERL module...
> > > Found that PERL module Apache::DBI is available.
> > > Checking for DBD::mysql PERL module...
> > > *** ERROR: PERL module DBD::mysql is not installed !
> >
>
> >
> >
> As you can see I was able to get many modules working with CPAN installs
> but
> it does not recognize DBD. I ran a normal cpan install line:\
>
> install Bundle::DBD::mysql
>
> Which ends with:
>
> Running make install
> Appending installation info to /usr/local/lib/perl/5.8.4/perllocal.pod
> Files found in blib/arch: installing files in blib/lib into architecture
> dependent library tree
> Writing /usr/local/lib/perl/5.8.4/auto/DBD/mysql/.packlist
> /usr/bin/make install -j3 -- OK
>
> I reran the installer and got the same error:
>
> *** ERROR: PERL module DBD::mysql is not installed !
>
> I thought that perhaps since I have my own mySQL build and not the binary
> that it perhaps wasn't finding it. I downloaded the
> DBD-mysql-3.0008.tar.gzunpacked it and ran:
>
> perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
> --testdb=test --testuser=test --testpassword=***** --testhost=localhost
> --testport=3306
>
> Outputs:
>
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config ) = -I/usr/local/mysql/include
> -mcpu=pentiumpro
> embedded (mysql_config ) =
> libs (mysql_config ) = -L/usr/local/lib -L/usr/local/mysql/lib
> -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc
> -lnss_files -lnss_dns -lresolv
> mysql_config (Users choice ) = /usr/local/mysql/bin/mysql_config
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> testdb (User's choice) = test
> testhost (User's choice) = localhost
> testpassword (User's choice) = *****
> Use of uninitialized value in printf at Makefile.PL line 172, line
> 63.
> testport ( ) = 3306
> testsocket (default ) =
> testuser (User's choice) = test
>
> To change these settings, see 'perl Makefile.PL --help' and
> 'perldoc INSTALL'.
>
> Multiple copies of Driver.xst found in:
> /usr/local/lib/perl/5.8.4/auto/DBI/
> /usr/lib/perl5/auto/DBI/ at Makefile.PL line 727
> Using DBI 1.52 (for perl 5.008004 on i386-linux-thread-multi) installed in
>
> /usr/local/lib/perl/5.8.4/auto/DBI/
> Writing Makefile for DBD::mysql
>
> I Run Make... no problem then run make test and it fails most of the
> tests:
>
> Failed Test Stat Wstat Total Fail List of Failed
>
> ------------------------------------------------------------ -------------------
> t/00base.t 255 65280 5 4 4-5
> t/10dsnlist.t 255 65280 3 6 1-3
> t/20createdrop.t 255 65280 5 10 1-5
> t/30insertfetch.t 255 65280 11 22 1-11
> t/35limit.t 255 65280 113 226 1-113
> t/35prepare.t 255 65280 30 60 1-30
> t/40bindparam.t 255 65280 28 56 1-28
> t/40bindparam2.t 255 65280 13 26 1-13
> t/40blobs.t 255 65280 11 22 1-11
> t/40listfields.t 255 65280 18 36 1-18
> t/40nulls.t 255 65280 11 22 1-11
> t/40numrows.t 255 65280 25 50 1-25
> t/41bindparam.t 255 65280 11 22 1-11
> t/41blobs_prepare.t 255 65280 24 48 1-24
> t/42bindparam.t 255 65280 11 22 1-11
> t/50chopblanks.t 255 65280 35 70 1-35
> t/50commit.t 255 65280 30 60 1-30
> t/dbdadmin.t 255 65280 21 42 1-21
> t/insertid.t 255 65280 12 24 1-12
> t/param_values.t 255 65280 8 16 1-8
> t/prepare_noerror.t 255 65280 ?? ?? ??
> t/texecute.t 255 65280 9 18 1-9
> 1 test skipped.
> Failed 22/23 test scripts. 431/434 subtests failed.
> Files=23, Tests=434, 7 wallclock secs ( 1.70 cusr + 0.34 csys = 2.04CPU)
> Failed 22/23 test programs. 431/434 subtests failed.
> make: *** [test_dynamic] Error 255
>
>
> I am at a loss as to what my next step should be. It appears that the CPAN
> install has gone through yet I cannot find the appropriate linking
> librarys,
> or rather the installer I am using can't. Any suggestions as to either
> diagnostic or correctional steps would be greatly appreciated.
>



--
Taylor Judd
Information Technology Consultant
Academic Technology
Library 437
San Francisco State University
1600 Holloway Avenue
San Francisco, CA 94132-4030

Tel: 415/405-3539
Cell: 415/260-4986
Email: tjudd@sfsu.edu

------=_Part_8520_28610496.1162488784345--

Re: *** ERROR: PERL module DBD::mysql is not installed ! (Completedinstall Bundle::DBD::mysql)

Don't know if it's related to the problem I had recently related to
specifying paths correctly, I had to make it like this to get it to work--

"
perl Makefile.PL --cflags=-I/usr/local/mysql/include
--libs="-L/usr/local/mysql/lib -lmysqlclient -lcrypt -lnsl -lm -lz -lc
-lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv"

That seems to have resolved the issue. Apparently the default path is
/usr/lib/mysql but in my system it is the above path. For the life of
me I couldn't google the above solution. Now I have other issues to
deal with ......
"

Taylor wrote:
> I should also point out that DBD using cpan does appear to complete
> without
> error. It is only if I try to build/compile it outside of CPAN that it
> fails.
>
> cpan> install Bundle::DBD::mysql
> DBI is up to date (1.52).
> Data::ShowTable is up to date (undef).
> Mysql is up to date (1.2401).
> DBD::mysql is up to date (3.0008).
>
> I installed just the base binary, mysql-max-5.0.26-linux-i686
>
> mysql_config does link to the appropriate libararys:
> bin/mysql_config --libs
> -L/usr/local/lib -L/usr/local/mysql-max-5.0.26-linux-i686 /lib
> -lmysqlclient
> -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files
> -lnss_dns -lresolv
>
> Though I did notice that in /mysql/lib there is no libmysqlclient.so
> just a
> libmysqclient.a
> /usr/local/mysql- max-5.0.26-linux-i686/lib$ ls
> libdbug.a libmysqlclient.a libmysql.imp libmysys.a
> libndbclient.la
> libmygcc.a libmysqlclient_r.a libmystrings.a libndbclient.a
>
> I don't know what the difference here is and if this is causing the
> problem.
> Moreover since I installed just the base binary I am not sure what I
> would
> need to install/compile to get it to a shared object rather than .a
>
> Just so you know my original setup. I am on Debian. Obviously I didn't
> use
> the debian package since it was 4.1 tree. I used the base non-rpm
> download... mysql-max-5.0.26-linux-i686
>
> Thanks to Yair and anyone else who can throw me some help.
>
>
> On 11/1/06, Yair Lapin < yairl@savion.huji.ac.il> wrote:
>>
>> If you use the CPAN shell
>> Perl -MCPAN -e shell
>> You must install the modules in some order
>> >install DBI (this is the database interface, without a correct
>> version of
>> interface anything will not work)
>> ............
>> When you have DBI installed
>> >install DBD::mysql (this is the mysql driver)
>> It looks like problems with your linked mysql libraries. Check if your
>> mysql_config points to correct libraries directories. Did you
>> compiled or
>> installed the mysql client libraries? You can install the libraries with
>> binaries rpm files.
>>
>>
>>
>> -----Original Message-----
>> From: Taylor [mailto:gray.race@gmail.com]
>> Sent: Thursday, November 02, 2006 1:01 AM
>> To: perl@lists.mysql.com
>> Subject: *** ERROR: PERL module DBD::mysql is not installed ! (Completed
>> install Bundle::DBD::mysql)
>>
>> Greetings,
>>
>> Looking for some help with ensuring proper installation of
>> DBD::mysql. It
>> is
>> required for
>> http://ocsinventory.sourceforge.net/index.php?page=Englishwh ich
>> is my ultimate goal but the installer erors out with:
>>
>> >
>> > > +----------------------------------------------------------+
>> > > | Checking for required Perl Modules... |
>> > > +----------------------------------------------------------+
>> > >
>> > > Checking for DBI PERL module...
>> > > Found that PERL module DBI is available.
>> > > Checking for Apache::DBI PERL module...
>> > > Found that PERL module Apache::DBI is available.
>> > > Checking for DBD::mysql PERL module...
>> > > *** ERROR: PERL module DBD::mysql is not installed !
>> >
>>
>> >
>> >
>> As you can see I was able to get many modules working with CPAN installs
>> but
>> it does not recognize DBD. I ran a normal cpan install line:\
>>
>> install Bundle::DBD::mysql
>>
>> Which ends with:
>>
>> Running make install
>> Appending installation info to /usr/local/lib/perl/5.8.4/perllocal.pod
>> Files found in blib/arch: installing files in blib/lib into architecture
>> dependent library tree
>> Writing /usr/local/lib/perl/5.8.4/auto/DBD/mysql/.packlist
>> /usr/bin/make install -j3 -- OK
>>
>> I reran the installer and got the same error:
>>
>> *** ERROR: PERL module DBD::mysql is not installed !
>>
>> I thought that perhaps since I have my own mySQL build and not the
>> binary
>> that it perhaps wasn't finding it. I downloaded the
>> DBD-mysql-3.0008.tar.gzunpacked it and ran:
>>
>> perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
>> --testdb=test --testuser=test --testpassword=***** --testhost=localhost
>> --testport=3306
>>
>> Outputs:
>>
>> I will use the following settings for compiling and testing:
>>
>> cflags (mysql_config ) = -I/usr/local/mysql/include
>> -mcpu=pentiumpro
>> embedded (mysql_config ) =
>> libs (mysql_config ) = -L/usr/local/lib
>> -L/usr/local/mysql/lib
>> -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns
>> -lresolv -lc
>> -lnss_files -lnss_dns -lresolv
>> mysql_config (Users choice ) = /usr/local/mysql/bin/mysql_config
>> nocatchstderr (default ) = 0
>> nofoundrows (default ) = 0
>> ssl (guessed ) = 0
>> testdb (User's choice) = test
>> testhost (User's choice) = localhost
>> testpassword (User's choice) = *****
>> Use of uninitialized value in printf at Makefile.PL line 172,
>> line
>> 63.
>> testport ( ) = 3306
>> testsocket (default ) =
>> testuser (User's choice) = test
>>
>> To change these settings, see 'perl Makefile.PL --help' and
>> 'perldoc INSTALL'.
>>
>> Multiple copies of Driver.xst found in:
>> /usr/local/lib/perl/5.8.4/auto/DBI/
>> /usr/lib/perl5/auto/DBI/ at Makefile.PL line 727
>> Using DBI 1.52 (for perl 5.008004 on i386-linux-thread-multi)
>> installed in
>>
>> /usr/local/lib/perl/5.8.4/auto/DBI/
>> Writing Makefile for DBD::mysql
>>
>> I Run Make... no problem then run make test and it fails most of the
>> tests:
>>
>> Failed Test Stat Wstat Total Fail List of Failed
>>
>> ------------------------------------------------------------ -------------------
>>
>> t/00base.t 255 65280 5 4 4-5
>> t/10dsnlist.t 255 65280 3 6 1-3
>> t/20createdrop.t 255 65280 5 10 1-5
>> t/30insertfetch.t 255 65280 11 22 1-11
>> t/35limit.t 255 65280 113 226 1-113
>> t/35prepare.t 255 65280 30 60 1-30
>> t/40bindparam.t 255 65280 28 56 1-28
>> t/40bindparam2.t 255 65280 13 26 1-13
>> t/40blobs.t 255 65280 11 22 1-11
>> t/40listfields.t 255 65280 18 36 1-18
>> t/40nulls.t 255 65280 11 22 1-11
>> t/40numrows.t 255 65280 25 50 1-25
>> t/41bindparam.t 255 65280 11 22 1-11
>> t/41blobs_prepare.t 255 65280 24 48 1-24
>> t/42bindparam.t 255 65280 11 22 1-11
>> t/50chopblanks.t 255 65280 35 70 1-35
>> t/50commit.t 255 65280 30 60 1-30
>> t/dbdadmin.t 255 65280 21 42 1-21
>> t/insertid.t 255 65280 12 24 1-12
>> t/param_values.t 255 65280 8 16 1-8
>> t/prepare_noerror.t 255 65280 ?? ?? ??
>> t/texecute.t 255 65280 9 18 1-9
>> 1 test skipped.
>> Failed 22/23 test scripts. 431/434 subtests failed.
>> Files=23, Tests=434, 7 wallclock secs ( 1.70 cusr + 0.34 csys =
>> 2.04CPU)
>> Failed 22/23 test programs. 431/434 subtests failed.
>> make: *** [test_dynamic] Error 255
>>
>>
>> I am at a loss as to what my next step should be. It appears that the
>> CPAN
>> install has gone through yet I cannot find the appropriate linking
>> librarys,
>> or rather the installer I am using can't. Any suggestions as to either
>> diagnostic or correctional steps would be greatly appreciated.
>>
>
>
>

--
Andy McHargue
Webmaster
Annenberg School for Communication
University of Southern California
http://annenberg.usc.edu
mchargue@usc.edu
Phone: 213.740.1290


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