Problem with the conection

From: mjgacto(at)ugr(dot)es
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Problem with the conection
Date: 2009-03-12 16:09:10
Message-ID: 1155.150.214.205.107.1236874150.squirrel@goliat13.ugr.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have problem with the conection to my database postgres.
I have no problem with the conection in my server (150.xxx.xxx.xxx) and in
the computers with ip near my server. For example if my server
ip is 150.111.111.111 I can connect with 150.111.111.222 or 150.111.111.113

I connect using the following code:
try{
Class.forName("org.postgresql.Driver").newInstance();
return
DriverManager.getConnection("jdbc:postgresql://150.xxx.xxx.xxx/database?charSet=LATIN1",
user,password);
}
catch(ClassNotFoundException e){
}

The problem happens when I try to connect with the java program to my
server in a computer with 161.x.x.x ip.
In the log file I find this message.

Mar 11 11:42:01 ec3 kernel: SFW2-INext-ACC-TCP IN=eth0 OUT=
MAC=00:30:48:70:1f:e9:00:07:0d:b7:64:00:08:00 SRC=161.xxx.xxx.xxx
DST=150.xxx.xxx.xxx LEN=48 TOS=0x00 PREC=0x00 TTL=116 ID=30787 DF
PROTO=TCP SPT=1708 DPT=5432 WINDOW=65535 RES=0x00 SYN URGP=0 OPT
(0204056401010402)

In the computer with ip 161.xxx.xxx.xxx they open port 5432 (for using
postgres) and I include this lines in the pg_hba.conf file

host database user 150.111.111.111 255.255.255.255 trust
host database user 150.111.111.222 255.255.255.255 trust
host database user 161.xxx.xxx.xxx 255.255.255.255 trust

Can someone help me with this problem?
Thanks.

MJ

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabricio 2009-03-12 18:17:52 out of memory
Previous Message Carol Walter 2009-03-12 14:44:58 Re: Problem database access