Re: Sybase Connection - trouble without protocol fallback

Fredy Paquet <[email protected]> Sat, 08 Jul 2017 11:54:08 +0200
Newsgroups gmane.comp.db.tds.freetds
Organization OPAG Informatik AG
Message-ID <[email protected]> 
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

_______________________________________________
FreeTDS mailing list
[email protected]
https://lists.ibiblio.org/mailman/listinfo/freetds