Failing tcp/ip connection - Mailing list 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.<fontfamily><param>Helvetica</param>

</fontfamily>################################################################

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


<fontfamily><param>Helvetica</param>--

Thiemo Kellner

Tösstalstrasse 146

CH-8400 Winterthur

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