Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aUH6T-0002YQ-FA for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Feb 2016 17:01:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aUH6S-0003sa-Nx for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Feb 2016 17:01:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aUH6R-0003sT-Tq for pgsql-hackers@postgresql.org; Fri, 12 Feb 2016 17:01:56 +0000 Received: from linode.thelabyrinth.net ([198.58.117.137] helo=mail.thelabyrinth.net) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aUH6L-0007WZ-Bj for pgsql-hackers@postgresql.org; Fri, 12 Feb 2016 17:01:55 +0000 Received: from Davids-iMac.home (pool-96-243-136-12.tampfl.fios.verizon.net [96.243.136.12]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 7A32012D13; Fri, 12 Feb 2016 17:01:46 +0000 (UTC) Subject: Re: [PATCH v4] GSSAPI encryption support To: Robbie Harwood , pgsql-hackers@postgresql.org References: From: David Steele X-Enigmail-Draft-Status: N1110 Message-ID: <56BE0FF9.70302@pgmasters.net> Date: Fri, 12 Feb 2016 12:01:45 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="NrC4dM80tkMcao06J8XwNWLL3HHx5AIlE" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --NrC4dM80tkMcao06J8XwNWLL3HHx5AIlE Content-Type: multipart/mixed; boundary="------------050003010804020702020700" This is a multi-part message in MIME format. --------------050003010804020702020700 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Robbie, On 2/10/16 4:06 PM, Robbie Harwood wrote: > Hello friends, >=20 > 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/c92275b6605d7929cda55= 51de47a4c60aab7179e 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 =46rom 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. --=20 -David david@pgmasters.net --------------050003010804020702020700 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="gssauth-fail.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="gssauth-fail.log" Postgres Log: DEBUG: forked new backend, pid=3D16531 socket=3D9 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/sub= id/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/sub= id/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= =2E51100 > ::1.5432: Flags [S], cksum 0x0030 (incorrect -> 0xdcd6), seq 1= 835476714, win 43690, options [mss 65476,sackOK,TS val 231098240 ecr 0,no= p,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= =2E5432 > ::1.51100: Flags [S.], cksum 0x0030 (incorrect -> 0x5a2a), seq = 3525598000, ack 1835476715, win 43690, options [mss 65476,sackOK,TS val 2= 31098240 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= =2E51100 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2c5c), seq 1= 835476715, 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 1= 835476715:1835476812, ack 3525598001, win 342, options [nop,nop,TS val 23= 1098240 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= =2E5432 > ::1.51100: Flags [.], cksum 0x0028 (incorrect -> 0x2bfb), seq 3= 525598001, 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= =2E5432 > ::1.51100: Flags [P.], cksum 0x0031 (incorrect -> 0xcae9), seq = 3525598001:3525598010, ack 1835476812, win 342, options [nop,nop,TS val 2= 31098240 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= =2E51100 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2bf2), seq 1= 835476812, 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 1= 835476812:1835477484, ack 3525598010, win 342, options [nop,nop,TS val 23= 1098240 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 .,. ::1.51100: Flags [P.], cksum 0x00d2 (incorrect -> 0x03ee), seq 3= 525598010:3525598180, ack 1835477484, win 352, options [nop,nop,TS val 23= 1098241 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 3= 525598180:3525598583, ack 1835477484, win 352, options [nop,nop,TS val 23= 1098241 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.=3D\ 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= =2E51100 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2702), seq 1= 835477484, 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= =2E51100 > ::1.5432: Flags [F.], cksum 0x0028 (incorrect -> 0x2701), seq = 1835477484, ack 3525598583, win 359, options [nop,nop,TS val 231098241 ec= r 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= =2E5432 > ::1.51100: Flags [F.], cksum 0x0028 (incorrect -> 0x2707), seq = 3525598583, ack 1835477485, win 352, options [nop,nop,TS val 231098241 ec= r 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= =2E51100 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2700), seq 1= 835477485, 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. --------------050003010804020702020700 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="gssauth-success.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="gssauth-success.log" Postgres Log: DEBUG: forked new backend, pid=3D16528 socket=3D9 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/sub= id/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/sub= id/cid: 0/1/0, nestlvl: 1, children: TCP Dump: 16:47:32.071279 IP6 (hlim 64, next-header TCP (6) payload length: 40) ::1= =2E51099 > ::1.5432: Flags [S], cksum 0x0030 (incorrect -> 0x15cc), seq 1= 41655392, 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= =2E5432 > ::1.51099: Flags [S.], cksum 0x0030 (incorrect -> 0x620f), seq = 1708335878, ack 141655393, win 43690, options [mss 65476,sackOK,TS val 23= 1087372 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= =2E51099 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x3441), seq 1= 41655393, 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 1= 41655393:141655490, ack 1708335879, win 342, options [nop,nop,TS val 2310= 87372 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= =2E5432 > ::1.51099: Flags [.], cksum 0x0028 (incorrect -> 0x33e0), seq 1= 708335879, 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= =2E5432 > ::1.51099: Flags [P.], cksum 0x0031 (incorrect -> 0xd2ce), seq = 1708335879:1708335888, ack 141655490, win 342, options [nop,nop,TS val 23= 1087372 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= =2E51099 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x33d7), seq 1= 41655490, 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 1= 41655490:141656162, ack 1708335888, win 342, options [nop,nop,TS val 2310= 87373 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 .,. ::1.51099: Flags [P.], cksum 0x00d2 (incorrect -> 0xb9a2), seq 1= 708335888:1708336058, ack 141656162, win 352, options [nop,nop,TS val 231= 087374 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 1= 708336058:1708336461, ack 141656162, win 352, options [nop,nop,TS val 231= 087374 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..=3D 0x0070: b7b3 fc3d d296 4507 3d32 e526 98e4 9f99 ...=3D..E.=3D2.&.... 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.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= =2E51099 > ::1.5432: Flags [.], cksum 0x0028 (incorrect -> 0x2ee5), seq 1= 41656162, 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 ........ --------------050003010804020702020700-- --NrC4dM80tkMcao06J8XwNWLL3HHx5AIlE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iQIcBAEBCgAGBQJWvg/5AAoJEIA2uIJQ5SFAjYAP/RATvMAhrT9tWUd+zUvw0ZVG chlUOevhoQV7CvITziLf9JnmiZgdw87JXV9oWl7c7L7G/dBO/IhM4culdKeE5ZUL 6fxlnNpH3Y7w+RnZIhDTm9dlB1l3ta1kx013n87V4wt67qqE3lHN2UCML5WNI9At ct2gO/WgVfG8oIgUVE8hWBv/0/ojxsn7nBYk+f9XyTNTj5YKkYOZTx46JH2UFK1s R8rgDEf1nDvog5Iovz9NnncbG2/n6BxwLZH9A8+0LOxRPCWyAa184AGKeNNw4cIY Iwm945blCobTgEMHv7VopMv/gkDr6XNwUpfpGogH2iGVSWVB+OQwd60kd/4IKUDU Jf2+urfYM2HKNsyGKZmDB+lHe0fiLJhAGN86ONxi8AUbQ6VDCqcLJKtt5KEwlAza LCvd4EhiE6A11kj96uq9oB64SJuSQ5KlrlcY552gcHqxYmtrfRrHKw0Mm9UEXnbQ yPyj1A7HztYW9B4SUblbyRNA32LlLd0IHyKnVPXrHC42vUKVcvjIg5npIYw/Hul7 9STJV+FWH2fVVYkGwlUyR+n9MROZgeejW5Zc4MVOfceBAA8o6Nyc8W9RmiUIjm7Y +jFH4cDmfwZ+0OWCUBK+lEnrkuBe7Ll+LdRykbEbhEA1iN3mrAqnl1gVidgDVkSh gF0KS7SEi5Use/eZnoM2 =K2wd -----END PGP SIGNATURE----- --NrC4dM80tkMcao06J8XwNWLL3HHx5AIlE--