Обсуждение: Problem with the conection
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
host database user 161.0.0.0/8 md5
host database user 161.0.0.0/8 trust
# "local" is for Unix domain socket connections only
local all all trust
make sure other "public" 161.x.x.x ip cannot access your server because i don't think 161.x.x.x is a private subnet.
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Also may want to set 255.255.255.255/0 trust and then test access. I found that this seems to allow access from anywhere and then maybe tie it down.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tommy Cheng
Sent: Sunday, March 15, 2009 10:50 PM
To: mjgacto@ugr.es; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problem with the conection
try adding these few lines:
host database user 161.0.0.0/8 md5
host database user 161.0.0.0/8 trust
# "local" is for Unix domain socket connections only
local all all trust
make sure other "public" 161.x.x.x ip cannot access your server because i don't think 161.x.x.x is a private subnet.
On Fri, Mar 13, 2009 at 12:09 AM, <mjgacto@ugr.es> wrote:
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin