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_SOUR CE -D_FIL
E_OFFSET_BITS=6 4 -O3 --pipe -DVERSION=\"2.90 03\" -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_SOUR CE -D_FIL
E_OFFSET_BITS=6 4 -O3 --pipe -DVERSION=\"2.90 03\" -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