Hi All,

Having some issues compiling DBD::mysql. Here's the info:
Machine:
SunOS v9 Sparc
Perl (built from source):
v5.8.3 built for sun4-solaris-thread-multi-64int
Mysql (built from source):
4.0.17, for sun-solaris2.9 on sparc (64 bit)

Here's the log from my build of DBD::mysql:

root@svx:/.cpan/build/DBD-mysql-2.9003>perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/local/mysql/include/mysql -m64 -O3
libs (mysql_config) = -L/usr/local/lib -R/usr/local/lib -R/usr/lib -L/usr/lib -R/usr/openwin/lib -L/usr/openwin/lib -L/usr/local/ssl/lib/ -R/usr/local/ssl/lib/ -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 1
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.42 (for perl 5.008003 on sun4-solaris-thread-multi-64int) installed in /usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris-thread-multi-64int/auto/DBI
Writing Makefile for DBD::mysql

root@svx:/.cpan/build/DBD-mysql-2.9003>make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris-thread-multi-64int/auto/DBI -I/usr/local/mysql/include/mysql -m64 -O3 -DDBD_MYSQL_WITH_SSL -D_REENTRANT -fno-strict-aliasing -I/usr/local/include -I/usr/sfw/include -I/opt/sfw/include -I/usr/ccs/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/usr/local/lib/perl5/5.8.3/sun4-solaris-thread-multi-64int/CORE" dbdimp.c
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris-thread-multi-64int/auto/DBI/Driver.xst > mysql.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.3/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.3/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
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris-thread-multi-64int/auto/DBI -I/usr/local/mysql/include/mysql -m64 -O3 -DDBD_MYSQL_WITH_SSL -D_REENTRANT -fno-strict-aliasing -I/usr/local/include -I/usr/sfw/include -I/opt/sfw/include -I/usr/ccs/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -fPIC "-I/usr/local/lib/perl5/5.8.3/sun4-solaris-thread-multi-64int/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/local/mysql/lib/mysql:/usr/local/lib:/usr/lib" /usr/local/bin/perl myld gcc -G -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib -R/usr/local/lib -R/usr/lib -L/usr/lib -R/usr/openwin/lib -L/usr/openwin/lib -L /usr/local/ssl/lib/ -R/usr/local/ssl/lib/ -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
ld: fatal: file dbdimp.o: wrong ELF class: ELFCLASS64
ld: fatal: File processing errors. No output written to blib/arch/auto/DBD/mysql/mysql.so
collect2: ld returned 1 exit status
make: *** blib/arch/auto/DBD/mysql/mysql.so Error 1

Any help would be extremely appreciated
thanks,
--DawgTool

In reply to Perl 5.8 and MySql (64 bit) by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.