FreeTDS Development Group

[Bob Hetzel <beh AT case.edu>]

Hi,

I've downloaded freetds 0.64 yesterday and am having trouble making a
connection to a MS Sql 2005 server.  The server has a self-signed
certificate installed and is set to force encryption.
The client is OpenSuse 10.2 linux, with openssl.

Any help that can be offered would be greatly appreciated.

   Bob
--

I used the following line to configure it
./configure --with-tdsver=8.0 -with-openssl=/usr/share/ssl

--

The freetds.conf file has the following info
[Pinealdb]
        host = pineal.case.edu
        port = 1433
        tds version = 8.0
        connect timeout = 15
        timeout = 60

--

Using tsql gives me the following...

tsql -S Pinealdb -U sympa_listmgr -P (password deleted from e-mail)

locale is
"LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C"
locale charset is "UTF-8"
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
Thu May 10 13:09:14 EDT 2007
--
13:07:17.461641 9754 (util.c:288):Starting log file for FreeTDS 0.64
        on 2007-05-10 13:07:17 with debug flags 0xffff.
13:07:17.461846 9754 (iconv.c:195):names for ISO-8859-1: ISO-8859-1
13:07:17.461867 9754 (iconv.c:195):names for UTF-8: UTF-8
13:07:17.461880 9754 (iconv.c:195):names for UCS-2LE: UCS-2LE
13:07:17.461893 9754 (iconv.c:195):names for UCS-2BE: UCS-2BE
13:07:17.461906 9754 (iconv.c:361):iconv to convert client-side data to
the "UTF-8" character set
13:07:17.461947 9754 (iconv.c:514):tds_iconv_info_init: converting
"UTF-8"->"UCS-2LE"
13:07:17.461981 9754 (iconv.c:514):tds_iconv_info_init: converting
"ISO-8859-1"-> "UCS-2LE"
13:07:17.462002 9754 (net.c:168):Connecting to 129.22.208.111 port 1433.
13:07:17.462300 9754 (net.c:673):Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 1a 26 00 00            -                        |.&..|

13:07:17.462904 9754 (net.c:446):Received header
0000 04 01 00 25 00 00 01 00-                        |...%....|

13:07:17.462931 9754 (net.c:542):Received packet
0000 00 00 15 00 06 01 00 1b-00 01 02 00 1c 00 01 03 |........ ........|
0010 00 1d 00 00 ff 09 00 0b-e2 00 00 03 00          |........ .....|

13:07:17.462960 9754 (login.c:873):detected flag 3
13:07:17.463579 9754 (net.c:883):in tds_push_func
13:07:17.463617 9754 (net.c:842):in tds_pull_func
13:07:17.463630 9754 (net.c:673):Sending packet
0000 12 01 00 41 00 00 00 00-16 03 01 00 34 01 00 00 |...A.... ....4...|
0010 30 03 01 46 43 51 45 87-7a 19 b0 78 4f 5a 69 a3 |0..FCQE. z..xOZi.|
0020 e3 ed e8 f1 d4 19 8b c4-49 a1 6e a7 7d 43 0a c3 |........ I.n.}C..|
0030 1d bd d3 00 00 08 00 09-00 03 00 06 00 12 02 01 |........ ........|
0040 00                     -                        |.|

13:07:17.463706 9754 (net.c:855):have 0
13:07:17.463720 9754 (net.c:859):before read
13:07:17.464154 9754 (net.c:446):Received header
0000 12 01 02 62 00 00 00 00-                        |...b....|

