Problems installing DBD::mysql-2.9004 under 64 bit linux

Problems installing DBD::mysql-2.9004 under 64 bit linux

am 21.10.2004 17:51:47 von Fred Magee

------=_NextPart_000_0001_01C4B74B.32EBC940
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0002_01C4B74B.32EBC940"


------=_NextPart_001_0002_01C4B74B.32EBC940
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit


Good morning.

When I tried to make DBD::mysql on my Dell Precision workstation
running:

Linux localhost.localdomain 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT
2004 x86_64 x86_64 x86_64 GNU/Linux
And mysql server version: 4.0.21-standard

I get the following error:

cc -c -I/usr/lib64/perl5/site_perl/5.8.0/auto/DBI/ -I/usr/local/include
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe
-DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC
"-I/usr/lib64/perl5/5.8.0/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
LD_RUN_PATH="/usr/lib64" /usr/bin/perl myld gcc -shared dbdimp.o
mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib
-lmysqlclient -lz -lcrypt -lnsl -lm
/usr/bin/ld: /usr/local/lib/libmysqlclient.a(libmysql.o): relocation
R_X86_64_32S can not be used when making a shared object; recompile with
-fPIC
/usr/local/lib/libmysqlclient.a: could not read symbols: Bad value


Is this caused by the 64 bit nature of my system? How do I recompile
libmysqlclient.a(???) with the -fPIC switch? Is there an RPM version of
this that will run with Red Hat Enterprise linux?

Thanks for any help you can provide and have a great day.

Fred Magee
ATK Mission Research
(505)768-7783
fred.magee@mrcabq.com


------=_NextPart_001_0002_01C4B74B.32EBC940
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">






namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>







lang=3DEN-US
link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in;margin-left:7.5pt;margin-top:
18.75pt'>
v:src=3D"cid:image001.jpg@01C4B74B.3289FA30" v:shapes=3D"_x0000_Mail" =
width=3D0
height=3D0 class=3Dshape style=3D'display:none;width:0;height:0'>



Roman"> style=3D'font-size:12.0pt;color:black'>Good =
morning.



Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>When I tried to make DBD::mysql =
on my Dell
Precision workstation running:



Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>Linux localhost.localdomain =
2.4.21-20.EL
#1 SMP Wed Aug 18
Minute=3D"34"> color=3Dblack>20:34:58 =
EDT
color=3Dblack> 2004 x86_64 x86_64 x86_64 =
GNU/Linux



Roman"> style=3D'font-size:12.0pt;color:black'>And mysql server version: =
4.0.21-standard



Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>I get the following =
error:



Roman"> style=3D'font-size:12.0pt;color:black'>  >

color=3Dblack
face=3D"Times New Roman">cc =
-c style=3D'mso-spacerun:yes'> 
-I/usr/lib64/perl5/site_perl/5.8.0/auto/DBI/ -I/usr/local/include
-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING =
-fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 =
-I/usr/include/gdbm
-O2 -g -pipe  
-DVERSION=3D\"2.9004\" =
-DXS_VERSION=3D\"2.9004\" -fPIC
"-I/usr/lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE" style=3D'mso-spacerun:yes'>   =
mysql.c



color=3Dblack
face=3D"Times New Roman"> style=3D'font-size:12.0pt;color:black'>Running
Mkbootstrap for DBD::mysql ()



color=3Dblack
face=3D"Times New Roman"> style=3D'font-size:12.0pt;color:black'>chmod 644
mysql.bs



color=3Dblack
face=3D"Times New Roman">rm =
-f
blib/arch/auto/DBD/mysql/mysql.so



color=3Dblack
face=3D"Times New Roman"> style=3D'font-size:12.0pt;color:black'>LD_RUN_PATH=3D"/usr/lib64&quo=
t;
/usr/bin/perl myld gcc  =
-shared
dbdimp.o mysql.o  -o
blib/arch/auto/DBD/mysql/mysql.so style=3D'mso-spacerun:yes'>  
-L/usr/local/lib -lmysqlclient -lz -lcrypt -lnsl =
-lm



color=3Dblack
face=3D"Times New Roman"> style=3D'font-size:12.0pt;color:black'>/usr/bin/ld:
/usr/local/lib/libmysqlclient.a(libmysql.o): relocation R_X86_64_32S can =
not be
used when making a shared object; recompile with =
-fPIC



color=3Dblack
face=3D"Times New Roman"> style=3D'font-size:12.0pt;color:black'>/usr/local/lib/libmys qlclient.a:
could not read symbols: Bad value



Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>Is this caused by the 64 bit =
nature of my
system?  How do I recompile
libmysqlclient.a(???) with the –fPIC switch? style=3D'mso-spacerun:yes'>  Is there an RPM version of this =
that
will run with Red Hat Enterprise linux?



Roman"> style=3D'font-size:12.0pt;color:black'>  >

Roman"> style=3D'font-size:12.0pt;color:black'>Thanks for any help you can =
provide and
have a great day.



Roman"> style=3D'font-size:12.0pt;color:black'>  >



Roman"> style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>Fred =
Magee



Roman"> style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>ATK =
color=3Dblack> style=3D'color:black;mso-no-proof:yes'>Mission<=
font
color=3Dblack> =
Research



Roman"> style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>(505 )768-7783 >



Roman"> style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>fred .magee@mrcabq=
..com





style=3D'font-size:10.0pt;
font-family:Arial;color:#0033CC'> 









------=_NextPart_001_0002_01C4B74B.32EBC940--

------=_NextPart_000_0001_01C4B74B.32EBC940--

Re: Problems installing DBD::mysql-2.9004 under 64 bit linux

am 21.10.2004 18:52:10 von Jochen Wiedmann

Fred Magee wrote:

>
> Is this caused by the 64 bit nature of my system? How do I recompile
> libmysqlclient.a(???) with the –fPIC switch? Is there an RPM version
> of this that will run with Red Hat Enterprise linux?
>

I do not know this from Linux, but it sounds quite similar to the
problems with mixed binaries known from Solaris or HP/UX. Recommended
solutions is to forgen binary RPM's. Use source RPM's, and compile
everything (MySQL, Perl, DBI, and DBD::mysql) for yourself.

Jochen


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org