From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | Alex Nordlund <deep(dot)alexander(at)gmail(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Date: | 2011-08-10 16:13:59 |
Message-ID: | 34e79221191a14cc34765d519243eeab@mail.softperience.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Nordlund | 2011-08-10 16:19:13 | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Previous Message | Alex Nordlund | 2011-08-10 12:53:59 | Cannot create PoolableConnectionFactory (The connection attempt failed.) |