FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Craig Berry
> Sent: Monday, October 30, 2006 6:44 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Sybase.so RPATH for DBD::Sybase
>  
> On Monday, October 30, 2006, at 04:15PM, "Lowden, James K" 
> <james.k.lowden AT alliancebernstein.com> wrote:
> >I want to add /usr/local to the Sybase.so RPATH.  
> 
> Have you tried generating your Makefile with something like:
> 
> $ perl Makefile.PL LDDLFLAGS='-Wl,-R/usr/pkg/lib,-R/usr/local/lib
> -pthread --whole-archive -shared -L/usr/pkg/lib'

Thanks.  That didn't actually work, but I got closer patching Makefile.PL 
thus:

--- .old/Makefile.PL    2005-04-09 05:02:35.000000000 -0400
+++ ./Makefile.PL       2006-11-06 14:48:12.000000000 -0500
@@ -29,9 +29,9 @@
 configPwd();

 my $lddlflags = $Config{lddlflags};
-$lddlflags = "-L$SYBASE/lib $lddlflags" unless $^O eq 'VMS';
+$lddlflags = "-L$SYBASE/lib -Wl,-R$SYBASE/lib $lddlflags" unless $^O eq 
'VMS';
 my $ldflags = $Config{ldflags};
-$ldflags = "-L$SYBASE/lib $ldflags" unless $^O eq 'VMS';
+$ldflags = "-L$SYBASE/lib -Wl,-R$SYBASE/lib $ldflags" unless $^O eq 'VMS';


 WriteMakefile('NAME'         => 'DBD::Sybase',

That yields a useable Sybase.so.  At least, it links and starts to run.

Problem now is it dies in a very strange way: the username & password aren't 
being passed from Perl to syb_db_login, or something like that. Cf. log 
below.  If I use TDS 4.2, I see the login packet, and it lacks any username 
or password.  

Looks like gdb time....

--jkl


==log==
$ DBI_TRACE=5 TDSDUMP=stderr perl -w t/login.t                                
                                                                              
                                                 
1..4
    DBI 1.47-ithread default trace level set to 0x0/5 (pid 29759)
ok 1 - use DBI;
    syb_init() -> DBD::Sybase 1.07 initialized
    OpenClient version: ¨
ok 2 - use DBD::Sybase;
    -> DBI->connect(dbi:Sybase:server=mpquanT;database=testdb, 
ProductDevelopmen                                                             
                                                                              
                   tWeb, ****, HASH(0x804f180))
    -> DBI->install_driver(Sybase) for netbsd perl=5.008006 pid=29759 
ruid=1000                                                                     
                                                                              
            euid=1000
       install_driver: DBD::Sybase version 1.07 loaded from 
blib/lib/DBD/Sybase.                                                          
                                                                              
                      pm
    New DBI::dr (for DBD::Sybase::dr, parent=, id=)
    dbih_setup_handle(DBI::dr=HASH(0x81e1af4)=>DBI::dr=HASH(0x8247ad0), 
DBD::Syb                                                                      
                                                                              
          ase::dr, 0, Null!)
    dbih_make_com(Null!, 0, DBD::Sybase::dr, 84, 0) thr#804e000
    dbih_setup_attrib(DBI::dr=HASH(0x8247ad0), Err, Null!) SCALAR(0x81e90a8) 
(al                                                                           
                                                                              
     ready defined)
    dbih_setup_attrib(DBI::dr=HASH(0x8247ad0), State, Null!) 
SCALAR(0x81e9090) (                                                           
                                                                              
                     already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x8247ad0), Errstr, Null!) 
SCALAR(0x81e90c0)                                                             
                                                                              
                    (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x8247ad0), TraceLevel, Null!) 0 (already 
def                                                                           
                                                                              
     ined)
    dbih_setup_attrib(DBI::dr=HASH(0x8247ad0), FetchHashKeyName, Null!) 
'NAME' (                                                                      
                                                                              
          already defined)
    <- install_driver= DBI::dr=HASH(0x81e1af4)
    !! warn: 0 CLEARED by call to connect method
    -> connect for DBD::Sybase::dr (DBI::dr=HASH(0x81e1af4)~0x8247ad0 
'server=mp                                                                    
                                                                              
            quanT;database=testdb' 'ProductDevelopmentWeb' **** 
HASH(0x810698c)) thr#804e000
    New DBI::db (for DBD::Sybase::db, parent=DBI::dr=HASH(0x8247ad0), id=)
    dbih_setup_handle(DBI::db=HASH(0x8247ab8)=>DBI::db=HASH(0x81069bc), 
DBD::Syb                                                                      
                                                                              
          ase::db, 81e1848, Null!)
    dbih_make_com(DBI::dr=HASH(0x8247ad0), 8255b00, DBD::Sybase::db, 2716, 0) 
