On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <pjkoczan@xxxxxxxxx> wrote: > Hi all, > > I'm looking to add an md5-based user to a postgres server, and I can't > seem to get psql to connect using SSL. Normally I use Kerberos to > connect, and that works flawlessly with SSL. I'd much prefer to use > SSL connections, so I'm wondering if there's something I'm doing > wrong. > > Here's what happens with a Kerberos connection...works just fine, > connects using SSL: > > $ /s/postgresql/bin/psql -h dumbo.cs.wisc.edu -p 5432 koczan_test > Welcome to psql 8.3.4, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) > > koczan_test=> > > And an md5 connection... > > $ /s/postgresql/bin/psql -h dumbo.cs.wisc.edu -p 5432 -U test_md5 koczan_test > Password for user test_md5: > psql: FATAL: no pg_hba.conf entry for host "128.105.162.36", user > "test_md5", database "koczan_test", SSL off According to this, you're trying to connect with SSL off, right? I don't think you've got any matching lines for that in your pg_hba.conf. But I could be reading that wrong. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
