Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)

Ok,

Try add following for your Tomact's Java (I haven't worked for years with
Tomcat but there may be run.bat, run.sh, it will be probaly somewhere near "-
mx"):
-Djava.net.preferIPv4Stack=true

and/or (on Linux)
echo 0 > /proc/sys/net/ipv6/bindv6only

and/or
expose PostgreSQL on IPv6, and change hostname to ::1

Regards,
Radek

Alex Nordlund <deep(dot)alexander(at)gmail(dot)com> Wednesday 10 of August 2011 18:48:34
> Hi,
>
> Same result with 127.0.0.1
>
> 2011-08-10 13:14:30,615 main ERROR
> [org.hibernate.util.JDBCExceptionReporter] Cannot create
> PoolableConnectionFactory (The connection attempt failed.)
> 2011-08-10 13:14:30,618 main WARN [org.hibernate.cfg.SettingsFactory]
> Could not obtain connection metadata
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (The connection attempt failed.)
> [snip 60 lines]
> Caused by: org.postgresql.util.PSQLException: The connection attempt
> failed.
>
> With risk for looping (my eyes are tired and do not easily spot where
> the log ends) I have the full log here.
> http://dpaste.org/6O5d/
>
>
> ---
> //Alex
>
>
>
> On Wed, Aug 10, 2011 at 5:31 PM, Radosław Smogura
>
> <rsmogura(at)softperience(dot)eu> wrote:
> > So it's harder topic,
> > - try to replace localhost with 127.0.0.1
> > I don't know why You don't have (didn't send) PostgreSQL exception, try
> > to connect to server with simple servlet, using old fashioned JNDI,
> > check hibernate configuration.
> >
> > It's hard to see if You have passed wrong JNDI name, you have no driver
> > in classpath, or it's PostgreSQL exception. Send full backtrace of
> > error.
> >
> > Regards
> >
> > On Wed, 10 Aug 2011 17:19:13 +0100, Alex Nordlund wrote:
> >> Hi Radoslaw,
> >>
> >> Thank you for your reply.
> >>
> >> I can confirm that with psql --host=127.0.0.1 it works, however it
> >> still does not work with jdbc.
> >>
> >> ---
> >> //Alex
> >>
> >>
> >>
> >> On Wed, Aug 10, 2011 at 5:13 PM, Radosław Smogura
> >>
> >> <rsmogura(at)softperience(dot)eu> wrote:
> >>> Hi,
> >>>
> >>> Check your "access file" pga_hba.conf if it allows TCP/IP connections.
> >>> By default psql connects on Unix socket
> >>> try to connect using
> >>> psql --host=127.0.0.0.1 --port=5432 -U crowd crowdiddb
> >>>
> >>> I this fail You probably didn't exposed TCP/IP access (or You have
> >>> localhost
> >>> firewall?).
> >>>
> >>> Regards,
> >>> Radosław Smogura
> >>>
> >>> On Wed, 10 Aug 2011 13:53:59 +0100, Alex Nordlund wrote:
> >>>> Hi,
> >>>>
> >>>> I get the following errors:
> >>>>
> >>>> INFO: Deploying configuration descriptor openidserver.xml
> >>>> 2011-08-10 13:14:30,600 main WARN
> >>>> [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState:
> >>>> null
> >>>> 2011-08-10 13:14:30,615 main ERROR
> >>>> [org.hibernate.util.JDBCExceptionReporter] Cannot create
> >>>> PoolableConnectionFactory (The connection attempt failed.)
> >>>> 2011-08-10 13:14:30,618 main WARN [org.hibernate.cfg.SettingsFactory]
> >>>> Could not obtain connection metadata
> >>>> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> >>>> PoolableConnectionFactory (The connection attempt failed.
> >>>>
> >>>> And my Resource looks like this:
> >>>>
> >>>> <Resource name="jdbc/CrowdIDDS" auth="Container"
> >>>> type="javax.sql.DataSource"
> >>>> username="crowd"
> >>>> password="hiddenfortheml"
> >>>> driverClassName="org.postgresql.Driver"
> >>>> url="jdbc:postgresql://localhost:5432/crowdiddb"
> >>>> />
> >>>>
> >>>>
> >>>> Am I doing something wrong?
> >>>>
> >>>> My username is crowd, it's set to only use MD5 auth, the DB is
> >>>> crowdiddb and I can access it using psql.
> >>>>
> >>>> ---
> >>>> //Alex