From: Curt Hibbs <curt@...>
Date: 2004-11-30T12:55:02+09:00
Subject: Re: [ANN] postgres-pr (pure Ruby PostgreSQL)

Abraham Vionas wrote:
>
> Thanks for the response Michael!
>
> I looked into the topics you suggested and I think I made some progress...
> at least now I can see attempts to connect to the db in the
> postgresql log.
> However, it says that my user names don't exist, when I know they exist
> because I can see them from psql - and from PGAdmin III. Any ideas?
>
> My entry in the database.yml is:
>
> production:
>   adapter: postgresql
>   database: todo
>   host: localhost
>   port: 5432
>   username: root
>
> Errors in Postgresql log:
>
> 2004-11-29 19:49:02 FATAL:  user "abrahamvionas_sr	" does not exist
> 2004-11-29 19:57:59 FATAL:  user "root	" does not exist
> 2004-11-29 19:58:11 FATAL:  user "root	" does not exist

From the text above it looks lik you've got a tab character at the end of
your username. Perhaps root<tab> is being sent to the database, keeping the
username from matching. Try deleting this extraneous tab character and see
if that helps.

Curt

> -----Original Message-----
> From: Michael Neumann [mailto:mneumann@ntecs.de]
> Sent: Monday, November 29, 2004 5:14 PM
> To: ruby-talk ML
> Subject: Re: [ANN] postgres-pr (pure Ruby PostgreSQL)
>
> Abraham Vionas wrote:
> > Michael;
> >
> > Does this mean there is a new Postgres-PR release available for
> > download/update?
>
> You already have the newest version (0.2.2).
>
> > Also, I think the problems I'm having with a tutorial I'm
> working through
> > are related to Activerecord not communicating through PostgresPR...
>
> No, it communicates through PostgresPR, I'm sure!
>
> > It looks like it goes to it's connection_modules directory looking for a
> valid
> > postgres connector and the default postgres connector included with
> > Activerecord doesn't work for some reason. The precise error is below...
> but
> > I'm curious how I can ensure (what settings to check, file
> locations, etc)
> > that Activerecord can communicate to and through PostgresPR...?
>
> You don't have to setup anything.
>
> > RuntimeError in Todo#index
> >
> > authentification failed
>
> The problem is with authentification. You have either specified a wrong
> user/password combination for Postgres, or it's an authentification
> method that postgres-pr is not-yet capable of. Can you setup your
> Postgres-database to either use password-less or plain-text password
> authentification?
>
> Regards,
>
>    Michael
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.799 / Virus Database: 543 - Release Date: 11/19/2004
>