Hi Robbie, On 2/10/16 4:06 PM, Robbie Harwood wrote: > Hello friends, > > For your consideration, here is a new version of GSSAPI encryption > support. For those who prefer, it's also available on my github: > https://github.com/frozencemetery/postgres/commit/c92275b6605d7929cda5551de47a4c60aab7179e
It tried out this patch and ran into a few problems: 1) It didn't apply cleanly to HEAD. It did apply cleanly on a455878 which I figured was recent enough for testing. I didn't bisect to find the exact commit that broke it. 2) While I was able to apply the patch and get it compiled it seemed pretty flaky - I was only able to logon about 1 in 10 times on average. Here was my testing methodology: a) Build Postgres from a455878 (without your patch), install/configure Kerberos and get everything working. I was able the set the auth method to gss in pg_hba.conf and logon successfully every time. b) On the same system rebuild Postgres from a455878 including your patch and attempt authentication. The problems arose after step 2b. Sometimes I would try to logon twenty times without success and sometimes it only take five or six attempts. I was never able to logon successfully twice in a row. When not successful the client always output this incomplete message (without terminating LF): psql: expected authentication request from server, but received From the logs I can see the server is reporting EOF from the client, though the client does not core dump and prints the above message before exiting. I have attached files that contain server logs at DEBUG5 and tcpdump output for both the success and failure cases. Please let me know if there's any more information you would like me to provide. -- -David da...@pgmasters.net
Postgres Log:
DEBUG: forked new backend, pid=16531 socket=9
DEBUG: postgres child[16531]: starting with (
DEBUG: postgres
DEBUG: )
DEBUG: InitPostgres
DEBUG: my backend ID is 2
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: Processing received GSS token of length 667
DEBUG: gss_accept_sec_context major: 0, minor: 0, outlen: 161, outflags: 1b2
DEBUG: sending GSS response token of length 161
DEBUG: sending GSS token of length 161
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: unexpected EOF on client connection
DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make
DEBUG: shmem_exit(0): 6 on_shmem_exit callbacks to make
DEBUG: proc_exit(0): 3 callbacks to make
DEBUG: exit(0)
DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
DEBUG: proc_exit(-1): 0 callbacks to make
DEBUG: reaping dead processes
DEBUG: server process (PID 16531) exited with exit code 0
TCP Dump:
16:48:15.541558 IP6 (hlim 64, next-header TCP (6) payload length: 40) ::1.51100
> ::1.5432: Flags [S], cksum 0x0030 (incorrect -> 0xdcd6), seq 1835476714, win
43690, options [mss 65476,sackOK,TS val 231098240 ecr 0,nop,wscale 7], length 0
0x0000: 6000 0000 0028 0640 0000 0000 0000 0000 `....(.@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 26ea ...........8mg&.
0x0030: 0000 0000 a002 aaaa 0030 0000 0204 ffc4 .........0......
0x0040: 0402 080a 0dc6 4780 0000 0000 0103 0307 ......G.........
16:48:15.541566 IP6 (hlim 64, next-header TCP (6) payload length: 40) ::1.5432
> ::1.51100: Flags [S.], cksum 0x0030 (incorrect -> 0x5a2a), seq 3525598000,
ack 1835476715, win 43690, options [mss 65476,sackOK,TS val 231098240 ecr
231098240,nop,wscale 7], length 0
0x0000: 6000 0000 0028 0640 0000 0000 0000 0000 `....(.@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5b30 .........8...$[0
0x0030: 6d67 26eb a012 aaaa 0030 0000 0204 ffc4 mg&......0......
0x0040: 0402 080a 0dc6 4780 0dc6 4780 0103 0307 ......G...G.....
16:48:15.541573 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51100
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2c5c), seq 1835476715, ack
3525598001, win 342, options [nop,nop,TS val 231098240 ecr 231098240], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 26eb ...........8mg&.
0x0030: d224 5b31 8010 0156 0028 0000 0101 080a .$[1...V.(......
0x0040: 0dc6 4780 0dc6 4780 ..G...G.
16:48:15.541806 IP6 (hlim 64, next-header TCP (6) payload length: 129)
::1.51100 > ::1.5432: Flags [P.], cksum 0x0089 (incorrect -> 0x553d), seq
1835476715:1835476812, ack 3525598001, win 342, options [nop,nop,TS val
231098240 ecr 231098240], length 97
0x0000: 6000 0000 0081 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 26eb ...........8mg&.
0x0030: d224 5b31 8018 0156 0089 0000 0101 080a .$[1...V........
0x0040: 0dc6 4780 0dc6 4780 0000 0061 0003 0000 ..G...G....a....
0x0050: 7573 6572 0076 6167 7261 6e74 4050 474d user.vagrant@PGM
0x0060: 4153 5445 5253 2e4e 4554 0064 6174 6162 ASTERS.NET.datab
0x0070: 6173 6500 706f 7374 6772 6573 0061 7070 ase.postgres.app
0x0080: 6c69 6361 7469 6f6e 5f6e 616d 6500 7073 lication_name.ps
0x0090: 716c 0063 6c69 656e 745f 656e 636f 6469 ql.client_encodi
0x00a0: 6e67 0055 5446 3800 00 ng.UTF8..
16:48:15.541809 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.5432
> ::1.51100: Flags [.], cksum 0x0028 (incorrect -> 0x2bfb), seq 3525598001, ack
1835476812, win 342, options [nop,nop,TS val 231098240 ecr 231098240], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5b31 .........8...$[1
0x0030: 6d67 274c 8010 0156 0028 0000 0101 080a mg'L...V.(......
0x0040: 0dc6 4780 0dc6 4780 ..G...G.
16:48:15.542426 IP6 (hlim 64, next-header TCP (6) payload length: 41) ::1.5432
> ::1.51100: Flags [P.], cksum 0x0031 (incorrect -> 0xcae9), seq
3525598001:3525598010, ack 1835476812, win 342, options [nop,nop,TS val
231098240 ecr 231098240], length 9
0x0000: 6000 0000 0029 0640 0000 0000 0000 0000 `....).@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5b31 .........8...$[1
0x0030: 6d67 274c 8018 0156 0031 0000 0101 080a mg'L...V.1......
0x0040: 0dc6 4780 0dc6 4780 5200 0000 0800 0000 ..G...G.R.......
0x0050: 07 .
16:48:15.542429 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51100
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2bf2), seq 1835476812, ack
3525598010, win 342, options [nop,nop,TS val 231098240 ecr 231098240], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 274c ...........8mg'L
0x0030: d224 5b3a 8010 0156 0028 0000 0101 080a .$[:...V.(......
0x0040: 0dc6 4780 0dc6 4780 ..G...G.
16:48:15.543203 IP6 (hlim 64, next-header TCP (6) payload length: 704)
::1.51100 > ::1.5432: Flags [P.], cksum 0x02c8 (incorrect -> 0x0b16), seq
1835476812:1835477484, ack 3525598010, win 342, options [nop,nop,TS val
231098240 ecr 231098240], length 672
0x0000: 6000 0000 02c0 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 274c ...........8mg'L
0x0030: d224 5b3a 8018 0156 02c8 0000 0101 080a .$[:...V........
0x0040: 0dc6 4780 0dc6 4780 7000 0002 9f60 8202 ..G...G.p....`..
0x0050: 9706 092a 8648 86f7 1201 0202 0100 6e82 ...*.H........n.
0x0060: 0286 3082 0282 a003 0201 05a1 0302 010e ..0.............
0x0070: a207 0305 0020 0000 00a3 8201 7661 8201 ............va..
0x0080: 7230 8201 6ea0 0302 0105 a10f 1b0d 5047 r0..n.........PG
0x0090: 4d41 5354 4552 532e 4e45 54a2 2030 1ea0 MASTERS.NET..0..
0x00a0: 0302 0103 a117 3015 1b08 706f 7374 6772 ......0...postgr
0x00b0: 6573 1b09 6c6f 6361 6c68 6f73 74a3 8201 es..localhost...
0x00c0: 3230 8201 2ea0 0302 0110 a103 0201 02a2 20..............
0x00d0: 8201 2004 8201 1c31 3e01 e643 aa36 ba88 .......1>..C.6..
0x00e0: d4d7 0b19 3c86 5efd 0a09 1bb7 c8c1 b5fe ....<.^.........
0x00f0: ee44 6c45 ff15 95e8 0aa3 50fb e622 8005 .DlE......P.."..
0x0100: 3f0b 72b9 01fb 24f3 3a79 c970 85e8 ef00 ?.r...$.:y.p....
0x0110: 75cf e229 5d0f 79d7 516b 2eb2 8277 b50e u..)].y.Qk...w..
0x0120: 9a39 50e7 5f21 d3e3 39de 4e17 721b 30f6 .9P._!..9.N.r.0.
0x0130: d99f aeed 2f3a 32ac 46fd 1677 4a98 5ddf ..../:2.F..wJ.].
0x0140: 64b0 03d0 f980 99c3 b74a caa3 b3eb 095d d........J.....]
0x0150: 3e31 d2d6 0f75 fc29 a727 d176 a74a e965 >1...u.).'.v.J.e
0x0160: 3578 f606 2562 f4a5 23aa 53ba db86 ab1b 5x..%b..#.S.....
0x0170: c2bf 2668 5ce1 b258 7c52 64ad 2ecf f26d ..&h\..X|Rd....m
0x0180: 142c 9a3c 4ab5 0255 2fcd 11ab b71d 303a .,.<J..U/.....0:
0x0190: 84f2 fed3 4d62 c09f 2dfa abfd d7f7 e58e ....Mb..-.......
0x01a0: 6e11 1d8d 8fa3 ecdb 5360 9145 22d3 8ca2 n.......S`.E"...
0x01b0: 714d b2e2 1847 df04 557c 404f 6700 3253 qM...G..U|@Og.2S
0x01c0: a645 5a7f e714 01c7 6381 0d01 7135 28dd .EZ.....c...q5(.
0x01d0: 2ead eafd c621 4e86 b2d8 ee74 8ea5 2d9a .....!N....t..-.
0x01e0: d9f1 7a6f faae 44f6 b9c3 bcb5 5c04 0a24 ..zo..D.....\..$
0x01f0: ea84 3aa4 81f2 3081 efa0 0302 0110 a281 ..:...0.........
0x0200: e704 81e4 785d e5c6 3a96 e193 3cab 28c0 ....x]..:...<.(.
0x0210: 0f29 9d9a 71c6 5afb 4bbb 4c11 de48 bebc .)..q.Z.K.L..H..
0x0220: 6d07 4ec0 b954 911a 840c 3cab 5179 34ab m.N..T....<.Qy4.
0x0230: b8c0 f18d 17e3 30ff 954c 34d7 00e0 5a75 ......0..L4...Zu
0x0240: 5725 0af8 eac5 4270 52c8 7773 572c 2ee7 W%....BpR.wsW,..
0x0250: 475e a5ac b1e5 5bb4 c8c5 e9f8 eb84 4388 G^....[.......C.
0x0260: 8d09 c9fb d500 ff1a 0cbb 3148 004c 3525 ..........1H.L5%
0x0270: 7df1 e85b b391 020a 7fcb 4f91 1bdb 8f28 }..[......O....(
0x0280: 42f6 35aa ad4e c713 f2bf b6cf b03d c05a B.5..N.......=.Z
0x0290: 4ab2 455f 8ece adbc a5e7 abbf 8bd0 e736 J.E_...........6
0x02a0: 7827 5157 2de8 0578 c9db 0d8a c940 9492 x'QW-..x.....@..
0x02b0: 44e4 f9de c955 f246 ceff f289 9093 8a56 D....U.F.......V
0x02c0: c4cb 4358 afbb c1ff 0a70 d595 92dd 9640 ..CX.....p.....@
0x02d0: 5235 f0b9 30f8 9335 1908 b5c1 6912 db65 R5..0..5....i..e
0x02e0: 0545 0b30 62b4 a3ad .E.0b...
16:48:15.544620 IP6 (hlim 64, next-header TCP (6) payload length: 202) ::1.5432
> ::1.51100: Flags [P.], cksum 0x00d2 (incorrect -> 0x03ee), seq
3525598010:3525598180, ack 1835477484, win 352, options [nop,nop,TS val
231098241 ecr 231098240], length 170
0x0000: 6000 0000 00ca 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5b3a .........8...$[:
0x0030: 6d67 29ec 8018 0160 00d2 0000 0101 080a mg)....`........
0x0040: 0dc6 4781 0dc6 4780 5200 0000 a900 0000 ..G...G.R.......
0x0050: 0860 819e 0609 2a86 4886 f712 0102 0202 .`....*.H.......
0x0060: 006f 818e 3081 8ba0 0302 0105 a103 0201 .o..0...........
0x0070: 0fa2 7f30 7da0 0302 0110 a276 0474 775a ...0}......v.twZ
0x0080: de5e 2331 9f64 d214 6d47 e4ee e5ed 5f19 .^#1.d..mG...._.
0x0090: 4d43 6b31 fef5 51b0 4245 96ea 7275 6659 MCk1..Q.BE..rufY
0x00a0: f0eb 34af 9ec8 370a 0555 765c b92a 66d3 ..4...7..Uv\.*f.
0x00b0: f9b5 c3ed 3894 43c7 c46f 5f2a 1173 a8fa ....8.C..o_*.s..
0x00c0: 7fc5 3b18 9c58 0e73 1465 829d 7ff7 97b5 ..;..X.s.e......
0x00d0: 7c4c 7537 5f6d 2163 b9a1 1a61 2142 b8ad |Lu7_m!c...a!B..
0x00e0: 0aa9 da5f 8e12 6baa 7aa5 e97e d393 f8ad ..._..k.z..~....
0x00f0: 6034 `4
16:48:15.545047 IP6 (hlim 64, next-header TCP (6) payload length: 435) ::1.5432
> ::1.51100: Flags [P.], cksum 0x01bb (incorrect -> 0x847b), seq
3525598180:3525598583, ack 1835477484, win 352, options [nop,nop,TS val
231098241 ecr 231098240], length 403
0x0000: 6000 0000 01b3 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5be4 .........8...$[.
0x0030: 6d67 29ec 8018 0160 01bb 0000 0101 080a mg)....`........
0x0040: 0dc6 4781 0dc6 4780 0000 018f 0504 07ff ..G...G.........
0x0050: 0000 0000 0000 0000 1b86 3079 fa40 68d7 ..........0y.@h.
0x0060: 97d3 3663 09ca a565 11aa c9b9 9ae0 8964 ..6c...e.......d
0x0070: 914e ebc8 54bf 97fb 0052 73c0 f263 b953 .N..T....Rs..c.S
0x0080: 2da1 2aa3 02a8 1494 5317 6100 0ae6 ebba -.*.....S.a.....
0x0090: 38f7 7d39 2714 e2a7 9f6f 7c67 44fa 3d5c 8.}9'....o|gD.=\
0x00a0: 9807 dd5e 114e 8abc e6b1 c1e5 366e 1aae ...^.N......6n..
0x00b0: cc18 c23a 74a4 e183 ed5d 7599 8440 b564 ...:t....]u..@.d
0x00c0: 3330 0d85 de90 4f29 3035 dfaa 615a 9871 30....O)05..aZ.q
0x00d0: 6689 0136 f514 2bc4 0f94 f120 3bb8 6068 f..6..+.....;.`h
0x00e0: 9602 c43b e3e2 70b2 5d21 e262 dc0f bd38 ...;..p.]!.b...8
0x00f0: e52e e181 83a5 bceb 131d da98 98aa c570 ...............p
0x0100: 78fd c156 d2f9 b492 c49f 881a 6f81 445b x..V........o.D[
0x0110: 201e b4ee 9ef7 3abc fa9f 59f1 e3ec b11e ......:...Y.....
0x0120: 530d 18ed f20f 6734 1536 420a cbf5 c1b8 S.....g4.6B.....
0x0130: c9d9 edd3 5706 f92e 4a75 9fbf dcbc 89f0 ....W...Ju......
0x0140: add4 61bc ab24 6bbc 1214 9b34 cfdc b8c7 ..a..$k....4....
0x0150: 72eb d6d1 9a4a b7b1 52cd 7321 8ec5 79a2 r....J..R.s!..y.
0x0160: c9d1 59fd 2c31 7916 f2c2 06dc 27b4 2116 ..Y.,1y.....'.!.
0x0170: d951 4694 b392 de77 c19d 942e b07a 5c2c .QF....w.....z\,
0x0180: 5d49 2a68 f85b e82c f1f0 53f4 db03 e74d ]I*h.[.,..S....M
0x0190: 9709 8ba9 6e5c 9749 c517 8d99 b184 bd22 ....n\.I......."
0x01a0: eddc 1b91 4d45 e397 7d37 c9cd 4a6a accf ....ME..}7..Jj..
0x01b0: 48eb 14cc 1dd2 bef6 bf5b 0215 8a4e 6ec9 H........[...Nn.
0x01c0: f8aa 4985 3f72 bc29 5c4c f7e1 a503 ef55 ..I.?r.)\L.....U
0x01d0: d14f 4396 3ae8 abc8 73a3 c0 .OC.:...s..
16:48:15.545050 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51100
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2702), seq 1835477484, ack
3525598583, win 359, options [nop,nop,TS val 231098241 ecr 231098241], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 29ec ...........8mg).
0x0030: d224 5d77 8010 0167 0028 0000 0101 080a .$]w...g.(......
0x0040: 0dc6 4781 0dc6 4781 ..G...G.
16:48:15.545355 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51100
> ::1.5432: Flags [F.], cksum 0x0028 (incorrect -> 0x2701), seq 1835477484, ack
3525598583, win 359, options [nop,nop,TS val 231098241 ecr 231098241], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 29ec ...........8mg).
0x0030: d224 5d77 8011 0167 0028 0000 0101 080a .$]w...g.(......
0x0040: 0dc6 4781 0dc6 4781 ..G...G.
16:48:15.546116 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.5432
> ::1.51100: Flags [F.], cksum 0x0028 (incorrect -> 0x2707), seq 3525598583,
ack 1835477485, win 352, options [nop,nop,TS val 231098241 ecr 231098241],
length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79c d224 5d77 .........8...$]w
0x0030: 6d67 29ed 8011 0160 0028 0000 0101 080a mg)....`.(......
0x0040: 0dc6 4781 0dc6 4781 ..G...G.
16:48:15.546120 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51100
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2700), seq 1835477485, ack
3525598584, win 359, options [nop,nop,TS val 231098241 ecr 231098241], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79c 1538 6d67 29ed ...........8mg).
0x0030: d224 5d78 8010 0167 0028 0000 0101 080a .$]x...g.(......
0x0040: 0dc6 4781 0dc6 4781 ..G...G.
Postgres Log:
DEBUG: forked new backend, pid=16528 socket=9
DEBUG: postgres child[16528]: starting with (
DEBUG: postgres
DEBUG: )
DEBUG: InitPostgres
DEBUG: my backend ID is 2
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: Processing received GSS token of length 667
DEBUG: gss_accept_sec_context major: 0, minor: 0, outlen: 161, outflags: 1b2
DEBUG: sending GSS response token of length 161
DEBUG: sending GSS token of length 161
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
TCP Dump:
16:47:32.071279 IP6 (hlim 64, next-header TCP (6) payload length: 40) ::1.51099
> ::1.5432: Flags [S], cksum 0x0030 (incorrect -> 0x15cc), seq 141655392, win
43690, options [mss 65476,sackOK,TS val 231087372 ecr 0,nop,wscale 7], length 0
0x0000: 6000 0000 0028 0640 0000 0000 0000 0000 `....(.@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 7d60 ...........8.q}`
0x0030: 0000 0000 a002 aaaa 0030 0000 0204 ffc4 .........0......
0x0040: 0402 080a 0dc6 1d0c 0000 0000 0103 0307 ................
16:47:32.071286 IP6 (hlim 64, next-header TCP (6) payload length: 40) ::1.5432
> ::1.51099: Flags [S.], cksum 0x0030 (incorrect -> 0x620f), seq 1708335878,
ack 141655393, win 43690, options [mss 65476,sackOK,TS val 231087372 ecr
231087372,nop,wscale 7], length 0
0x0000: 6000 0000 0028 0640 0000 0000 0000 0000 `....(.@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79b 65d3 2306 .........8..e.#.
0x0030: 0871 7d61 a012 aaaa 0030 0000 0204 ffc4 .q}a.....0......
0x0040: 0402 080a 0dc6 1d0c 0dc6 1d0c 0103 0307 ................
16:47:32.071292 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51099
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x3441), seq 141655393, ack
1708335879, win 342, options [nop,nop,TS val 231087372 ecr 231087372], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 7d61 ...........8.q}a
0x0030: 65d3 2307 8010 0156 0028 0000 0101 080a e.#....V.(......
0x0040: 0dc6 1d0c 0dc6 1d0c ........
16:47:32.071516 IP6 (hlim 64, next-header TCP (6) payload length: 129)
::1.51099 > ::1.5432: Flags [P.], cksum 0x0089 (incorrect -> 0x5d22), seq
141655393:141655490, ack 1708335879, win 342, options [nop,nop,TS val 231087372
ecr 231087372], length 97
0x0000: 6000 0000 0081 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 7d61 ...........8.q}a
0x0030: 65d3 2307 8018 0156 0089 0000 0101 080a e.#....V........
0x0040: 0dc6 1d0c 0dc6 1d0c 0000 0061 0003 0000 ...........a....
0x0050: 7573 6572 0076 6167 7261 6e74 4050 474d user.vagrant@PGM
0x0060: 4153 5445 5253 2e4e 4554 0064 6174 6162 ASTERS.NET.datab
0x0070: 6173 6500 706f 7374 6772 6573 0061 7070 ase.postgres.app
0x0080: 6c69 6361 7469 6f6e 5f6e 616d 6500 7073 lication_name.ps
0x0090: 716c 0063 6c69 656e 745f 656e 636f 6469 ql.client_encodi
0x00a0: 6e67 0055 5446 3800 00 ng.UTF8..
16:47:32.071519 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.5432
> ::1.51099: Flags [.], cksum 0x0028 (incorrect -> 0x33e0), seq 1708335879, ack
141655490, win 342, options [nop,nop,TS val 231087372 ecr 231087372], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79b 65d3 2307 .........8..e.#.
0x0030: 0871 7dc2 8010 0156 0028 0000 0101 080a .q}....V.(......
0x0040: 0dc6 1d0c 0dc6 1d0c ........
16:47:32.072082 IP6 (hlim 64, next-header TCP (6) payload length: 41) ::1.5432
> ::1.51099: Flags [P.], cksum 0x0031 (incorrect -> 0xd2ce), seq
1708335879:1708335888, ack 141655490, win 342, options [nop,nop,TS val
231087372 ecr 231087372], length 9
0x0000: 6000 0000 0029 0640 0000 0000 0000 0000 `....).@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79b 65d3 2307 .........8..e.#.
0x0030: 0871 7dc2 8018 0156 0031 0000 0101 080a .q}....V.1......
0x0040: 0dc6 1d0c 0dc6 1d0c 5200 0000 0800 0000 ........R.......
0x0050: 07 .
16:47:32.072085 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51099
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x33d7), seq 141655490, ack
1708335888, win 342, options [nop,nop,TS val 231087372 ecr 231087372], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 7dc2 ...........8.q}.
0x0030: 65d3 2310 8010 0156 0028 0000 0101 080a e.#....V.(......
0x0040: 0dc6 1d0c 0dc6 1d0c ........
16:47:32.072988 IP6 (hlim 64, next-header TCP (6) payload length: 704)
::1.51099 > ::1.5432: Flags [P.], cksum 0x02c8 (incorrect -> 0xe207), seq
141655490:141656162, ack 1708335888, win 342, options [nop,nop,TS val 231087373
ecr 231087372], length 672
0x0000: 6000 0000 02c0 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 7dc2 ...........8.q}.
0x0030: 65d3 2310 8018 0156 02c8 0000 0101 080a e.#....V........
0x0040: 0dc6 1d0d 0dc6 1d0c 7000 0002 9f60 8202 ........p....`..
0x0050: 9706 092a 8648 86f7 1201 0202 0100 6e82 ...*.H........n.
0x0060: 0286 3082 0282 a003 0201 05a1 0302 010e ..0.............
0x0070: a207 0305 0020 0000 00a3 8201 7661 8201 ............va..
0x0080: 7230 8201 6ea0 0302 0105 a10f 1b0d 5047 r0..n.........PG
0x0090: 4d41 5354 4552 532e 4e45 54a2 2030 1ea0 MASTERS.NET..0..
0x00a0: 0302 0103 a117 3015 1b08 706f 7374 6772 ......0...postgr
0x00b0: 6573 1b09 6c6f 6361 6c68 6f73 74a3 8201 es..localhost...
0x00c0: 3230 8201 2ea0 0302 0110 a103 0201 02a2 20..............
0x00d0: 8201 2004 8201 1c31 3e01 e643 aa36 ba88 .......1>..C.6..
0x00e0: d4d7 0b19 3c86 5efd 0a09 1bb7 c8c1 b5fe ....<.^.........
0x00f0: ee44 6c45 ff15 95e8 0aa3 50fb e622 8005 .DlE......P.."..
0x0100: 3f0b 72b9 01fb 24f3 3a79 c970 85e8 ef00 ?.r...$.:y.p....
0x0110: 75cf e229 5d0f 79d7 516b 2eb2 8277 b50e u..)].y.Qk...w..
0x0120: 9a39 50e7 5f21 d3e3 39de 4e17 721b 30f6 .9P._!..9.N.r.0.
0x0130: d99f aeed 2f3a 32ac 46fd 1677 4a98 5ddf ..../:2.F..wJ.].
0x0140: 64b0 03d0 f980 99c3 b74a caa3 b3eb 095d d........J.....]
0x0150: 3e31 d2d6 0f75 fc29 a727 d176 a74a e965 >1...u.).'.v.J.e
0x0160: 3578 f606 2562 f4a5 23aa 53ba db86 ab1b 5x..%b..#.S.....
0x0170: c2bf 2668 5ce1 b258 7c52 64ad 2ecf f26d ..&h\..X|Rd....m
0x0180: 142c 9a3c 4ab5 0255 2fcd 11ab b71d 303a .,.<J..U/.....0:
0x0190: 84f2 fed3 4d62 c09f 2dfa abfd d7f7 e58e ....Mb..-.......
0x01a0: 6e11 1d8d 8fa3 ecdb 5360 9145 22d3 8ca2 n.......S`.E"...
0x01b0: 714d b2e2 1847 df04 557c 404f 6700 3253 qM...G..U|@Og.2S
0x01c0: a645 5a7f e714 01c7 6381 0d01 7135 28dd .EZ.....c...q5(.
0x01d0: 2ead eafd c621 4e86 b2d8 ee74 8ea5 2d9a .....!N....t..-.
0x01e0: d9f1 7a6f faae 44f6 b9c3 bcb5 5c04 0a24 ..zo..D.....\..$
0x01f0: ea84 3aa4 81f2 3081 efa0 0302 0110 a281 ..:...0.........
0x0200: e704 81e4 70d6 2c7e 5eee 967f 5b41 baab ....p.,~^...[A..
0x0210: 8efa 5ffd 8cdc ebe4 5522 7b93 64b6 5c6c .._.....U"{.d.\l
0x0220: 6275 8793 5cd2 37e2 4035 f80a 6ecb 7118 bu..\.7.@5..n.q.
0x0230: fae9 6718 c383 d424 6f69 80df bc82 74bd ..g....$oi....t.
0x0240: 5a1c 2697 87b4 69e3 f11e 4099 670d d7da Z.&...i...@.g...
0x0250: 6a84 0bc8 e306 b447 acee 10b3 6b19 08d9 j......G....k...
0x0260: 2032 2b74 05f7 f62f 12fe 0c76 6358 1128 .2+t.../...vcX.(
0x0270: b404 09ef d4f0 2c3a 315d 8269 0af2 792b ......,:1].i..y+
0x0280: 560f 2587 7a46 32eb e4f2 bde7 6715 d429 V.%.zF2.....g..)
0x0290: 2214 19b7 f969 1a62 2d83 37d3 2420 40c0 "....i.b-.7.$.@.
0x02a0: 0a2e af74 0a3b 822f 4150 ff1d 5943 4179 ...t.;./AP..YCAy
0x02b0: 2423 d9c5 afa7 adcb cc2c ca3c 72d2 ce91 $#.......,.<r...
0x02c0: a61c 7e8e 4ce1 53e8 7ddf e9a2 bc0b e76e ..~.L.S.}......n
0x02d0: 293c c0e1 bf60 e86a 3cec 2135 a8be bde7 )<...`.j<.!5....
0x02e0: b557 188f fba4 bc57 .W.....W
16:47:32.077690 IP6 (hlim 64, next-header TCP (6) payload length: 202) ::1.5432
> ::1.51099: Flags [P.], cksum 0x00d2 (incorrect -> 0xb9a2), seq
1708335888:1708336058, ack 141656162, win 352, options [nop,nop,TS val
231087374 ecr 231087373], length 170
0x0000: 6000 0000 00ca 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79b 65d3 2310 .........8..e.#.
0x0030: 0871 8062 8018 0160 00d2 0000 0101 080a .q.b...`........
0x0040: 0dc6 1d0e 0dc6 1d0d 5200 0000 a900 0000 ........R.......
0x0050: 0860 819e 0609 2a86 4886 f712 0102 0202 .`....*.H.......
0x0060: 006f 818e 3081 8ba0 0302 0105 a103 0201 .o..0...........
0x0070: 0fa2 7f30 7da0 0302 0110 a276 0474 8f64 ...0}......v.t.d
0x0080: 73c8 b107 170d e27c c780 64e2 7e59 15af s......|..d.~Y..
0x0090: 8cde 341e 56a5 9c05 6925 77e0 090c 6483 ..4.V...i%w...d.
0x00a0: 9f20 49c7 9936 ded7 aa5d 0522 2855 93eb ..I..6...]."(U..
0x00b0: bae8 c545 65b1 d133 3f41 e818 f522 860c ...Ee..3?A..."..
0x00c0: a9a7 b48b ca0c 6674 ee5b ee73 ef0c 2c84 ......ft.[.s..,.
0x00d0: 6357 ebb9 a6cb 3661 fd81 6e66 da02 49d9 cW....6a..nf..I.
0x00e0: 3593 4014 7579 e631 5fcd a95e 3577 528d 5.@.uy.1_..^5wR.
0x00f0: a5b7 ..
16:47:32.078310 IP6 (hlim 64, next-header TCP (6) payload length: 435) ::1.5432
> ::1.51099: Flags [P.], cksum 0x01bb (incorrect -> 0xcb68), seq
1708336058:1708336461, ack 141656162, win 352, options [nop,nop,TS val
231087374 ecr 231087373], length 403
0x0000: 6000 0000 01b3 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 1538 c79b 65d3 23ba .........8..e.#.
0x0030: 0871 8062 8018 0160 01bb 0000 0101 080a .q.b...`........
0x0040: 0dc6 1d0e 0dc6 1d0d 0000 018f 0504 07ff ................
0x0050: 0000 0000 0000 0000 14b6 2a61 f707 565d ..........*a..V]
0x0060: edbb 286e f556 111c 01d8 2651 4d88 a03d ..(n.V....&QM..=
0x0070: b7b3 fc3d d296 4507 3d32 e526 98e4 9f99 ...=..E.=2.&....
0x0080: 9ddd c2c4 52ab 4f60 6d50 7ea4 f40e 54ae ....R.O`mP~...T.
0x0090: 70d0 54bf 34a4 0825 c98f dbf8 408b 5626 p.T.4..%....@.V&
0x00a0: 709f 2f08 b533 f25c b485 6f47 1eba cd3b p./..3.\..oG...;
0x00b0: 794f 1860 0e09 0854 4f4c 1218 f772 6d1d yO.`...TOL...rm.
0x00c0: fcfd 3e5c 860d b75f e8f3 5792 e9c1 cd24 ..>\..._..W....$
0x00d0: 6925 468a 5dbc 140f 0b30 3489 784a ccda i%F.]....04.xJ..
0x00e0: bf19 4d2e 67d0 dc81 fd6d d1e5 5c18 460f ..M.g....m..\.F.
0x00f0: d051 591c 9aec 6c6b 1717 fff6 aaa6 d029 .QY...lk.......)
0x0100: fc74 3c63 bf87 b4a3 392c f1e1 65ac 5f6f .t<c....9,..e._o
0x0110: 7546 bc32 dfd8 926f a641 7def 69b9 5b3f uF.2...o.A}.i.[?
0x0120: ac6a dd0c 4ca2 f7b7 a343 7e73 26e0 0fd8 .j..L....C~s&...
0x0130: dbfd 654f a7b4 9967 3108 3373 ef74 d950 ..eO...g1.3s.t.P
0x0140: ed01 0cf3 1783 825a ccf3 0edc d32f f1be .......Z...../..
0x0150: 8b36 6b33 6492 6844 9c1d 5dcd e0a2 9fea .6k3d.hD..].....
0x0160: 1180 5499 4154 ec22 42db 3106 7f00 bd7a ..T.AT."B.1....z
0x0170: 6d46 e183 b5a8 88d8 c368 7fb3 57f2 505a mF.......h..W.PZ
0x0180: 9db6 ef8b 6042 3d99 0ff6 e77d 0931 f831 ....`B=....}.1.1
0x0190: e1cd 1716 013e 066c acfb 0032 4914 9640 .....>.l...2I..@
0x01a0: 3cfb 9eb1 090b 84fd c9b6 5e3c b95e ddcc <.........^<.^..
0x01b0: 26a4 b0f8 ed85 7ad5 2fa2 27e4 67fe 0ad9 &.....z./.'.g...
0x01c0: 71fb ecc5 b5d9 14ec 1e2f 8364 a9ae 16c4 q......../.d....
0x01d0: 1265 6078 c94c d22b db3c 11 .e`x.L.+.<.
16:47:32.078313 IP6 (hlim 64, next-header TCP (6) payload length: 32) ::1.51099
> ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2ee5), seq 141656162, ack
1708336461, win 359, options [nop,nop,TS val 231087374 ecr 231087374], length 0
0x0000: 6000 0000 0020 0640 0000 0000 0000 0000 `......@........
0x0010: 0000 0000 0000 0001 0000 0000 0000 0000 ................
0x0020: 0000 0000 0000 0001 c79b 1538 0871 8062 ...........8.q.b
0x0030: 65d3 254d 8010 0167 0028 0000 0101 080a e.%M...g.(......
0x0040: 0dc6 1d0e 0dc6 1d0e ........
signature.asc
Description: OpenPGP digital signature
