Skip site navigation (1) Skip section navigation (2)

Re: SSL and md5 password?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SSL and md5 password?
Date: 2008-10-29 18:49:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <pjkoczan(at)gmail(dot)com> 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 just fine,
> connects using SSL:
> $ /s/postgresql/bin/psql -h -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 -p 5432 -U test_md5 koczan_test
> Password for user test_md5:
> psql: FATAL:  no pg_hba.conf entry for host "", 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.

In response to


pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-10-29 18:54:34
Subject: Re: SSL and md5 password?
Previous:From: Peter KoczanDate: 2008-10-29 17:19:12
Subject: Re: Recovering disk space...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group