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

------=_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 [at] mrcabq.com


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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
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">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">


<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml [at] 01C4B74B.3289FA30">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
mso-believe-normal-left:yes;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
color:black;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]--><![if mso 9]>
<style>
p.MsoNormal
{margin-left:7.5pt;}
</style>
<![endif]><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

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

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>Good =
morning.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>When I tried to make DBD::mysql =
on my Dell
Precision workstation running:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>Linux localhost.localdomain =
2.4.21-20.EL
#1 SMP Wed Aug 18 </span></font><st1:time Hour=3D"20" =
Minute=3D"34"><font
color=3Dblack><span style=3D'color:black'>20:34:58 =
EDT</span></font></st1:time><font
color=3Dblack><span style=3D'color:black'> 2004 x86_64 x86_64 x86_64 =
GNU/Linux<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>And mysql server version: =
4.0.21-standard<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>I get the following =
error:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'>cc =
-c<span
style=3D'mso-spacerun:yes'> 
</span>-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<span style=3D'mso-spacerun:yes'>  
</span>-DVERSION=3D\"2.9004\" =
-DXS_VERSION=3D\"2.9004\" -fPIC
"-I/usr/lib64/perl5/5.8.0/x86_64-linux-thread-multi/CORE"<span
style=3D'mso-spacerun:yes'>   =
</span>mysql.c<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'>Running
Mkbootstrap for DBD::mysql ()<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'>chmod 644
mysql.bs<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span style=3D'font-size:12.0pt;color:black'>rm =
-f
blib/arch/auto/DBD/mysql/mysql.so<o:p></o:p></span></font></p>

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

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
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<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:7.5pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:black'>/usr/local/lib/libmys qlclient.a:
could not read symbols: Bad value<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

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

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'>Thanks for any help you can =
provide and
have a great day.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black'><o:p> </o:p></span></font></p=
>

<div>

<p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>Fred =
Magee<o:p></o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>ATK =
</span></font><st1:place><font
color=3Dblack><span =
style=3D'color:black;mso-no-proof:yes'>Mission</span></font></st1:place><=
font
color=3Dblack><span style=3D'color:black;mso-no-proof:yes'> =
Research<o:p></o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>(505 )768-7783<o:p=
></o:p></span></font></p>

<p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:black;mso-no-proof:yes'>fred .magee [at] mrcabq=
..com<o:p></o:p></span></font></p>

</div>

<p><font size=3D2 color=3D"#0033cc" face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:#0033CC'> <o:p></o:p></span></font></p>

</div>

</body>

</html>

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

------=_NextPart_000_0001_01C4B74B.32EBC940--
Fred Magee [ Do, 21 Oktober 2004 17:51 ] [ ID #440690 ]

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

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 [at] m .gmane.org
Jochen Wiedmann [ Do, 21 Oktober 2004 18:52 ] [ ID #440806 ]
Datenbanken » gmane.comp.db.mysql.perl » Problems installing DBD::mysql-2.9004 under 64 bit linux

Vorheriges Thema: $dbh->last_insert_id() support?
Nächstes Thema: Mysql DBD drivers on Hpux