|
From: Markus M. <me...@gm...> - 2016-04-21 22:02:38
|
Hi John and others: I used nmap: nmap -p T:5432 localhost ouput: Port state Service 5432/tcp open postgresql So, the port should be reachable. I executed the tcpdump command on the linux server and ran squirell. This is the ouput: 14:36:32.1111111 IP hostname.58260 > hostname.postgres: Flags [S], seq 1111111111, win 8192, options [mss 1460,nop,wscale 8,nop,nop,sackOK], length 0 14:36:35.222222 IP hostname.58260 > hostname.postgres: Flags [S], seq 1111111111, win 8192, options [mss 1460,nop,wscale 8,nop,nop,sackOK], length 0 14:36:41.222222 IP hostname.58260 > hostname.postgres: Flags [S], seq 1111111111, win 8192, options [mss 1460,nop,nop,sackOK], length 0 Not sure what it means. Can you please help? Thank you, Markus On Thu, Apr 21, 2016 at 2:33 PM, John Hardin <jh...@im...> wrote: > On Thu, 21 Apr 2016, Markus Metz wrote: > > Java.util.concurrent.ExecutionException: java.lang.RuntimeException: >> org.postgresql.util.PSQLException: Connection to 10.2.44.27:5432 refused. >> > > Can you telnet to 10.2.44.27:5432 from the client? Granted you probably > won't be able to talk the postgres protocol, but that would confirm whether > or not you have basic network connectivity. > > Just to confirm that squirrel actually is attempting to connect: > immediately after getting that error, on the client run a netstat command. > You *should* see a TCP connection with the database server's IP/name and > port number on the "far end". > > You could also run something like "tcpdump -i eth0 tcp port 5432" on your > client (assuming *nix and needed privileges) to see whether it's trying a > network connection. > > -- > John Hardin KA7OHZ http://www.impsec.org/~jhardin/ > jh...@im... FALaholic #11174 pgpk -a jh...@im... > key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 > ----------------------------------------------------------------------- > Phobias should not be the basis for laws. > ----------------------------------------------------------------------- > 2 days until Max Planck's 158th birthday > |
