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/