The Perl module DBD::mysql....NEED HELP!

2025-04-07

I get this error when going into the webmin's MySQL Database server:

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.

After clicking the install link, I get this:

Downloading http://www.cpan.org/authors/id/R/RU/...-2.9002.tar.gz (112563 bytes) ..
Received 1024 bytes (0 %)
Received 11264 bytes (10 %)
Received 22528 bytes (20 %)
Received 33792 bytes (30 %)
Received 45056 bytes (40 %)
Received 56320 bytes (50 %)
Received 67584 bytes (60 %)
Received 78848 bytes (70 %)
Received 90112 bytes (80 %)
Received 101376 bytes (90 %)
Received 112563 bytes (100 %)
.. Download complete.

There is a "Perl module install options" but I don't think I should mess with it. Then I click "Continue with install" and I got this:

Install Module

--------------------------------------------------------------------------------
Making and installing DBD::mysql ..
Untarring module file
Executing gunzip -c /tmp/.webmin/DBD-mysql-2.9002.tar.gz | tar xvf - ..

DBD-mysql-2.9002/
DBD-mysql-2.9002/t/
DBD-mysql-2.9002/t/mysql2.t
DBD-mysql-2.9002/t/akmisc.t
DBD-mysql-2.9002/t/60leaks.t
DBD-mysql-2.9002/t/10dsnlist.t
DBD-mysql-2.9002/t/ak-dbd.t
DBD-mysql-2.9002/t/50chopblanks.t
DBD-mysql-2.9002/t/mysql.t
DBD-mysql-2.9002/t/lib.pl
DBD-mysql-2.9002/t/40blobs.t
DBD-mysql-2.9002/t/40nulls.t
DBD-mysql-2.9002/t/insertid.t
DBD-mysql-2.9002/t/40listfields.t
DBD-mysql-2.9002/t/40bindparam.t
DBD-mysql-2.9002/t/mysql.dbtest
DBD-mysql-2.9002/t/dbdadmin.t
DBD-mysql-2.9002/t/20createdrop.t
DBD-mysql-2.9002/t/00base.t
DBD-mysql-2.9002/t/30insertfetch.t
DBD-mysql-2.9002/t/40numrows.t
DBD-mysql-2.9002/t/50commit.t
DBD-mysql-2.9002/t/mysql.mtest
DBD-mysql-2.9002/MANIFEST
DBD-mysql-2.9002/myld
DBD-mysql-2.9002/dbdimp.c
DBD-mysql-2.9002/lib/
DBD-mysql-2.9002/lib/DBD/
DBD-mysql-2.9002/lib/DBD/mysql/
DBD-mysql-2.9002/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9002/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9002/lib/DBD/mysql.pm
DBD-mysql-2.9002/lib/Mysql/
DBD-mysql-2.9002/lib/Mysql/Statement.pm
DBD-mysql-2.9002/lib/Bundle/
DBD-mysql-2.9002/lib/Bundle/DBD/
DBD-mysql-2.9002/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9002/lib/Mysql.pm
DBD-mysql-2.9002/dbdimp.h
DBD-mysql-2.9002/mysql.xs
DBD-mysql-2.9002/MANIFEST.SKIP
DBD-mysql-2.9002/README
DBD-mysql-2.9002/INSTALL.html
DBD-mysql-2.9002/Makefile.PL
DBD-mysql-2.9002/ChangeLog
DBD-mysql-2.9002/constants.h
DBD-mysql-2.9002/TODO

Compiling module
----------------------------------------------

Executing /usr/bin/perl Makefile.PL && make ..

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
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 /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
Writing Makefile for DBD::mysql
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
gcc -c -I/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -I
/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fPIC -
I/usr/lib/perl5/5.6.1/i386-linux/CORE dbdimp.c
In file included from dbdimp.c:29:
dbdimp.h:31:49: mysql.h: No such file or directory
dbdimp.h:32:49: errmsg.h: No such file or directory
make: *** [dbdimp.o] Error 1

----------------------------------------
Installation of DBD::mysql failed. Check the output above and try installing manually.
You can also install the module from CPAN with the command perl -MCPAN -e shell