Failing tcp/ip connection

From: thiemo <thiemo(at)gmx(dot)ch>
To: pgNovice <pgsql-novice(at)postgresql(dot)org>
Subject: Failing tcp/ip connection
Date: 2002-04-11 21:19:31
Message-ID: D031E668-4D91-11D6-BB95-000A27D62F9E@gmx.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I try to set up a jdbc connection but I fail. I think I have set it up
correctly however with dbvisualizer I get the following error when I try
to connect.

################################################################
Etwas ungewöhnliches ist passiert. Bitte Teilen Sie diesem Fehler mit:
Exception: java.sql.SQLException: FATAL 1: No pg_hba.conf entry for
host 192.168.0.249, user postgres, database template1

Stack Trace:

java.sql.SQLException: FATAL 1: No pg_hba.conf entry for host
192.168.0.249, user postgres, database template1

at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection
(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$0(Database.java:170)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1022)
at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:161)
at se.pureit.util.ThreadCommand.run(ThreadCommand.java:141)
at java.lang.Thread.run(Thread.java:496)
End of Stack Trace

Etwas ungewöhnliches ist passiert. Bitte Teilen Sie diesem Fehler mit:
Exception: java.sql.SQLException: FATAL 1: No pg_hba.conf entry for
host 192.168.0.249, user postgres, database template1

Stack Trace:

java.sql.SQLException: FATAL 1: No pg_hba.conf entry for host
192.168.0.249, user postgres, database template1

at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection
(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$0(Database.java:170)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1022)
at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:161)
at se.pureit.util.ThreadCommand.run(ThreadCommand.java:141)
at java.lang.Thread.run(Thread.java:496)
End of Stack Trace
##############################################################

My pg_hba.conf looks like this (at least the lines that aren't commented
out). This file is located where my database directory is
(/var/lib/pgsql). The third line is not necessairy as I understand. I
put it to figure out if line 4 was bad.
################################################################
local all crypt
host all 127.0.0.1 255.255.255.255 crypt
host all 192.168.0.249 255.255.255.255 crypt
host all 192.168.0.0 255.255.255.0 crypt
################################################################

I feel a bit stupid as I already had a running 7.2 on this machine, but
I didn't want to run into sequence trouble anyhow. As I had about
nothing on the 7.2 I just erased the databse directory.

I'd appreciate any help.

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-04-11 23:21:22 Re: Failing tcp/ip connection
Previous Message thiemo 2002-04-11 20:17:48 Re: Date format