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