Re: pg_hba.conf and password files

Hi Markus,

I can't help you with the Access problem, but I'll just mention that creating
usr.txt line that won't work, as the password needs to be encrypted. Use the
pg_passwd program to create the user details and it will encrypt it for you.

Gary

On Tuesday 07 August 2001 10:26 am, Markus Wagner wrote:
> Hi,
>
> I use a pg_hba.conf like this:
>
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all 134.93.64.0 255.255.255.0 password usr.txt
>
> In usr.txt I made one entry "test:test". When I connect with Access, the
> DSN dialog appears, and I enter "test" and "test" in the corresponding
> fields for username and password. The connect fails, and the postgres.log
> says: "user 'wagner' not found in password file". It seems that the
> username "test" does not make it to the backend, and my Windows username
> "wagner" is sent instead.
>
> Any hints?
>
> Thanks,
>
> Markus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Gary Stainburn

This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000