From: Abraham Vionas <abe_ml@...>
Date: 2004-11-24T00:25:11+09:00
Subject: Re: PostgreSQL (Postgres-pr) + Rails = Unexpected EOF error?

Thanks for the helpful instructions Dick. :)

I hadn't yet tried getting in with psql, but using what you described I was
able to get in with the settings I have currently established in the
database.yaml file. 

Talk about frustrating, I think I'm gonna have to break out my process
viewer so I can see what files this baby touches. UGH. 

-----Original Message-----
From: Rasputin [mailto:rasputin@hellooperator.net] On Behalf Of Dick Davies
Sent: Tuesday, November 23, 2004 3:02 AM
To: ruby-talk ML
Subject: Re: PostgreSQL (Postgres-pr) + Rails = Unexpected EOF error?

* Abraham Vionas <abe_ml@bozemantechmedic.com> [1118 07:18]:
>  I'm running XP, Ruby 1.8.2RC3, Rails 0.8.5, PostgreSQL 8BetaRC3, and 
> Postgres-pr (new Ruby library).
> 
> My problem is that I'm getting an "Unexpected EOF error on client 
> connection."
> 
> Does anyone perchance know what's causing this? It happens both on 
> Webrick and Apache.

I had it last night for a bit, it was a bad database.yml setting.
Can you get in with psql?

The following database.yml: 

production:
  adapter: postgresql
  database: dbname
  host: db.server
  username: dbuser
  password: dbpass


maps to 

psql -U dbuser -h db.server dbname
<enter dbpass when prompted>

If you can't see your tables (type \dt once you're in psql), create them.

--
Everybody I know who is right always agrees with ME. - Rev Lady Mal Rasputin
:: Jack of All Trades - Master of Nuns