Обсуждение: ODBC over Internet

Hi,

probably i am not the first asking this question:

When trying to connect to the backend tis rejects with:

User authentication failed
/usr/local/pgsql/bin/postmaster: ServerLoop:            handling writing
8

the postmaster is started with the following Options:

 -i -d 3  -B 256 -D ${PGDATA}

on client (ODBC) side the user- server- and portfield are filled in. the
port is controlled via loval telnet.

the $PGDATA/pg_hba.conf is:

local        all                                         trust
host         all         127.0.0.1     255.255.255.255   trust
#host         all         212.8.193.0   255.255.255.255   password
pg_pwd # (doesn't fitt too)
host         all         212.8.193.0   255.255.255.255   ident

I found no helping hint in the docs. Would anybody write a short
mini-HOWTO who fixed this problem?

yours joerg

On Sun, 11 Oct 1998, Jrg Bernau wrote:

[snip]

> the $PGDATA/pg_hba.conf is:
>
> local        all                                         trust
> host         all         127.0.0.1     255.255.255.255   trust
> #host         all         212.8.193.0   255.255.255.255   password
> pg_pwd # (doesn't fitt too)
> host         all         212.8.193.0   255.255.255.255   ident

At first glance, this doesn't look right. The IP address is for an entire
class C net, so for that line to be valid, you would need 255.255.255.0 as
the net mask.

Peter

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf