pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Ray Stell <stellr@cns.vt.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: no verification of client certificate?
Date: Mon, 26 Mar 2007 08:00:04 -0600
Message-ID: <20070326140004.GA9109@winnie.fuhr.org> (raw)
In-Reply-To: <20070326133533.GA17380@cns.vt.edu>
References: <20070323181626.GA16092@cns.vt.edu>
	<25532.1174687277@sss.pgh.pa.us>
	<20070324020434.GA18533@cns.vt.edu>
	<1950.1174874480@sss.pgh.pa.us>
	<20070326025713.GA5653@winnie.fuhr.org>
	<3130.1174881861@sss.pgh.pa.us>
	<20070326133533.GA17380@cns.vt.edu>

On Mon, Mar 26, 2007 at 09:35:33AM -0400, Ray Stell wrote:
> Knowing how Michael traced the connection with ssldump would be
> VERY helpful.

The simple way is to run ssldump in one shell while running psql
in another:

ssldump -q port 5482    # my 8.2.3 db listens on port 5482

If I want to do more analysis I usually save the connection with
tcpdump first:

tcpdump -s0 -w dumpfile port 5482

The -s0 option is important: it tells tcpdump to capture the entire
packet.

When I'm done with psql I stop tcpdump and run ssldump over the dumpfile:

ssldump -r dumpfile -q

-- 
Michael Fuhr



view thread (13+ messages)  latest in thread

Message-ID: <20070326140004.GA9109@winnie.fuhr.org>
Permalink:  ../20070326140004.GA9109@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20070326140004.GA9109@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mike@fuhr.org, stellr@cns.vt.edu, tgl@sss.pgh.pa.us
  Subject: Re: no verification of client certificate?
  In-Reply-To: <20070326140004.GA9109@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox