RE: Installation problem: DBD::mysql

Apparently your perl interpreter was compiled with forte C Sun compiler
but the mysql server binaries distribution usually are compiled with
gcc. Perl and mysql must be compiled by the same compiler. See the
forums messages about problems compiling mysql DBD in Sun solaris
servers.

-----Original Message-----
From: [email protected] [mailto:[email protected]] 
Sent: Thursday, September 22, 2005 1:48 PM
To: [email protected]
Subject: Installation problem: DBD::mysql


Hi!

I would like to install the DBD for MySql on a Sun Solaris 8 system and 
I always get the following output:

"Checking if your kit is complete...
Looks good
Using DBI 1.48 (for perl 5.008007 on sun4-solaris) installed in 
/export/localhome/ekostom/apps/perl/5.8.7/lib/site_perl/5.8.7/sun4-solar
is/auto/DBI/
Writing Makefile for DBD::mysql
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/export/localhome/ekostom/apps/perl/5.8.7/lib/site_perl/5.8.7/sun4-sol
aris/auto/DBI/ 
-I/export/localhome/ekostom/apps/mysql-4.0.24/include -Xa -xstrconst -mt

-D_FORTEC_ -xarch=v9 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -pipe 
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O    
-DVERSION=\"3.0002\"  -DXS_VERSION=\"3.0002\" -fPIC 
"-I/export/localhome/ekostom/apps/perl/5.8.7/lib/5.8.7/sun4-solaris/CORE
"   
dbdimp.c
gcc: unrecognized option `-Xa'
gcc: language arch=v9 not recognized
gcc: dbdimp.c: linker input file unused since linking not done
/export/localhome/ekostom/apps/perl/5.8.7/bin/perl -p -e 
"s/~DRIVER~/mysql/g" 
/export/localhome/ekostom/apps/perl/5.8.7/lib/site_perl/5.8.7/sun4-solar
is/auto/DBI//Driver.xst 
 > mysql.xsi
/export/localhome/ekostom/apps/perl/5.8.7/bin/perl 
/export/localhome/ekostom/apps/perl/5.8.7/lib/5.8.7/ExtUtils/xsubpp  
-typemap 
/export/localhome/ekostom/apps/perl/5.8.7/lib/5.8.7/ExtUtils/typemap  
mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line
224
Warning: duplicate function definition 'rows' detected in mysql.xs, line
559
gcc -c  
-I/export/localhome/ekostom/apps/perl/5.8.7/lib/site_perl/5.8.7/sun4-sol
aris/auto/DBI/ 
-I/export/localhome/ekostom/apps/mysql-4.0.24/include -Xa -xstrconst -mt

-D_FORTEC_ -xarch=v9 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -pipe 
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O    
-DVERSION=\"3.0002\"  -DXS_VERSION=\"3.0002\" -fPIC 
"-I/export/localhome/ekostom/apps/perl/5.8.7/lib/5.8.7/sun4-solaris/CORE
"   
mysql.c
gcc: unrecognized option `-Xa'
gcc: language arch=v9 not recognized
gcc: mysql.c: linker input file unused since linking not done
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib" 
/export/localhome/ekostom/apps/perl/5.8.7/bin/perl myld gcc  -G 
-L/usr/local/lib dbdimp.o  mysql.o  -o 
blib/arch/auto/DBD/mysql/mysql.so   
-L/export/localhome/ekostom/apps/mysql-4.0.24/lib -lmysqlclient -lposix4

-lgen -lsocket -lnsl -lm  
gcc: dbdimp.o: No such file or directory
gcc: mysql.o: No such file or directory
*** Error code 1
make: Fatal error: Command failed for target 
`blib/arch/auto/DBD/mysql/mysql.so'
  /usr/ccs/bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible"


I tried to compile manually and also with CPAN:
perl -MCPAN -e shell
perl -MCPAN -e shell


The output above is after the CPAN installation.


I have already installed perl 5.8.7 and DBI 1.48.
I also have the MySQL 4.0.24 bin directory in the class.

Can you help me?
Thank you very much!
Akos Tomasits.

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/[email protected]


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]