pg_hba.conf issue
От | |
---|---|
Тема | pg_hba.conf issue |
Дата | |
Msg-id | 017001c1d0d0$c71ff5a0$6501a8c0@calvin обсуждение исходный текст |
Список | 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@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
В списке pgsql-general по дате отправления: