Which problem,
postgres or ident?
I can't remember postgres configuration, as I have not setup a server in a
while, but I do remember it wasn't straight forward.
ident. Are you running an ident server on the host which your application is
running?
$telnet localhost 113
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
if you can telnet to 113 on the host you are running then you are running an
ident server and then there is some other problem. Can you telnet from the
postgres host to the application host on port 113? If that works, then there
is something wrong with postgres config. If not then maybe you have a
firewall in the middle, or some router with ACL.
I have probably gone too far now.
You could probably try to remove the ident bit and make your ACL less verbose,
eg:
host all 192.168.0.0 255.255.255.0
But I can't remember the config for postgres, RTFM.
Good luck,
Greg
On Sat, 1 May 2004 12:41 pm, pesoy misak wrote:
> Dear all
>
> I am trying to connect my java program remotely using postgres database.
> when trying to connect the it seem my user name is rejected.
>
> I have put this configuration for my pg_hba.conf
> local all ident sameuser
> host all 0.0.0.0 0.0.0.0 ident sameuser
>
> and when I check on the log it said
> Unable to connect to Ident server on the host which is trying to connect to
> Post gres (IP address 192.168.0.1, Port 113). errno = Connection refused
> (111)
>
> in my program I put
> DriverManager.getConnection("jdbc:postgresql://192.168.0.2/xxx","xxxx","xxx
>");
>
> is anyone know how to solve this problem?
>
> many thanks in advance
>
>
> ---------------------------------
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
