Using ActiveRecord in a Ruby script not working

rubyonrails-talk
1

Greetings! I am trying to use ActiveRecord in a non-Rails script to access a database, but I'm not doing something right apparently:

require 'rubygems' require 'active_record'

ActiveRecord::Base.establish_connection(   :adapter => "postgresql",   :host => "myhost.org",   :port => 1234,   :username => "myuser",   :password => "mypass",   :database => "mydb" )

conn = ActiveRecord::Base.connection

puts conn.active?

When I try to run this code, I get an exception when trying to retrieve the connection:

:~/ruby$ ruby activerecordtest.rb /usr/lib/ruby/1.8/readbytes.rb:23:in `readbytes': End of file reached (EOFError)         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/message.rb:32:in `read'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:30:in `initialize'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:29:in `loop'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:29:in `initialize'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:in `new'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:in `initialize'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/postgresql_adapter.rb:24:in `connect'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/postgresql_adapter.rb:24:in `postgresql_connection'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 262:in `send'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 262:in `connection_without_query_cache='         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/query_cache.rb:54:in `connection='         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 230:in `retrieve_connection'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 78:in `connection'         from activerecordtest.rb:13

Anyone have any ideas why this isn't working?

Thanks!

2

1234 is not the standard PostgreSQL port. Are you sure that's right, and that the postmaster is running, etc.?

3

Yes, 1234 is not the actual port I'm using, I've obscured all information in the establish_connection method except that it is a postgresql DB that I'm trying to use. Anyway, the actual port that I am using is correct, for I am able to use this database server through an actual Rails project, and in my yml config, the port I have specified there is the same that I tried to use in this script, which did not work. Actually, here is the output if I use the incorrect port, with the same script:

$ ruby activerecordtest.rb /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/ connection.rb:138:in `initialize': Connection refused - connect(2) (Errno::ECONNREFUSED)         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:138:in `new'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:138:in `establish_connection'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:25:in `initialize'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:in `new'         from /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:in `initialize'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/postgresql_adapter.rb:24:in `connect'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/postgresql_adapter.rb:24:in `postgresql_connection'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 262:in `send'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 262:in `connection_without_query_cache='         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/query_cache.rb:54:in `connection='         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 230:in `retrieve_connection'         from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 78:in `connection'         from activerecordtest.rb:13

So as you can see, that is not the problem.