Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase Connection - trouble without protocol fallback

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Fredy Paquet <fredy AT opag.ch>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: Frediano Ziglio <freddy77 AT gmail.com>
  • Subject: Re: [freetds] Sybase Connection - trouble without protocol fallback
  • Date: Sat, 08 Jul 2017 11:54:08 +0200

Hello Frediano

Great job - ALL connection tests with Sybase 15.7.0 are successful.

Many thanks
fp

--- Test results (fisql, fresh git pull, master branch)

No encryption setting in freetds.conf (Default encryption):

Default encryption, with protocol fallback:

net.c:362:Connecting with protocol version 7.3
login.c:532:login packet rejected
net.c:362:Connecting with protocol version 7.2
login.c:532:login packet rejected
net.c:362:Connecting with protocol version 7.1
login.c:532:login packet rejected
net.c:362:Connecting with protocol version 7.0
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
net.c:362:Connecting with protocol version 5.0
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

Default encryption, without fallback:

net.c:362:Connecting with protocol version 5.0
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

No protocol fallback, with encryption = off

net.c:362:Connecting with protocol version 5.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 67 75-72 75 67 75 72 75 00 00 |......gu ruguru..|
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

No protocol fallback, with encryption = request

net.c:362:Connecting with protocol version 5.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 00 00-00 00 00 00 00 00 00 00 |........ ........|
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

No protocol fallback, with encryption = require

net.c:362:Connecting with protocol version 5.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 00 00-00 00 00 00 00 00 00 00 |........ ........|
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

With fallback and encryption = off

net.c:362:Connecting with protocol version 7.3
net.c:362:Connecting with protocol version 7.2
net.c:362:Connecting with protocol version 7.1
net.c:362:Connecting with protocol version 7.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 67 75-72 75 67 75 72 75 00 00 |......gu ruguru..|
net.c:362:Connecting with protocol version 5.0
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

With fallback and encryption = request

net.c:362:Connecting with protocol version 7.3
net.c:362:Connecting with protocol version 7.2
net.c:362:Connecting with protocol version 7.1
net.c:362:Connecting with protocol version 7.0
net.c:362:Connecting with protocol version 5.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 00 00-00 00 00 00 00 00 00 00 |........ ........|
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS

With fallback and encryption = require

net.c:362:Connecting with protocol version 7.3
net.c:362:Connecting with protocol version 7.2
net.c:362:Connecting with protocol version 7.1
net.c:362:Connecting with protocol version 7.0
net.c:362:Connecting with protocol version 5.0
0020 00 00 00 00 00 00 0b 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 00 00-00 00 00 00 00 00 00 00 |........ ........|
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS


On Wed, 2017-07-05 at 11:44 +0200, Fredy Paquet wrote:
> So this issue is also solved,
> i will verify correct operation with Sybase 15.7 next weekend.
>
> Thank you
> fp

--
Fredy Paquet
Mitglied der Geschäftsleitung
OPAG Informatik AG
Fabrikmattenweg 11
CH-4144 Arlesheim
http://www.opag.ch
Tel. ++41 61 716 92 22
Fax. ++41 61 716 92 29





Archive powered by MHonArc 2.6.24.

Top of Page