-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 RayDon,
On 3/1/2010 12:46 PM, RayDon1 wrote: > Caused by: org.postgresql.util.PSQLException: Connection refused. Seems pretty straightforward. > SERVER > Active Internet connections (servers and established) > Proto Recv-Q Send-Q Local Address Foreign Address State > tcp 0 0 *:5280 *:* LISTEN > tcp 0 0 linux:7777 *:* LISTEN > tcp 0 0 *:46178 *:* LISTEN > tcp 0 0 *:xmpp-client *:* LISTEN > tcp 0 0 localhost:mysql *:* LISTEN Running MySQL and Postgres on the same server?! > tcp 0 0 localhost:11211 *:* LISTEN > tcp 0 0 *:sunrpc *:* LISTEN > tcp 0 0 *:4369 *:* LISTEN > tcp 0 0 *:xmpp-server *:* LISTEN > tcp 0 0 *:ssh *:* LISTEN > tcp 0 0 *:postgresql *:* LISTEN > tcp 0 0 localhost:smtp *:* LISTEN > tcp 0 0 *:60828 *:* LISTEN > tcp 0 0 localhost:44891 localhost:61613 > ESTABLISHED > tcp 0 0 localhost:44893 localhost:61613 > ESTABLISHED > tcp 0 0 linux:ssh VAIO.lo:51445 ESTABLISHED > tcp 0 0 linux:ssh VAIO.lo:51443 ESTABLISHED > tcp 0 0 linux:ssh linux1:58261 > ESTABLISHED > tcp 0 0 linux:49632 192.168.5.10:telnet > ESTABLISHED > tcp 0 0 linux:xmpp-client 192.168.5.127:42116 > ESTABLISHED > tcp 0 0 localhost:35745 localhost:11211 > TIME_WAIT > tcp 0 0 linux:ssh VAIO.lo:51551 ESTABLISHED > tcp 0 0 linux:60873 xmpp-client ESTABLISHED > tcp 0 0 linux:xmpp-client 60873 ESTABLISHED > tcp 0 0 localhost:51494 localhost:4369 > ESTABLISHED > tcp 0 0 localhost:4369 localhost:51494 > ESTABLISHED > tcp 0 0 localhost:44892 localhost:61613 > ESTABLISHED > tcp6 0 0 [::]:8161 [::]:* LISTEN > tcp6 0 0 [::]:41025 [::]:* LISTEN > tcp6 0 0 localhost:8005 [::]:* LISTEN > tcp6 0 0 [::]:8009 [::]:* LISTEN > tcp6 0 0 localhost:61613 [::]:* LISTEN > tcp6 0 0 [::]:61616 [::]:* LISTEN > tcp6 0 0 [::]:www [::]:* LISTEN > tcp6 0 0 [::]:8180 [::]:* LISTEN > tcp6 0 0 [::]:ssh [::]:* LISTEN > tcp6 0 0 [::]:postgresql [::]:* LISTEN This one looks like PostgreSQL, though you appear to have the port numbers translated into "readable" port names so it's tough to tell. Note that the listen address is an IPv6 address, not IPv4. > 2) I checked pg_hba and the connections are set: > > # IPv4 local connections: > host all all 127.0.0.1/32 trust > host all all 192.168.5.5/24 trust > host all all 192.168.5.127/24 trust > > # IPv6 local connections: > host all all ::1/128 trust The above should be authorization preferences, and shouldn't cause a connection failure: instead, I would expect some other error. > What else can I check to get to the bottom of this bug? Do you have a software firewall? Make sure it allows localhost->localhost communications. > <Resource > name="jdbcConnectionString" > auth="Container" > type="javax.sql.DataSource" > driverClassName="org.postgresql.Driver" > url="jdbc:postgresql://localhost:5432/testdb" I agree with Chuck: it's possible that "localhost" refers to an IPv4 address and therefore won't connect as your PostgreSQL looks like it's bound to an IPv6 address. I'm not sure if they're entirely compatible. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkuNfYQACgkQ9CaO5/Lv0PAG1ACfarawx8jTsSseojisnbqCte1I BH0AoLGDc88N0YXxUBwnP6t3wzW70t/f =W/Cm -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
