tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Cannot create PoolableConnectionFactory
Date Tue, 02 Mar 2010 21:05:08 GMT
-----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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message