[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Connecting to PostgreSQL Database

Matt White

10/1/2007 2:58:00 PM

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
4 Answers

Anthony Eden

10/1/2007 3:06:00 PM

0

On 10/1/07, Matt White <whiteqt@gmail.com> wrote:
> 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

Have you tried giving it a nil for the password rather than an empty string?

V/r
Anthony

--
Cell: 321 473-4966
Current Location: Melbourne, FL

Caleb Tennis

10/1/2007 3:16:00 PM

0

> 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', '')

Are you sure that the passwordless connection works okay from the machine you're
attempting from? You can configure postgres to only accept connections from certain
ip addresses for certain users. A lot of times, the default is to allow
passwordless login from localhost, but not from remote hosts.

Matt White

10/1/2007 3:35:00 PM

0

On Oct 1, 9:15 am, "Caleb Tennis" <ca...@aei-tech.com> wrote:
> > 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', '')
>
> Are you sure that the passwordless connection works okay from the machine you're
> attempting from? You can configure postgres to only accept connections from certain
> ip addresses for certain users. A lot of times, the default is to allow
> passwordless login from localhost, but not from remote hosts.

I tried using nil and got a 'no password specified error'.

Looking at the pg_hba.conf file I see the login I'm using allowed for
both internet IP addresses we have, so it's not just restricted to
localhost. Any other ideas?

Matt White

10/1/2007 7:44:00 PM

0

Turns out I *was* lied to. There is a password on there. Sorry to
trouble you all.