Re: What does this error message mean (db-library)?

Michael Peppler <[email protected]> Mon, 6 Apr 2009 19:35:25 +0200
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
--Apple-Mail-78-886604134
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: 7bit

The only thing that I can think of is that these logins have different  
rights, possibly due to SElinux settings.

Michael


On Apr 6, 2009, at 3:51 PM, Wechsler, Steven wrote:

> For what it's worth:
>
> We ended up rewriting it in DBI, which works fine.
>
> However, in testing, I noted that DBLibrary scripts have the same  
> problem with certain linux logins, even without using Sudo, and even  
> if I set all environment variables the same for the non-working  
> logins as the working logins have.
>
> Any ideas?
>
> Steve
>
> From: Michael Peppler [mailto:[email protected]]
> Sent: Sunday, April 05, 2009 8:16 AM
> To: Michael Peppler
> Cc: Wechsler, Steven; [email protected]
> Subject: Re: What does this error message mean (db-library)?
>
> Actually, now that I think about this - it may be that DBlib.so is  
> linked with the kerberos library (libskrb.so, or something like  
> that) in the Sybase libs. Some versions of sybperl always included  
> this file in the link line, but it's only needed for the Ctlib side,  
> and even there it should normally get loaded dynamically at run-time.
>
> Michael
>
>
> On Apr 5, 2009, at 2:03 PM, Michael Peppler wrote:
>
>> Try using sudo -u -H
>>
>> I'm guessing you're getting a different version of glibc under the  
>> sudo environment for some reason, or maybe there is something like  
>> SElinux that is playing games...
>>
>> Michael
>>
>>
>> On Mar 31, 2009, at 10:02 PM, Wechsler, Steven wrote:
>>
>>> This script runs fine when I run it as my own ID or as the Sybase  
>>> user, but when I run it as a different user, using sudo -u sybase,  
>>> I get this error:
>>>
>>> /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.5/ 
>>> i386-linux-thread-multi/auto/Sybase/DBlib/DBlib.so: symbol dbopen,  
>>> version FLSSL_1 not defined in file libsybdb.so with link time  
>>> reference Return from switch_default_db.pl was 32512
>>>
>>> I have never seen this particular error before, and neither has  
>>> Google, apparently (except for one non-English article).
>>>
>>> Thanks,
>>>
>>> Steve
>>>

Michael Peppler              -                    Peppler Consulting  
SaRL
[email protected]         -                     http://www.peppler.org
Sybase DBA/Developer         -      TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ          -      http://www.peppler.org/FAQ/linux.html




--Apple-Mail-78-886604134
Content-Type: text/html;
	charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; ">The only thing that I can think =
of is that these logins have different rights, possibly due to SElinux =
settings.<div><br></div><div>Michael</div><div><br></div><div><br><div><di=
v>On Apr 6, 2009, at 3:51 PM, Wechsler, Steven wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"> <div =
style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space"> <div dir=3D"ltr" =
align=3D"left"><font color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009">For what it's worth:</span></font></div> =
<div dir=3D"ltr" align=3D"left"><font color=3D"#0000ff" size=3D"2" =
face=3D"Arial"><span =
class=3D"977254913-06042009"></span></font>&nbsp;</div> <div dir=3D"ltr" =
align=3D"left"><font color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009">We ended up rewriting it&nbsp;in DBI, which =
works fine.</span></font></div> <div dir=3D"ltr" align=3D"left"><font =
color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009"></span></font>&nbsp;</div> <div dir=3D"ltr" =
align=3D"left"><font color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009">However, in testing, I noted that DBLibrary =
scripts have the same problem with certain linux logins, even without =
using Sudo, and even if I set all environment variables the same for the =
non-working logins as the working logins have.</span></font></div> <div =
dir=3D"ltr" align=3D"left"><font color=3D"#0000ff" size=3D"2" =
face=3D"Arial"><span =
class=3D"977254913-06042009"></span></font>&nbsp;</div> <div dir=3D"ltr" =
align=3D"left"><font color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009">Any ideas?</span></font></div> <div =
dir=3D"ltr" align=3D"left"><font color=3D"#0000ff" size=3D"2" =
face=3D"Arial"><span =
class=3D"977254913-06042009"></span></font>&nbsp;</div> <div dir=3D"ltr" =
align=3D"left"><font color=3D"#0000ff" size=3D"2" face=3D"Arial"><span =
class=3D"977254913-06042009">Steve</span></font></div><br> <div =
dir=3D"ltr" lang=3D"en-us" class=3D"OutlookMessageHeader" align=3D"left"> =
<hr tabindex=3D"-1"> <font size=3D"2" face=3D"Tahoma"><b>From:</b> =
Michael Peppler [<a =
href=3D"mailto:[email protected]">mailto:[email protected]</a>] =
<br><b>Sent:</b> Sunday, April 05, 2009 8:16 AM<br><b>To:</b> Michael =
Peppler<br><b>Cc:</b> Wechsler, Steven; <a =
href=3D"mailto:[email protected]">[email protected]</a><br><b>Subj=
ect:</b> Re: What does this error message mean =
(db-library)?<br></font><br></div> <div></div>Actually, now that I think =
about this - it may be that DBlib.so is linked with the kerberos library =
(libskrb.so, or something like that) in the Sybase libs. Some versions =
of sybperl always included this file in the link line, but it's only =
needed for the Ctlib side, and even there it should normally get loaded =
dynamically at run-time. <div><br></div> <div>Michael</div> =
<div><br></div> <div><br> <div> <div>On Apr 5, 2009, at 2:03 PM, Michael =
Peppler wrote:</div><br class=3D"Apple-interchange-newline"> <blockquote =
type=3D"cite">  <div style=3D"WORD-WRAP: break-word; -webkit-nbsp-mode: =
space; -webkit-line-break: after-white-space">Try   using sudo -u -H  =
<div><br></div>  <div>I'm guessing you're getting a different version of =
glibc under the sudo   environment for some reason, or maybe there is =
something like SElinux that is   playing games...</div>  <div><br></div> =
 <div>Michael</div>  <div><br></div>  <div><br>  <div>  <div>On Mar 31, =
2009, at 10:02 PM, Wechsler, Steven wrote:</div><br =
class=3D"Apple-interchange-newline">  <blockquote type=3D"cite">    =
<div><!-- Converted from text/rtf format --><p><font size=3D"2" =
face=3D"Arial">This script runs fine when I run it as my own ID     or =
as the Sybase user, but when I run it as a different user, using sudo -u =
    sybase, I get this error:</font></p><p><font size=3D"2" =
face=3D"Arial">/usr/bin/perl: relocation error:     =
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/Sybase/DBlib/D=
Blib.so:     symbol dbopen, version FLSSL_1 not defined in file =
libsybdb.so with link     time reference Return from =
switch_default_db.pl was 32512</font></p><p><font size=3D"2" =
face=3D"Arial">I have never seen this particular error before,     and =
neither has Google, apparently (except for one non-English     =
article).</font></p><p><font size=3D"2" face=3D"Arial">Thanks,</font> =
</p><p><font size=3D"2" face=3D"Arial">Steve</font>   =
</p></div></blockquote></div></div></div></blockquote></div></div></div></=
blockquote></div><br><div apple-content-edited=3D"true"> <span =
class=3D"Apple-style-span" style=3D"border-collapse: separate; color: =
rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: =
normal; font-variant: normal; font-weight: normal; letter-spacing: =
normal; line-height: normal; orphans: 2; text-align: auto; text-indent: =
0px; text-transform: none; white-space: normal; widows: 2; word-spacing: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0; "><div style=3D"word-wrap: =
break-word; -webkit-nbsp-mode: space; -webkit-line-break: =
after-white-space; "><div><div>Michael Peppler &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp;- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp;Peppler Consulting =
SaRL</div><div>[email protected] &nbsp; &nbsp; &nbsp; &nbsp; - &nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a =
href=3D"http://www.peppler.org">http://www.peppler.org</a></div><div>Sybas=
e DBA/Developer &nbsp; &nbsp; &nbsp; &nbsp; - &nbsp; &nbsp; =
&nbsp;TeamSybase: <a =
href=3D"http://www.teamsybase.com">http://www.teamsybase.com</a></div><div=
>Sybase on Linux FAQ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- &nbsp; &nbsp; =
&nbsp;<a =
href=3D"http://www.peppler.org/FAQ/linux.html">http://www.peppler.org/FAQ/=
linux.html</a></div><div><br></div></div></div></span><br =
class=3D"Apple-interchange-newline"> </div><br></div></body></html>=

--Apple-Mail-78-886604134--