Thread: User Authentication Problem

User Authentication Problem

From
Bryan Brunton
Date:

I installed Postgres from RPMs from a RedHat site on to RH 5.0.

I didn't have the latest ncurses library and I had I had to do a --force
to get that to install.

I have user authentication turned off with the trust parameter in
pg_hba.conf.

I can connect fine from the local machine with pgsql to postgres user or
to
new users I have created.  However, over IP, with ODBC and with pgaccess

(using the server's IP), I always get user authentication failure.
However with
the trust parameter, there should be no user authenitication being
attempted!

What's wrong here?

Please send reply to bryan@flesherfab.com

RE: User Authentication Problem

From
Bryan Brunton
Date:
The RPMS that I got from a Red Hat mirror appear to have been to
source of the problem (at least on my non-upgraded Red Hat 5.0
machine).

I compiled the source and everything works great.

Thanks to all for making the DB possible.  If things go well just tell
me where to mail the check for one of your CDs.

> -----Original Message-----
> From:    Bryan Brunton
> Sent:    Tuesday, August 11, 1998 11:57 AM
> To:    'pgsql-admin@postgresql.org'
> Subject:    User Authentication Problem
>
>
>
> I installed Postgres from RPMs from a RedHat site on to RH 5.0.
>
> I didn't have the latest ncurses library and I had I had to do a
> --force
> to get that to install.
>
> I have user authentication turned off with the trust parameter in
> pg_hba.conf.
>
> I can connect fine from the local machine with pgsql to postgres user
> or to
> new users I have created.  However, over IP, with ODBC and with
> pgaccess
> (using the server's IP), I always get user authentication failure.
> However with
> the trust parameter, there should be no user authenitication being
> attempted!
>
> What's wrong here?
>
> Please send reply to bryan@flesherfab.com