Failed install of DBD::mysql

Discussion in 'Perl' started by Randell D., Dec 10, 2003.

  1. Randell D.

    Randell D. Guest

    Folks,
    I have installed MySQL v4 (client, server and development rpm's). I've
    tried and failed to use the recommended mysqladmin to set a root password
    after the installation (I have another post open on the MySQL newsgroup
    about this). I'm attempting an alternative solution and using webmin
    (www.webmin.com) to create/manage access to my databases.

    Webmin reports "Warning: The Perl module DBD::mysql is not installed on your
    system, so Webmin will not be able to reliably access your MySQL database.
    Click here to install it now."

    So... I set out to install the Perl module DBD::mysql module - I attempted
    to perform it using the link provided by webmin (which calls CPAN, something
    I know little about) and from the command line (using perl -MCPAN -e shell
    and then doing INSTALL DBD::mysql at the CPAN command line).

    Both give similar output as to what appears below (which I have grabbed from
    the webmin output, but the errors are identical). Can someone tell me what
    I am missing and how to resolve?

    Much appreciated,
    Randell D.

    ======== PROCESSING AND ERROR OUTPUT FOLLOWS =======
    I will use the following settings for compiling and testing:

    cflags (mysql_config)
    = -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce
    libs (mysql_config)
    = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_file
    s -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
    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.39 installed in
    /usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/auto/DBI
    Writing Makefile for DBD::mysql
    cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
    cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
    cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
    cp lib/Mysql.pm blib/lib/Mysql.pm
    cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
    cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
    cc -c -I/usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/auto/DBI -I/
    usr/include/mysql -mcpu=
    i486 -fno-strength-reduce -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D
    _LARGEFILE_SOURCE -D_FIL
    E_OFFSET_BITS=64 -O3 --pipe -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -
    fPIC "-I/usr/lib/perl5/5
    ..8.0/i586-linux-thread-multi/CORE" dbdimp.c
    /usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
    /usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/auto
    /DBI/Driver.xst > mysql.xsi
    /usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
    /usr/lib/perl5/5.8.0/ExtUtils/typemap
    mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
    Warning: duplicate function definition 'do' detected in mysql.xs, line 192
    Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
    cc -c -I/usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi/auto/DBI -I/
    usr/include/mysql -mcpu=
    i486 -fno-strength-reduce -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D
    _LARGEFILE_SOURCE -D_FIL
    E_OFFSET_BITS=64 -O3 --pipe -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -
    fPIC "-I/usr/lib/perl5/5
    ..8.0/i586-linux-thread-multi/CORE" mysql.c
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    rm -f blib/arch/auto/DBD/mysql/mysql.so
    LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared dbdimp.o
    mysql.o -o blib/arch/auto
    /DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -
    lc -lnss_files -lnss_dns
    -lresolv -lc -lnss_files -lnss_dns -lresolv
    /usr/lib/gcc-lib/i486-suse-linux/3.2/../../../../i486-suse-linux/bin/ld:
    cannot find -lnss_files
    collect2: ld returned 1 exit status
    make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
     
    Randell D., Dec 10, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. JL
    Replies:
    0
    Views:
    1,174
  2. Andrew Crook

    DBD::CSV questions and is there a DBD::XML?

    Andrew Crook, Sep 2, 2003, in forum: Perl Misc
    Replies:
    2
    Views:
    182
    Andrew Crook
    Sep 11, 2003
  3. Mike Solomon

    DBD::mysqlPP v DBD::mysql

    Mike Solomon, Feb 16, 2004, in forum: Perl Misc
    Replies:
    1
    Views:
    244
    James Willmore
    Feb 16, 2004
  4. mike
    Replies:
    6
    Views:
    237
    Tad McClellan
    Apr 22, 2005
  5. Jim Cochrane
    Replies:
    0
    Views:
    127
    Jim Cochrane
    Aug 25, 2007
Loading...

Share This Page