th                                                                            
                                                                              
    r#804e000
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), Err, DBI::dr=HASH(0x8247ad0)) 
SCA                                                                           
                                                                              
     LAR(0x81e9854) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), State, 
DBI::dr=HASH(0x8247ad0)) S                                                    
                                                                              
                            CALAR(0x81e98b4) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), Errstr, 
DBI::dr=HASH(0x8247ad0))                                                      
                                                                              
                           SCALAR(0x81e9884) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), TraceLevel, 
DBI::dr=HASH(0x8247ad                                                         
                                                                              
                       0)) 0 (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), FetchHashKeyName, 
DBI::dr=HASH(0x                                                               
                                                                              
                 8247ad0)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), HandleSetErr, 
DBI::dr=HASH(0x8247                                                           
                                                                              
                     ad0)) undef (not defined)
    dbih_setup_attrib(DBI::db=HASH(0x81069bc), HandleError, 
DBI::dr=HASH(0x8247a                                                          
                                                                              
                      d0)) undef (not defined)
    syb_db_login() -> using global CS_LOCALE data
util.c:292:Starting log file for FreeTDS 0.65.dev.20060920
        on 2006-11-06 15:25:51 with debug flags 0x4fff.
iconv.c:78:Using trivial iconv
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: (null)
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character 
set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:184:Connecting to 10.80.58.220 port 2500 (TDS version 7.0)
write.c:134:tds_put_string converting 16 bytes of "ntc5003.acml.com"
write.c:162:tds_put_string wrote 32 bytes
write.c:162:tds_put_string wrote 0 bytes
write.c:162:tds_put_string wrote 0 bytes
write.c:134:tds_put_string converting 7 bytes of "mpquanT"
write.c:162:tds_put_string wrote 14 bytes
write.c:134:tds_put_string converting 10 bytes of "CT-Library"
write.c:162:tds_put_string wrote 20 bytes
write.c:134:tds_put_string converting 10 bytes of "us_english"
write.c:162:tds_put_string wrote 20 bytes
write.c:162:tds_put_string wrote 0 bytes
token.c:312:tds_process_login_tokens()
net.c:471:Received header
0000 04 01 00 d8 00 00 01 00-                        |........|

net.c:551:Received packet
0000 aa c4 00 14 48 00 00 01-0e 5c 00 4c 00 6f 00 67 |....H... .\.L.o.g|
0010 00 69 00 6e 00 20 00 66-00 61 00 69 00 6c 00 65 |.i.n. .f .a.i.l.e|
0020 00 64 00 20 00 66 00 6f-00 72 00 20 00 75 00 73 |.d. .f.o .r. .u.s|
0030 00 65 00 72 00 20 00 27-00 28 00 6e 00 75 00 6c |.e.r. .' .(.n.u.l|
0040 00 6c 00 29 00 27 00 2e-00 20 00 52 00 65 00 61 |.l.).'.. . .R.e.a|
0050 00 73 00 6f 00 6e 00 3a-00 20 00 4e 00 6f 00 74 |.s.o.n.: . .N.o.t|
0060 00 20 00 61 00 73 00 73-00 6f 00 63 00 69 00 61 |. .a.s.s .o.c.i.a|
0070 00 74 00 65 00 64 00 20-00 77 00 69 00 74 00 68 |.t.e.d.  .w.i.t.h|
0080 00 20 00 61 00 20 00 74-00 72 00 75 00 73 00 74 |. .a. .t .r.u.s.t|
0090 00 65 00 64 00 20 00 53-00 51 00 4c 00 20 00 53 |.e.d. .S .Q.L. .S|
00a0 00 65 00 72 00 76 00 65-00 72 00 20 00 63 00 6f |.e.r.v.e .r. .c.o|
00b0 00 6e 00 6e 00 65 00 63-00 74 00 69 00 6f 00 6e |.n.n.e.c .t.i.o.n|
00c0 00 2e 00 00 00 00 00 fd-02 00 00 00 00 00 00 00 |........ ........|

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.