Re: pg_hba.conf: 'trust' vs. 'md5' Issues

On Tue, 26 Sep 2006, Jeanna Geier wrote:

> Hi All-
>
> If I change the hostssl line to: hostssl all all 127.0.0.1/32 md5, restart
> the server, and attempt to connect via pgadmin, I see the message 'Connecting
> to the database... Failed.' If I attempt to connect to a database using the
> command line:
> C:\msys\1.0\local\pgsql\bin>psql -d apt -U postgres
> Password:
> psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres",
> database "apt", SSL off
> C:\msys\1.0\local\pgsql\bin>
>

Jeanna,

It seems that for some reason either your server or your client are not trying
to use SSL. Note the: "SSL off" in the error message you received. Do you
have a server.crt in the data directory of the postgres server?

When you have the hostssl line set for trust, do you get something like this
when you connect with psql:

Welcome to psql 8.0.8, 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)

Or are you missing the SSL connection line?

--
Jeff 'Frosty' Frost - AFM #996 - Frost Consulting, LLC Racing
http://www.frostconsultingllc.com/ http://www.motonation.com/
http://www.suomy-usa.com/ http://www.motionpro.com/
http://www.motorexusa.com/ http://www.lockhartphillipsusa.com/
http://www.zoomzoomtrackdays.com/ http://www.braking.com/