FreeTDS Development Group

["Marquess, Dustin" <Dustin.Marquess AT allegiancetelecom.com>]

All,

I've been using FreeTDS 0.53 to connect to our Netcool server, which is in
essence a hacked-up version of Sybase.  According to the server, the version
of Sybase libraries it's using is 11.1.1

I just downloaded the lastest snapshot (freetds-current) from the web page
and compiled it...  I tried connecting w/ tsql, and this is what I got:

root@dfwnocsys:/usr/local/freetds/bin$ ./tsql -S NCOMSNG -U root -P XXX
locale is "C"
charset is "646"
Msg 16323, Level 10, State 0, Server NCOMSNG, Line 0
Could not load localization information for character set 646 language
us_english

Msg 5555, Level 0, State 0, Server NCOMSNG, Line 0
parse error at line 1

Segmentation Fault (core dumped)

I'm using the defaults in freetds.conf, except I'm using tds version 5.0,
which worked fine with FreeTDS 0.53.

On the server side, this produced the following in the server's log files:

Feb 11 22:52:04 2003: CS-Library error Layer(2) Origin(4) Sev(6) 56 -
cs_locale: cslib user api layer: common library error: Failed to map a local
name to an object id!
Feb 11 22:52:04 2003: NCOMSNG: Error: 16323/10/0: Could not load
localization information for character set 646 language us_english
.
Feb 11 22:52:04 2003: /opt/Omnibus/bin/solaris2/nco_objserv (NCOMSNG): Error
: SQL Parser: parse error at line 1.
        Command: select @@spid
        Issued by: TSQL

The core file produces:

(gdb) bt
#0  0xff317a10 in tds_set_spid () from /usr/local/freetds/lib/libtds.so.2
#1  0xff317cc4 in tds_process_login_tokens () from
/usr/local/freetds/lib/libtds.so.2
#2  0xff31bd58 in tds_connect () from /usr/local/freetds/lib/libtds.so.2
#3  0x00011cf4 in _init ()

The freetds.log output (with the IP changed and the password X'd out) is:

Starting log file with debug level 99.
2003-02-11 22:52:03.600873 iconv will convert client-side data to the ""
character set
2003-02-11 22:52:03.626202 Connecting addr 10.10.1.1 port 4100 with TDS
version 5.0
Sending packet @ 2003-02-11 22:52:03.628184
0000  02 00 02 00 00 00 00 00  64 66 77 6e 6f 63 73 79   |........ dfwnocsy|
0010  73 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |s....... ........|
0020  00 00 00 00 00 00 09 72  6f 6f 74 00 00 00 00 00   |.......r oot.....|
0030  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0040  00 00 00 00 00 04 61 73  63 65 6e 64 00 00 00 00   |......XX XXXX....|
0050  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0060  00 00 00 00 06 33 37 38  37 36 00 00 00 00 00 00   |.....378 76......|
0070  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0080  00 00 00 05 02 00 06 04  08 01 00 00 00 00 00 00   |........ ........|
0090  00 00 00 00 54 53 51 4c  00 00 00 00 00 00 00 00   |....TSQL ........|
00a0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00b0  00 00 04 4e 43 4f 4d 53  4e 47 00 00 00 00 00 00   |...NCOMS NG......|
00c0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00d0  00 07 00 06 61 73 63 65  6e 64 00 00 00 00 00 00   |....XXXX XX......|
00e0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00f0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0100  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0110  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0120  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0130  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0140  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0150  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0160  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0170  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0180  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0190  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
01a0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
01b0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
01c0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
01d0  00 08 05 00 00 00 54 44  53 2d 4c 69 62 72 61 72   |......TD S-Librar|
01e0  0a 05 00 00 00 00 0c 10  75 73 5f 65 6e 67 6c 69   |........ us_engli|
01f0  73 68 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |sh...... ........|


Sending packet @ 2003-02-11 22:52:03.631056
0000  02 01 00 61 00 00 00 00  00 00 00 00 00 00 0a 00   |...a.... ........|
0010  00 00 00 00 00 00 00 00  00 00 00 00 00 36 34 36   |........ .....646|
0020  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
0030  00 00 00 00 00 00 00 00  00 00 00 03 01 35 31 32   |........ .....512|
0040  00 00 00 03 00 00 00 00  e2 00 16 01 09 00 00 06   |........ ........|
0050  6d 7f ff ff ff fe 02 09  00 00 00 00 0a 68 00 00   |m....... .....h..|
0060  00                                                 |.|


2003-02-11 22:52:03.632435 inside tds_process_login_tokens()
Received header @ 2003-02-11 22:52:03.634699
0000  0f 01 00 ad 00 00 01 00                            |........|

Received packet @ 2003-02-11 22:52:03.635612
0000  e5 00 69 00 00 3f c3 00  0a 00 00 00 00 00 52 43   |..i..?.. ......RC|

0010  6f 75 6c 64 20 6e 6f 74  20 6c 6f 61 64 20 6c 6f   |ould not  load lo|

0020  63 61 6c 69 7a 61 74 69  6f 6e 20 69 6e 66 6f 72   |calizati on infor|

0030  6d 61 74 69 6f 6e 20 66  6f 72 20 63 68 61 72 61   |mation f or chara|

0040  63 74 65 72 20 73 65 74  20 36 34 36 20 6c 61 6e   |cter set  646 lan|

0050  67 75 61 67 65 20 75 73  5f 65 6e 67 6c 69 73 68   |guage us _english|

0060  0a 07 4e 43 4f 4d 53 4e  47 00 00 00 ad 00 14 05   |..NCOMSN G.......|

0070  05 00 00 00 0a 4f 70 65  6e 53 65 72 76 65 72 05   |.....Ope nServer.|

0080  00 00 00 e2 00 16 01 09  00 00 02 61 7f ff ff ff   |........ ...a....|

0090  fe 02 09 00 00 00 00 0a  68 00 00 00 fd 00 00 00   |........ h.......|

00a0  00 00 00 00 00                                     |.....|

 

 

2003-02-11 22:52:03.636870 inside tds_process_default_tokens() marker is
e5(EED)                                  
2003-02-11 22:52:03.643804 inside tds_process_default_tokens() marker is
e2(CAPABILITY)                           
2003-02-11 22:52:03.644636 inside tds_process_default_tokens() marker is
fd(DONE)                                 
2003-02-11 22:52:03.645426 inside tds_process_end() more_results = 0,
was_cancelled = 0                           
2003-02-11 22:52:03.646201 inside tds_process_default_tokens() setting state
to COMPLETED                         
Sending packet @ 2003-02-11 22:52:03.647057

0000  0f 01 00 1b 00 00 00 00  21 00 00 00 0e 00 73 65   |........ !.....se|

0010  6c 65 63 74 20 40 40 73  70 69 64                  |lect @@s pid|

 

 

Received header @ 2003-02-11 22:52:03.649143

0000  0f 01 00 41 00 00 01 00                            |...A....|

 

 

Received packet @ 2003-02-11 22:52:03.650175

0000  e5 00 2d 00 00 15 b3 00  00 00 00 00 00 00 16 70   |..-..... .......p|

0010  61 72 73 65 20 65 72 72  6f 72 20 61 74 20 6c 69   |arse err or at li|

0020  6e 65 20 31 0a 07 4e 43  4f 4d 53 4e 47 00 00 00   |ne 1..NC OMSNG...|

0030  fd 00 10 00 02 00 00 00  00                        |........ .|

 

 

2003-02-11 22:52:03.651179 processing result tokens.  marker is  e5(EED)

2003-02-11 22:52:03.651953 inside tds_process_default_tokens() marker is
e5(EED)                                  
2003-02-11 22:52:03.658358 processing result tokens.  marker is  fd(DONE)

2003-02-11 22:52:03.659187 inside tds_process_end() more_results = 0,
was_cancelled = 0      


Is Netcool just proprietary enough that FreeTDS 0.61 just doesn't like
talking to it?

Thanks guys... I really appreciate all of the hard work you've put into this
thing!
-Dustin