Thread: ODBC and unknown i.p.

ODBC and unknown i.p.

From
Mike Alford
Date:
I am using postgres 7.3.1 on a slackware linux server and psqlodbc.exe
version 07.02.0005. I am a novice at both linux and postgres
administration.  We are in the process of converting from a SCO unix server
with Ingres1.2 database to the aforementioned linux/postgres server. Our
application is distributed to customers around the world and uses ODBC
connections in VB applications. With our old system, we only had to be able
to connect to the database server through ODBC and user/password security.
It appears that there is another level with postgres--namely the addition
of entries into pg_hba.conf, which include the i.p.and subnet. Since this
is a distributed application, we have no way to know in advance what the ip
and subnet of users at a given site will be, much less when a customer
changes his local network. I tried a VB app without an entry in pg_hba.conf
and failed, but succeed when the entry is added.

Is there an easy way around the pg_hba.conf problem? If not, has anyone who
has dealt with this issue have any suggestions?
Do not try to solve all life's problems at once -- learn to dread each
day as it comes.


Re: ODBC and unknown i.p.

From
Michael Weaver
Date:

Mike,
Have you tried adding an entry for the entire Internet?
eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0

Mike.(also)

> -----Original Message-----
> From: Mike Alford [mailto:mikea@syscon-intl.com]
> Sent: Monday, 10 February 2003 9:44 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] ODBC and unknown i.p.
>
>
> I am using postgres 7.3.1 on a slackware linux server and psqlodbc.exe
> version 07.02.0005. I am a novice at both linux and postgres
> administration.  We are in the process of converting from a
> SCO unix server
> with Ingres1.2 database to the aforementioned linux/postgres
> server. Our
> application is distributed to customers around the world and uses ODBC
> connections in VB applications. With our old system, we only
> had to be able
> to connect to the database server through ODBC and
> user/password security.
> It appears that there is another level with postgres--namely
> the addition
> of entries into pg_hba.conf, which include the i.p.and
> subnet. Since this
> is a distributed application, we have no way to know in
> advance what the ip
> and subnet of users at a given site will be, much less when a customer
> changes his local network. I tried a VB app without an entry
> in pg_hba.conf
> and failed, but succeed when the entry is added.
>
> Is there an easy way around the pg_hba.conf problem? If not,
> has anyone who
> has dealt with this issue have any suggestions?
> Do not try to solve all life's problems at once -- learn to dread each
> day as it comes.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Re: ODBC and unknown i.p.

From
Mike Alford
Date:
Thanks. That did the trick. I knew there had to be a simple solution.

At 04:14 PM 2/11/03 +0800, you wrote:

>
> Mike,
> Have you tried adding an entry for the entire Internet?
> eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0
>
> Mike.(also)
>
> > -----Original Message-----
> > From: Mike Alford
> [<mailto:mikea@syscon-intl.com>mailto:mikea@syscon-intl.com]
> > Sent: Monday, 10 February 2003 9:44 PM
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] ODBC and unknown i.p.
> >
> >
> > I am using postgres 7.3.1 on a slackware linux server and psqlodbc.exe
> > version 07.02.0005. I am a novice at both linux and postgres
> > administration.  We are in the process of converting from a
> > SCO unix server
> > with Ingres1.2 database to the aforementioned linux/postgres
> > server. Our
> > application is distributed to customers around the world and uses ODBC
> > connections in VB applications. With our old system, we only
> > had to be able
> > to connect to the database server through ODBC and
> > user/password security.
> > It appears that there is another level with postgres--namely
> > the addition
> > of entries into pg_hba.conf, which include the i.p.and
> > subnet. Since this
> > is a distributed application, we have no way to know in
> > advance what the ip
> > and subnet of users at a given site will be, much less when a customer
> > changes his local network. I tried a VB app without an entry
> > in pg_hba.conf
> > and failed, but succeed when the entry is added.
> >
> > Is there an easy way around the pg_hba.conf problem? If not,
> > has anyone who
> > has dealt with this issue have any suggestions?
> > Do not try to solve all life's problems at once -- learn to dread each
> > day as it comes.
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >
> <http://www.postgresql.org/users-lounge/docs/faq.html>http://www.postgresq
> l.org/users-lounge/docs/faq.html
> >



Do not try to solve all life's problems at once -- learn to dread each
day as it comes.