13:07:17.464184 9754 (net.c:542):Received packet
0000 16 03 01 02 55 02 00 00-46 03 01 46 43 51 8d 41 |....U... F..FCQ.A|
0010 5c b9 a3 30 94 f0 e8 fb-ef b3 e2 84 f8 34 a9 c0 |\..0.... .....4..|
0020 00 9f ec 14 a5 7e a4 17-28 1a 45 20 1c 18 00 00 |.....~.. (.E ....|
0030 13 b0 7f 2a 12 0d 88 db-39 d7 85 e9 29 b6 3c 2b |...*.... 9...).<+|
0040 d4 74 57 ff 48 f0 89 35-ba 0e cd d2 00 09 00 0b |.tW.H..5 ........|
0050 00 02 03 00 02 00 00 01-fd 30 82 01 f9 30 82 01 |........ .0...0..|
0060 62 a0 03 02 01 02 02 10-42 cb 7e a1 62 c7 46 94 |b....... B.~.b.F.|
0070 4a 1d 9c 99 f0 d1 b7 41-30 0d 06 09 2a 86 48 86 |J......A 0...*.H.|
0080 f7 0d 01 01 05 05 00 30-3b 31 39 30 37 06 03 55 |.......0 ;1907..U|
0090 04 03 1e 30 00 53 00 53-00 4c 00 5f 00 53 00 65 |...0.S.S .L._.S.e|
00a0 00 6c 00 66 00 5f 00 53-00 69 00 67 00 6e 00 65 |.l.f._.S .i.g.n.e|
00b0 00 64 00 5f 00 46 00 61-00 6c 00 6c 00 62 00 61 |.d._.F.a .l.l.b.a|
00c0 00 63 00 6b 30 1e 17 0d-30 37 30 34 31 37 31 38 |.c.k0... 07041718|
00d0 33 37 33 32 5a 17 0d 33-37 30 34 31 37 31 38 33 |3732Z..3 70417183|
00e0 37 33 32 5a 30 3b 31 39-30 37 06 03 55 04 03 1e |732Z0;19 07..U...|
00f0 30 00 53 00 53 00 4c 00-5f 00 53 00 65 00 6c 00 |0.S.S.L. _.S.e.l.|
0100 66 00 5f 00 53 00 69 00-67 00 6e 00 65 00 64 00 |f._.S.i. g.n.e.d.|
0110 5f 00 46 00 61 00 6c 00-6c 00 62 00 61 00 63 00 |_.F.a.l. l.b.a.c.|
0120 6b 30 81 9f 30 0d 06 09-2a 86 48 86 f7 0d 01 01 |k0..0... *.H.....|
0130 01 05 00 03 81 8d 00 30-81 89 02 81 81 00 c8 65 |.......0 .......e|
0140 ff da 28 60 1b 08 2d 72-ac fa 9d b9 ce 91 c5 e1 |..(`..-r ........|
0150 4a b1 33 60 e8 19 58 e4-7d 21 f6 1f cb 4f 75 4a |J.3`..X. }!...OuJ|
0160 0a a4 d8 80 cb 4d b6 93-65 1d 6a 1e ba 2d 26 a0 |.....M.. e.j..-&.|
0170 47 5c 2b c8 67 b3 09 f0-6d c3 9e 77 64 9c bf 4b |G\+.g... m..wd..K|
0180 f6 c2 d8 54 4a 04 d6 68-f9 02 d0 00 63 88 cd 1c |...TJ..h ....c...|
0190 b6 f0 01 52 d2 fb ef 42-0f 1a 2a 90 43 b0 c9 42 |...R...B ..*.C..B|
01a0 31 0e ce 61 e0 2c be 48-90 14 17 1e 57 cd 66 cc |1..a.,.H ....W.f.|
01b0 51 29 29 b2 4d ab 94 64-6b 98 17 9b 1d f5 02 03 |Q)).M..d k.......|
01c0 01 00 01 30 0d 06 09 2a-86 48 86 f7 0d 01 01 05 |...0...* .H......|
01d0 05 00 03 81 81 00 35 9e-dd 86 e1 51 e8 76 c6 b0 |......5. ...Q.v..|
01e0 ac fe de c0 07 9f 2f e0-d2 b4 0d 96 6b 71 38 e6 |....../. ....kq8.|
01f0 a7 2b 06 2f b2 97 2c 92-d0 55 ad 39 16 56 1d b7 |.+./..,. .U.9.V..|
0200 11 9b fe 3b f2 da 32 52-48 c7 f8 d6 41 12 f5 13 |...;..2R H...A...|
0210 ae 12 b6 4e 8c 54 96 c2-11 ce d9 e4 a4 87 8d 83 |...N.T.. ........|
0220 47 74 23 d4 fb d4 89 e4-68 2f 78 08 b5 e8 01 ae |Gt#..... h/x.....|
0230 5f 9d 0f 91 aa 2c 30 db-05 02 65 8a 53 e4 ed f5 |_....,0. ..e.S...|
0240 66 75 4f 60 93 f7 ab c7-48 38 d1 f1 4e e7 97 6f |fuO`.... H8..N..o|
0250 46 1a 6e 44 b1 36 0e 00-00 00                   |F.nD.6.. ..|

13:07:17.464508 9754 (net.c:862):after read
13:07:17.464522 9754 (net.c:855):have 602
13:07:17.464534 9754 (net.c:866):read 5 bytes
13:07:17.464548 9754 (net.c:842):in tds_pull_func
13:07:17.464560 9754 (net.c:855):have 597
13:07:17.464573 9754 (net.c:866):read 597 bytes
13:07:17.465194 9754 (net.c:883):in tds_push_func
13:07:17.465226 9754 (net.c:673):Sending packet
0000 12 01 00 c6 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|
0010 82 00 80 a0 35 63 65 4e-d0 5d 52 0d c3 1a 58 26 |....5ceN .]R...X&|
0020 6a b4 4c b2 89 ee 78 18-87 f4 57 c6 cb ce b0 62 |j.L...x. ..W....b|
0030 f2 52 a8 55 fb 80 22 fb-37 57 83 24 0f 35 72 dd |.R.U..". 7W.$.5r.|
0040 3f a3 de 18 b2 0b 9e 66-1f b1 28 da 38 5a 47 b4 |?......f ..(.8ZG.|
0050 1b a3 dc 81 70 10 80 e0-3a 17 0b 25 03 3d 8d e5 |....p... :..%.=..|
0060 12 bb 61 f1 1d ae 74 8a-1e eb 42 09 f0 66 9b 9e |..a...t. ..B..f..|
0070 fe 11 62 2b 72 d1 4d 85-9b 95 b6 69 f4 e8 eb 76 |..b+r.M. ...i...v|
0080 da ed 2f 3a b7 b1 03 56-49 71 36 da 4f f8 7f a7 |../:...V Iq6.O...|
0090 5f 02 29 14 03 01 00 01-01 16 03 01 00 28 d9 44 |_.)..... .....(.D|
00a0 fb 1c a5 3c be 25 7b a7-53 87 36 ed 2b 50 e4 9e |...<.%{. S.6.+P..|
00b0 df bf a2 79 a8 9c c5 4d-67 08 56 9c 5b a9 4a c1 |...y...M g.V.[.J.|
00c0 47 c8 e8 7c ce a6      -                        |G..|..|

13:07:17.465368 9754 (net.c:842):in tds_pull_func
13:07:17.465383 9754 (net.c:855):have 0
13:07:17.465395 9754 (net.c:859):before read
13:07:17.469777 9754 (net.c:446):Received header
0000 12 01 00 3b 00 00 00 00-                        |...;....|

13:07:17.469803 9754 (net.c:542):Received packet
0000 14 03 01 00 01 01 16 03-01 00 28 fe 72 f0 a2 bb |........ ..(.r...|
0010 f1 d7 25 62 39 df 62 dc-c3 45 94 68 54 04 40 97 |..%b9.b. .E.hT.@.|
0020 ec 99 87 21 b7 3c 42 30-02 e9 86 f4 96 20 b1 28 |...!.<B0 ..... .(|
0030 c1 a2 b3               -                        |...|

13:07:17.469840 9754 (net.c:862):after read
13:07:17.469852 9754 (net.c:855):have 51
13:07:17.469865 9754 (net.c:866):read 5 bytes
13:07:17.469878 9754 (net.c:842):in tds_pull_func
13:07:17.469890 9754 (net.c:855):have 46
13:07:17.469902 9754 (net.c:866):read 1 bytes
13:07:17.469948 9754 (net.c:842):in tds_pull_func
13:07:17.469961 9754 (net.c:855):have 45
13:07:17.469974 9754 (net.c:866):read 5 bytes
13:07:17.469986 9754 (net.c:842):in tds_pull_func
13:07:17.469998 9754 (net.c:855):have 40
13:07:17.470011 9754 (net.c:866):read 40 bytes
13:07:17.470052 9754 (net.c:1144):handshake succeeded!!
13:07:17.470093 9754 (write.c:134):tds_put_string converting 8 bytes of
"ntis-new"
13:07:17.470137 9754 (write.c:162):tds_put_string wrote 16 bytes
13:07:17.470151 9754 (write.c:134):tds_put_string converting 13 bytes of
"sympa_listmgr"
13:07:17.470166 9754 (write.c:162):tds_put_string wrote 26 bytes
13:07:17.470180 9754 (write.c:134):tds_put_string converting 4 bytes of
"TSQL"
13:07:17.470194 9754 (write.c:162):tds_put_string wrote 8 bytes
13:07:17.470207 9754 (write.c:134):tds_put_string converting 8 bytes of
"Pinealdb"
13:07:17.470220 9754 (write.c:162):tds_put_string wrote 16 bytes
13:07:17.470233 9754 (write.c:134):tds_put_string converting 11 bytes of
"TDS-Library"
13:07:17.470247 9754 (write.c:162):tds_put_string wrote 22 bytes
13:07:17.470260 9754 (write.c:134):tds_put_string converting 10 bytes of
"us_english"
13:07:17.470302 9754 (write.c:162):tds_put_string wrote 20 bytes
13:07:17.470316 9754 (write.c:162):tds_put_string wrote 0 bytes
13:07:17.470380 9754 (token.c:310):tds_process_login_tokens()
13:07:17.470401 9754 (net.c:842):in tds_pull_func
13:07:32.471793 9754 (net.c:354):exceeded query timeout: 15
13:07:47.471849 9754 (net.c:354):exceeded query timeout: 15
13:08:02.471911 9754 (net.c:354):exceeded query timeout: 15
13:08:17.471963 9754 (net.c:354):exceeded query timeout: 15
13:08:32.472019 9754 (net.c:354):exceeded query timeout: 15
13:08:47.472079 9754 (net.c:354):exceeded query timeout: 15
13:09:02.472133 9754 (net.c:354):exceeded query timeout: 15
13:09:14.195483 9754 (token.c:2252):tds_client_msg: #20004: "Read from
SQL server failed.".  Connection state is now 0.
13:09:14.195587 9754 (util.c:119):Changing query state from IDLE to DEAD
13:09:14.195612 9754 (token.c:314):looking for login token, got  0()
13:09:14.195632 9754 (token.c:105):tds_process_default_tokens() marker
is 0()
13:09:14.195645 9754 (token.c:108):leaving tds_process_default_tokens()
connection dead
13:09:14.195658 9754 (util.c:119):Changing query state from DEAD to DEAD
13:09:14.195685 9754 (token.c:2252):tds_client_msg: #20014: "Login
incorrect.".
 Connection state is now 4.
13:09:14.195708 9754 (mem.c:519):tds_free_all_results()