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
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 |