Hi Connie,
Looks like you have hit http://bugs.mysql.com/bug.php?id=18091 (which
hasn't been fixed yet) potential solutions are documented there.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Logg, Connie A. [mailto:[EMAIL PROTECTED]
Sent: Thursday, 11 May 2006 5:47 AM
To: mysql@lists.mysql.com
Subject: Installing DBD::mysql - problems
I am trying to install DBD::mysql on the following node:
[EMAIL PROTECTED] cal]# uname -a
Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64
x86_64 x86_64 GNU/Linux
[EMAIL PROTECTED] cal]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 3)
[EMAIL PROTECTED] cal]#
I have the following rpms installed
[EMAIL PROTECTED] cal]# rpm -qa | grep -i mysql
MySQL-devel-standard-5.0.20a-0.rhel4
MySQL-client-standard-5.0.20a-0.rhel4
MySQL-shared-standard-5.0.20a-0.rhel4
MySQL-server-standard-5.0.20a-0.rhel4
And DBI installed ok.
[EMAIL PROTECTED] utils]$ ./seeperlmods
Archive::Tar -- 1.29
CPAN -- 1.87
Compress::Zlib -- 1.41
Cwd -- 3.17
DBD::Multiplex -- 1.98
DBI -- 1.50 <------------------------------
DBI::Shell -- 11.93
Data::ShowTable -- undef
Digest::MD5 -- 2.36
IO::Tee -- 0.64
IO::Zlib -- 1.04
Net::Daemon -- 0.39
Net::Telnet -- 3.03
Perl -- 5.8.5
RPC::PlServer -- 0.2018
Storable -- 2.15
Term::ReadKey -- 2.30
Term::ReadLine -- 1.01
Text::Reform -- 1.11
When I try to install the DBD::mysql I get errors:
[EMAIL PROTECTED] DBD-mysql-3.0002_5]# /usr/bin/perl Makefile.PL
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/include/mysql -g -pipe -m64
embedded (mysql_config) =
libs (mysql_config) = -L/usr/lib64/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ps-protocol (default ) = 1
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Multiple copies of Driver.xst found in:
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ /
usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at
Makefile.PL line 741
Using DBI 1.50 (for perl 5.008005 on x86_64-linux-thread-multi)
installed in /usr/lib64/perl5/site_perl/5.8.5/
x86_64-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
....probably ok as it picked one
When I run make:
[EMAIL PROTECTED] DBD-mysql-3.0002_5]# make
gcc -c
-I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/
-I/usr/include/mysql -g -pipe -
m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE
-DDEBUGGING -fno-strict-aliasing -pipe -I/usr
/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\"
3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" dbdimp.
c
gcc -c
-I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/
-I/usr/include/mysql -g -pipe -
m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE
-DDEBUGGING -fno-strict-aliasing -pipe -I/usr
/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\"
3.0002_5\" -DXS_VERSION=\"3.0002_5\" -fPIC
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
/usr/bin/perl myld gcc -shared dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib64/mysql -l
mysqlclient -lz -lcrypt -lnsl -lm
/usr/bin/ld: /usr/lib64/mysql/libmysqlclient.a(libmysql.o): relocation
R_X86_64_32 against `a local symbol' ca
n not be used when making a shared object; recompile with -fPIC
/usr/lib64/mysql/libmysqlclient.a: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
[EMAIL PROTECTED] DBD-mysql-3.0002_5]#
I tried using /usr/bin/perl Makefile.PL --cflags fPIC
And doing the make afterword, but that failed miserably with many many
errors
....snip
dbdimp.c:3017: error: dereferencing pointer to incomplete type
dbdimp.c: In function `mysql_describe':
dbdimp.c:3126: error: dereferencing pointer to incomplete type
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3151: error: `MYSQL_ROW' undeclared (first use in this
function)
dbdimp.c:3151: error: syntax error before "cols"
dbdimp.c:3156: error: dereferencing pointer to incomplete type
I am at a loss how to resolve this.
I would appreciate any guidance. I have also tried DBD-mysql-3.0002_4
and DBD-mysql-3.0002_3
Connie Logg
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
"Happiness is found along the way, not at the end of the road, and 'IF'
is the middle word in life."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
