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
