DBD::mysql nightmare.

From: John Day (johnday_at_wordsnimages.com)
Date: 10/22/03

  • Next message: Alan Burlison: "Re: DBD::Sybase and Sybase::CTlib build problems w/ 5.8.1, Solaris, gcc 3.x"
    Date: Wed, 22 Oct 2003 11:21:26 -0400
    To: dbi-users@perl.org
    
    

    Hi,

    I am usually handed prebuilt servers with everything installed for me. But this time I am setting up my own development machine. I installed RH8.0 with Apache 1.3.28, mod_perl 1.28 and mod_ssl etc. RH8.0 comes with Perl 5.8.0 and there is a problem with Unicode support - I couldn't install a lot of modules I needed.

    SO - I set out to do some upgrading. I installed Perl 5.8.1 from sources (that was easy!) Then MySQL 4.0.16 from sources, a little harder, but it works fine now!

    BUT - then I tried installing modules, DBI installed okay, but DBD::mysql is a nightmare! Here is the START of what I get:

    Checking if your kit is complete...
    Looks good
    Using DBI 1.38 installed in /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI
    Writing Makefile for DBD::mysql
    cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" dbdimp.c
    Running Mkbootstrap for DBD::mysql ()
    chmod 644 mysql.bs
    cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
    cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
    cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
    cp lib/Mysql.pm blib/lib/Mysql.pm
    cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
    cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
    cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
    /usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI/Driver.xst > mysql.xsi
    chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
    /usr/local/bin/perl /usr/local/lib/perl5/5.8.1/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.1/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
    Warning: duplicate function definition 'do' detected in mysql.xs, line 193
    Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
    cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" mysql.c
    cc1: cc1: warning: changing search order for system directory "/usr/include"
    cc1: warning: as it has already been specified as a non-system directory
    warning: changing search order for system directory "/usr/include"
    cc1: warning: as it has already been specified as a non-system directory
    In file included from mysql.xs:15:
    dbdimp.h:31:49: mysql.h: No such file or directory
    dbdimp.h:32:49: errmsg.h: No such file or directory
    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
    In file included from mysql.xs:15:
    dbdimp.h:116: parse error before "MYSQL"
    dbdimp.h:116: warning: no semicolon at end of struct or union
    In file included from dbdimp.c:29:
    dbdimp.h:116: parse error before "MYSQL"
    dbdimp.h:116: warning: no semicolon at end of struct or union
    dbdimp.h:127: parse error before '}' token
    dbdimp.h:127: parse error before '}' token
    dbdimp.h:156: parse error before "MYSQL_RES"
    dbdimp.h:156: warning: no semicolon at end of struct or union
    dbdimp.h:169: parse error before '}' token
    I am lost. Can anyone help?

    Kindest regards,

    John


  • Next message: Alan Burlison: "Re: DBD::Sybase and Sybase::CTlib build problems w/ 5.8.1, Solaris, gcc 3.x"

    Relevant Pages

    • Re: Feeding data to a Citrix client
      ... android.c:119: error: parse error before "ClientData" ... android.c:119: warning: data definition has no type or storage class ...
      (comp.unix.shell)
    • [Full-Disclosure] [ http://www.k-otik.com/exploits/07.21.win2kdos.c.php ]
      ... test.c:1: parse error before "dcom_recv" ... test.c:15: warning: data definition has no type or storage class ... test.c:28: warning: passing arg 1 of `strlen' makes pointer from integer ...
      (Full-Disclosure)
    • Help with makeing DBD::DB2
      ... Constants.xs:25: warning: `not_here' defined but not used ... dbdimp.h:18: error: parse error before '*' token ... dbdimp.h:18: warning: type defaults to `int' in declaration of ...
      (comp.lang.perl.modules)
    • gaim encryption fails to compile
      ... ge_blist.h:12: error: parse error before '*' token ... ge_blist.h:14: warning: type defaults to `int' in declaration of `GaimAccount' ...
      (Debian-User)
    • [SLE] Shape it plugin
      ... shapeit.c:56: error: parse error before '*' token ... shapeit.c:76: warning: initialization makes integer from pointer without ... shapeit.c:106: warning: type defaults to `int' in declaration of ...
      (SuSE)