Shorewall users - Jun 2004 - Postgres over VPN

Hi!

I''m dealing with a problem, I have a VPN connection (VPN Over SSH) at
school, at school I have a Postgres server and I can connect to the
server FROM any computer in my home network

Via Telnet:

$ telnet 192.168.3.1 5432
Trying 192.168.3.1...
Connected to 192.168.3.1.
Escape character is ''^]''.

However, when I try to use psql to connect I get this:
psql -d phonos -U telefonia -h 192.168.3.1 -W
Password: 
psql: FATAL 1:  No pg_hba.conf entry for host 192.168.1.2, user
telefonia, database phonos

Seems that school server is guessing my ip is 192.168.1.2 (home ip.. my
room, no vpn ip).

Any ideas? I don''t know if it''s a postgres topic, but thanks
anyway.

Pablo
-- 
Pablo Fischer Sandoval (pablo [arroba/at] pablo.com.mx)
Fingerprint:  5973 0F10 543F 54AE 1E41  EC81 0840 A10A 74A4 E5C0
http://www.pablo.com.mx 
http://www.debianmexico.org

Urhh...

So stupid, If I''m working in a VPN I should add an entry to 192.168.1.0
in the postgresql server.. 


Thanks!
Pablo
El jue, 03-06-2004 a las 12:43, Pablo Fischer escribió:
> Hi!
> 
> I''m dealing with a problem, I have a VPN connection (VPN Over SSH)
at
> school, at school I have a Postgres server and I can connect to the
> server FROM any computer in my home network
> 
> Via Telnet:
> 
> $ telnet 192.168.3.1 5432
> Trying 192.168.3.1...
> Connected to 192.168.3.1.
> Escape character is ''^]''.
> 
> However, when I try to use psql to connect I get this:
> psql -d phonos -U telefonia -h 192.168.3.1 -W
> Password: 
> psql: FATAL 1:  No pg_hba.conf entry for host 192.168.1.2, user
> telefonia, database phonos
> 
> Seems that school server is guessing my ip is 192.168.1.2 (home ip.. my
> room, no vpn ip).
> 
> Any ideas? I don''t know if it''s a postgres topic, but
thanks anyway.
> 
> Pablo
-- 
Pablo Fischer Sandoval (pablo [arroba/at] pablo.com.mx)
Fingerprint:  5973 0F10 543F 54AE 1E41  EC81 0840 A10A 74A4 E5C0
http://www.pablo.com.mx 
http://www.debianmexico.org