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

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
>>>
>>>
>
>