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@postgresql.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