What does your pg_hba.conf look like? On Wed, Aug 26, 2009 at 11:36 AM, Bryan Richardson <[email protected]>wrote:
> Hmmm... your test does prove that something is still wrong. when I do a > 'psql -l' it shows me a list of databases. However, if I do a 'psql -l -h > 127.0.0.1' it states that 'Ident authentication failed for user > "<username>"'. I changed both the pg_hba.conf and postgresql.conf to allow > for localhost connections and localhost ident authentication. > > Any ideas? > > > On Tue, Aug 25, 2009 at 7:12 PM, Ryan L. Bell <[email protected]>wrote: > >> >> Have you tried connecting using psql over TCP/IP? >> >> psql -h 127.0.0.1 >> >> On Tue, Aug 25, 2009 at 06:00:04PM -0600, Bryan Richardson wrote: >> > Hmmm... I've edited my pg_hba.conf file to allow ident sameuser for >> > 127.0.0.1/32 and postgres is listening on 127.0.0.1:5432, and how I get >> a >> > 'The driver encountered an error: no connection available' error when I >> try >> > to connect using the following: >> > >> > adapter: jdbcpostgres >> > url: postgres://localhost:5432/<dbname> >> > >> > Any ideas? >> > >> > On Tue, Aug 25, 2009 at 5:26 PM, Ryan L. Bell <[email protected]> >> wrote: >> > >> > > >> > > It's not possible without changes to pg_hba.conf >> > > >> > > You need to setup connections from 127.0.0.1/32 to trust. >> > > >> > > /Ryan >> > > >> > > >> > > >> > > On Tue, Aug 25, 2009 at 04:58:57PM -0600, Bryan Richardson wrote: >> > > > Guess I should have stated that I did try a couple of different >> > > > configurations but to no avail. Can't remember all the configs I >> tried, >> > > but >> > > > they were along the lines of specifying jdbcpostgresql as the >> adapter, >> > > > specifying jdbc as the adapter and providing a url of >> > > > jdbc:postgresql:<dbname> and a driver of org.postgresql.Driver, >> > > specifying a >> > > > socket of /var/run/postgresql, etc. >> > > > >> > > > On Tue, Aug 25, 2009 at 2:59 PM, Nick Sieger <[email protected]> >> > > wrote: >> > > > >> > > > > On Aug 25, 2009, at 15:44 , Bryan Richardson wrote: >> > > > > >> > > > > Hello all, >> > > > >> >> > > > >> When I use postgresql with a regular Rails app, I can simply >> provide >> > > the >> > > > >> adapter and database name and ActiveRecord knows to try and >> access >> > > Postgres >> > > > >> on the local machine using the user Rails is running under. >> Thus, I >> > > don't >> > > > >> have to provide a password. Is this possible with the JDBC >> version? >> > > > >> >> > > > > >> > > > > Come to think of it, I'm not sure. It might work. Try it? >> > > > > >> > > > > /Nick >> > > > > >> > > > > _______________________________________________ >> > > > > Jruby-extras-devel mailing list >> > > > > [email protected] >> > > > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel >> > > > > >> > > >> > > > _______________________________________________ >> > > > Jruby-extras-devel mailing list >> > > > [email protected] >> > > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel >> > > >> > > -- >> > > >> > > Ryan L. Bell >> > > http://kofno.wordpress.com >> > > http://twitter.com/kofno >> > > http://github.com/kofno >> > > _______________________________________________ >> > > Jruby-extras-devel mailing list >> > > [email protected] >> > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel >> > > >> >> > _______________________________________________ >> > Jruby-extras-devel mailing list >> > [email protected] >> > http://rubyforge.org/mailman/listinfo/jruby-extras-devel >> >> -- >> >> Ryan L. Bell >> http://kofno.wordpress.com >> http://twitter.com/kofno >> http://github.com/kofno >> _______________________________________________ >> Jruby-extras-devel mailing list >> [email protected] >> http://rubyforge.org/mailman/listinfo/jruby-extras-devel >> > > > _______________________________________________ > Jruby-extras-devel mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/jruby-extras-devel > -- Ryan L. Bell http://kofno.wordpress.com http://twitter.com/kofno
_______________________________________________ Jruby-extras-devel mailing list [email protected] http://rubyforge.org/mailman/listinfo/jruby-extras-devel
