[prev in list] [next in list] [prev in thread] [next in thread]
List: ruby-talk
Subject: Connecting to PostgreSQL Database
From: Matt White <whiteqt () gmail ! com>
Date: 2007-10-01 15:00:04
Message-ID: 1191250700.115697.135490 () o80g2000hse ! googlegroups ! com
[Download RAW message or body]
Hello,
I am trying to move data from one postgres database to another using
the Ruby postgres adapter. However, I keep getting a password
authentication error whenever I try. My sysadmin keeps indicating that
there is no password on that database and the Rails apps I use don't
indicate any password in database.yml and work fine. Am I being lied
to or is there some other secret I don't know? Thanks for any help or
suggestions. Here's the code I'm using (and line 184 DOES work):
184: db1 = PGconn.connect('dbserver1.blah.com', 5432, '', '',
'database1_name', 'username', 'password')
185: db2 = PGconn.connect('dbserver2.blah.com', 5432, '', '',
'database2_name', 'username', '')
And here's the error:
c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/
connection.rb:55:in `initialize': FATAL C28000 MPassword
authentication failed for user "username" Fauth.c L395
Rauth_failed (RuntimeError)
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/connection.rb:29:in `loop'
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/connection.rb:29:in `initialize'
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/postgres-compat.rb:23:in `new'
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/postgres-compat.rb:23:in `initialize'
from DataFetcher.rb:185:in `connect'
from DataFetcher.rb:185
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic