Skip to Content.
Sympa Menu

freetds - [freetds] Upgrading from 0.53 to 0.61 snapshot

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Marquess, Dustin" <Dustin.Marquess AT allegiancetelecom.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Upgrading from 0.53 to 0.61 snapshot
  • Date: Tue, 11 Feb 2003 22:54:55 -0600

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



  • [freetds] Upgrading from 0.53 to 0.61 snapshot, Marquess, Dustin, 02/11/2003

Archive powered by MHonArc 2.6.24.

Top of Page