From: | <tsmets(at)brutele(dot)be> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_hba.conf issue |
Date: | 2002-03-21 12:05:53 |
Message-ID: | 017001c1d0d0$c71ff5a0$6501a8c0@calvin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I wanna connect froma remote host to the Database via JDBC.
I modified the pg_hba.conf to this :
<snip>
# In the absence of preceding "host" lines, these two lines will reject
# all connection attempts from 192.168.54.1 (since that entry will be
# matched first), but allow Kerberos V5-validated connections from anywhere
# else on the Internet. The zero mask means that no bits of the host IP
# address are considered, so it matches any host:
#
host all 192.168.1.0 255.255.255.255 trust sameuser
</snip>
I got the following trace :
<snip>
94 [main] WARN org.test.JDBCPostgres.TestJDBCPostgres - Message : Something
unu
sual has occured to cause the driver to fail. Please report this exception:
Exce
ption: java.sql.SQLException: No pg_hba.conf entry for host 192.168.1.101,
user
jboss, database company Stack Trace:
java.sql.SQLException: No pg_hba.conf entry for host 192.168.1.101, user
jboss,
database company
at org.postgresql.Connection.openConnection(Connection.java:170)
at org.postgresql.Driver.connect(Driver.java:122)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
org.test.JDBCPostgres.TestJDBCPostgres.main(TestJDBCPostgres.java:27)
End of Stack Trace
</Snip>
My internal network is of course a 192.168.1.x
DB is
<snip>
[postgres(at)stackanov data]$ ifconfig
eth0 Link encap:Ethernet HWaddr 00:20:18:57:F5:C2
inet addr:192.168.1.103 Bcast:192.168.1.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:18748 errors:0 dropped:0 overruns:0 frame:0
TX packets:13860 errors:0 dropped:0 overruns:0 carrier:0
collisions:15 txqueuelen:100
RX bytes:1751819 (1.6 Mb) TX bytes:3281673 (3.1 Mb)
Interrupt:12 Base address:0xdc00
</snip>
While client is : 192.168.1.101
Could some one hint me on what I should do ?
tx,
thomas,
--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2002-03-21 12:14:17 | Re: pg_hba.conf issue |
Previous Message | Nick Haw | 2002-03-21 10:36:57 | Re: [NOVICE] Conditional constraint? |