Thread: Users ip

Users ip

From
"Jai"
Date:
The project i am working on uses a postgres db accessed mainly from a
browser using java. We also require a direct connection for some clients
using odbc (with ssl) from a windows application. This works fine but
requires the client to have an ip address specified in the pg_hba.conf. If
the user doesn't have a static ip address then obviously there can be no
entry for them in pg_hba.conf. Is there a solution to this so that direct
connections using odbc can still be used?

Thanks

Jai



Re: Users ip

From
Brickley Jeff-RA9607
Date:
Are your clients connecting from the same domain?  If so you can specify the ip domain as a whole to allow them access
usingwild cards. 

Jeff

-----Original Message-----
From: Jai [mailto:jive@ntlworld.com]
Sent: Tuesday, August 20, 2002 8:51 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Users ip


The project i am working on uses a postgres db accessed mainly from a
browser using java. We also require a direct connection for some clients
using odbc (with ssl) from a windows application. This works fine but
requires the client to have an ip address specified in the pg_hba.conf. If
the user doesn't have a static ip address then obviously there can be no
entry for them in pg_hba.conf. Is there a solution to this so that direct
connections using odbc can still be used?

Thanks

Jai



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Users ip

From
"Jai"
Date:
not necessarily. suppose the only way is to allow access to of all ip's with
wild cards, this is possible isn't it?

"Brickley Jeff-RA9607" <Jeff.Brickley@motorola.com> wrote in message
news:7146D19B7FC9D5119F6400D0B7B993080318C98D@az33exm22.corp.mot.com...
> Are your clients connecting from the same domain?  If so you can specify
the ip domain as a whole to allow them access using wild cards.
>
> Jeff
>
> -----Original Message-----
> From: Jai [mailto:jive@ntlworld.com]
> Sent: Tuesday, August 20, 2002 8:51 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Users ip
>
>
> The project i am working on uses a postgres db accessed mainly from a
> browser using java. We also require a direct connection for some clients
> using odbc (with ssl) from a windows application. This works fine but
> requires the client to have an ip address specified in the pg_hba.conf. If
> the user doesn't have a static ip address then obviously there can be no
> entry for them in pg_hba.conf. Is there a solution to this so that direct
> connections using odbc can still be used?
>
> Thanks
>
> Jai
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster