Coach Thrasher

Roller is Working

I've finally got Roller talking to my PostgreSQL database. I had been struggling with authentication issues for a very long time, and via trial and error it's finally solved. Here's the error I was seeing:

org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "rollerdb", SSL off

The root problem was setting the actual server hostname in my roller.xml config file for the JDBC connections. Geeze! I was using 127.0.0.1, and getting auth failures due to pg_hba.conf being strictly configured to localhost. I tried setting the roller.xml jdbc url to use the actual hostname (pg_hba.conf still had 127.0.0.1) and it worked!

Yay!

Posted at 02:22PM Jun 20, 2005 by jason in Software  |  Comments[0]