From: Abraham Vionas <abe_ml@...>
Date: 2004-11-30T15:37:02+09:00
Subject: Yippee! Todo tutorial finally working and with postgresPR! (WAS [ANN] postgres-pr)

Yep, it's true. I'm kind of bleary eyed but if memory serves my problem may
have been heavily related to the fact that my database.yml file had extra
lines at the end. I.e. the configuration ended on line 19 (?) but the file
technically had another two lines in it (looking at it in a utility like
UltraEdit). Fixing that seemed to do the trick if I recall correctly. 

Thanks for the idea Curt!



-----Original Message-----
From: Curt Hibbs [mailto:curt@hibbs.com] 
Sent: Monday, November 29, 2004 8:55 PM
To: ruby-talk ML
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
>