On 18-4-2012 20:41, Mark Rotteveel wrote:
On 18-4-2012 20:39, Mark Rotteveel wrote:
On 18-4-2012 20:30, Vlad Khorsun wrote:
In the conf file I have uncommented:
AuthClient = Srp, Win_Sspi, Legacy_Auth
This is client setting.
Am I missing an additional step to get things working with legacy
authentication?
Add Legacy_Auth to the AuthServer setting
Thanks, I had overlooked that setting, I thought both lines started with
AuthClient and had wondered why it was shown twice :|
Actually: I celebrated to soon. This solves the problem for FlameRobin,
but not for Jaybird.
It looks like Jaybird uses an authentication mechanism that is no longer
supported with Firebird 3:
Hex dump from wireshark for both Jaybird (fails) and Flamerobin
(succeeds) is attached. Most obvious thing I notice that Jaybird sends
the password in the clear and Flamerobin doesn't.
I did manage to connect using the native Jaybird (with a 2.5 client
library).
Mark
--
Mark Rotteveel
Jaybird
Connect
0000 00 1e 33 0d 06 67 54 04 a6 4a bd 3f 08 00 45 00 ..3..gT. .J.?..E.
0010 00 7c 18 46 40 00 80 06 5e e0 c0 a8 01 02 c0 a8 .|.F@... ^.......
0020 01 03 06 54 0b eb 76 be d8 57 f3 a9 60 0e 50 18 ...T..v. .W..`.P.
0030 40 29 d8 7b 00 00 00 00 00 01 00 00 00 13 00 00 @).{.... ........
0040 00 02 00 00 00 01 00 00 00 12 44 3a 5c 74 65 6d ........ ..D:\tem
0050 70 09 65 73 74 66 62 33 2e 66 64 62 20 20 00 00 p.estfb3 .fdb ..
0060 00 01 00 00 00 10 01 04 4d 61 72 6b 04 06 52 61 ........ Mark..Ra
0070 6d 6f 6e 61 06 00 00 00 00 0a 00 00 00 01 00 00 mona.... ........
0080 00 02 00 00 00 03 00 00 00 02 ........ ..
Accept
0000 54 04 a6 4a bd 3f 00 1e 33 0d 06 67 08 00 45 00 T..J.?.. 3..g..E.
0010 00 38 24 84 40 00 80 06 52 e6 c0 a8 01 03 c0 a8 .8$.@... R.......
0020 01 02 0b eb 06 54 f3 a9 60 0e 76 be d8 ab 50 18 .....T.. `.v...P.
0030 01 00 75 f4 00 00 00 00 00 03 00 00 00 0a 00 00 ..u..... ........
0040 00 01 00 00 00 03 ......
Attach
0000 00 1e 33 0d 06 67 54 04 a6 4a bd 3f 08 00 45 00 ..3..gT. .J.?..E.
0010 00 60 18 47 40 00 80 06 5e fb c0 a8 01 02 c0 a8 .`.G@... ^.......
0020 01 03 06 54 0b eb 76 be d8 ab f3 a9 60 1e 50 18 ...T..v. ....`.P.
0030 40 25 d3 a6 00 00 00 00 00 13 00 00 00 00 00 00 @%...... ........
0040 00 12 44 3a 5c 74 65 6d 70 09 65 73 74 66 62 33 ..D:\tem p.estfb3
0050 2e 66 64 62 20 20 00 00 00 14 01 1c 06 73 79 73 .fdb .. .....sys
0060 64 62 61 1d 09 6d 61 73 74 65 72 6b 65 79 dba..mas terkey
Response
0000 54 04 a6 4a bd 3f 00 1e 33 0d 06 67 08 00 45 00 T..J.?.. 3..g..E.
0010 00 48 24 85 40 00 80 06 52 d5 c0 a8 01 03 c0 a8 .H$.@... R.......
0020 01 02 0b eb 06 54 f3 a9 60 1e 76 be d8 e3 50 18 .....T.. `.v...P.
0030 01 00 61 0b 00 00 00 00 00 09 00 00 00 00 00 00 ..a..... ........
0040 00 00 00 00 00 00 00 00 00 00 00 00 00 01 14 00 ........ ........
0050 00 98 00 00 00 00 ......
Flamerobin
Connect
0000 00 1e 33 0d 06 67 54 04 a6 4a bd 3f 08 00 45 00 ..3..gT. .J.?..E.
0010 00 b8 18 55 40 00 80 06 5e 95 c0 a8 01 02 c0 a8 ...U@... ^.......
0020 01 03 06 56 0b eb 38 e9 2a 1b 8d 99 65 1a 50 18 ...V..8. *...e.P.
0030 40 29 ca 10 00 00 00 00 00 01 00 00 00 13 00 00 @)...... ........
0040 00 02 00 00 00 28 00 00 00 13 44 3a 5c 54 65 6d .....(.. ..D:\Tem
0050 70 5c 74 65 73 74 66 62 33 2e 66 64 62 00 00 00 p\testfb 3.fdb...
0060 00 04 00 00 00 10 01 04 4d 41 52 4b 04 06 72 61 ........ MARK..ra
0070 6d 6f 6e 61 06 00 00 00 00 08 00 00 00 01 00 00 mona.... ........
0080 00 02 00 00 00 05 00 00 00 02 00 00 00 0a 00 00 ........ ........
0090 00 01 00 00 00 02 00 00 00 05 00 00 00 04 ff ff ........ ........
00a0 80 0b 00 00 00 01 00 00 00 02 00 00 00 05 00 00 ........ ........
00b0 00 06 ff ff 80 0c 00 00 00 01 00 00 00 02 00 00 ........ ........
00c0 00 05 00 00 00 08 ......
Accept
0000 54 04 a6 4a bd 3f 00 1e 33 0d 06 67 08 00 45 00 T..J.?.. 3..g..E.
0010 00 38 24 8d 40 00 80 06 52 dd c0 a8 01 03 c0 a8 .8$.@... R.......
0020 01 02 0b eb 06 56 8d 99 65 1a 38 e9 2a ab 50 18 .....V.. e.8.*.P.
0030 01 00 42 c8 00 00 00 00 00 03 ff ff 80 0c 00 00 ..B..... ........
0040 00 01 00 00 00 05 ......
Attach
0000 00 1e 33 0d 06 67 54 04 a6 4a bd 3f 08 00 45 00 ..3..gT. .J.?..E.
0010 00 ac 18 56 40 00 80 06 5e a0 c0 a8 01 02 c0 a8 ...V@... ^.......
0020 01 03 06 56 0b eb 38 e9 2a ab 8d 99 65 2a 50 18 ...V..8. *...e*P.
0030 40 25 f1 d0 00 00 00 00 00 13 00 00 00 00 00 00 @%...... ........
0040 00 13 44 3a 5c 54 65 6d 70 5c 74 65 73 74 66 62 ..D:\Tem p\testfb
0050 33 2e 66 64 62 00 00 00 00 5e 01 1e 0b 51 50 33 3.fdb... .^...QP3
0060 4c 4d 5a 2f 4d 4a 68 2e 4a 30 43 3a 5c 50 72 6f LMZ/MJh. J0C:\Pro
0070 67 72 61 6d 20 46 69 6c 65 73 5c 46 6c 61 6d 65 gram Fil es\Flame
0080 52 6f 62 69 6e 20 28 78 36 34 29 5c 66 6c 61 6d Robin (x 64)\flam
0090 65 72 6f 62 69 6e 2e 65 78 65 3e 00 4d 00 3a 04 erobin.e xe>.M.:.
00a0 00 00 00 00 47 04 38 12 00 00 1c 06 73 79 73 64 ....G.8. ....sysd
00b0 62 61 30 04 4e 4f 4e 45 00 00 ba0.NONE ..
Response
0000 54 04 a6 4a bd 3f 00 1e 33 0d 06 67 08 00 45 00 T..J.?.. 3..g..E.
0010 00 48 24 8e 40 00 80 06 52 cc c0 a8 01 03 c0 a8 .H$.@... R.......
0020 01 02 0b eb 06 56 8d 99 65 2a 38 e9 2b 2f 50 18 .....V.. e*8.+/P.
0030 01 00 c2 2f 00 00 00 00 00 09 00 00 00 00 00 00 .../.... ........
0040 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 ........ ........
0050 00 00 00 00 00 00 ......
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
