zeltus has asked for the wisdom of the Perl Monks concerning the following question:

Hello

I am trying to install DBI and DBD::mysql on an Ubuntu box. I have never had any problems before but on this box, DBI install OK but DBD::mysql is giving me the diagnostics below

Any suggestions? Am I missing something obvious here? The version numbers I am using are all embedded in the error messages, but essentially, I downloaded the latest and greatest from MetaCPAN

# perl Makefile.PL

{comments deleted}

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

Checking if your kit is complete...
Looks good
Using DBI 1.634 (for perl 5.022000 on i686-linux) installed in /usr/local/lib/perl5/site_perl/5.22.0/i686-linux/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
# make
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp README.pod blib/lib/DBD/README.pod
Running Mkbootstrap for DBD::mysql ()
chmod 644 "mysql.bs"
cc -c  -I/usr/local/lib/perl5/site_perl/5.22.0/i686-linux/auto/DBI -I/usr/include/mysql -DBIG_JOINS=1 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2 -O2   -DVERSION=\"4.033\" -DXS_VERSION=\"4.033\" -fPIC "-I/usr/local/lib/perl5/5.22.0/i686-linux/CORE"   dbdimp.c
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3774: error: ‘struct st_mysql_bind’ has no member named ‘error’
make: *** dbdimp.o Error 1

Replies are listed 'Best First'.
Re: Perl DBI - MySQL issue
by NetWallah (Canon) on Apr 12, 2016 at 17:20 UTC
    Looks like you are running into This bug in DBD::mysql.

    There is a patch attached to that bug report.

            This is not an optical illusion, it just looks like one.

      Ooh well spotted!

      The patch worked just fine... unfortunately for me, this means I have to continue using this tatty old server for testing :-}

      No idea how the testing is supposed to be valid when this server is nothing like the modern, sexy and shiny Prod. servers but there you go. FOHSA KITD!

      Thanks again

Re: Perl DBI - MySQL issue
by zeltus (Beadle) on Apr 12, 2016 at 15:48 UTC

    Actually, after a bit more investigation, this server seems to be running Ubuntu 6.06 "dapper". That is sooo old!

    There is nothing wrong with the module per se, it compiles fine on newer Debian and Red Hat boxen I have, so I am going to officially lose interest in this server - I only support the newest and the shiniest! :-)