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

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 < [email protected]> 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:[email protected]]
> Sent: Thursday, November 02, 2006 1:01 AM
> To: [email protected]
> 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=Englishwhich
> 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, <PIPE> 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: [email protected]