Help to connect Postgres and Ruby on Rails

El_gocho · December 5, 2006, 2:11am

Hello to everyone, I have a problem that is giving me a headache, and
trying to do a project in Ruby on Rails and I need to connect with a
Data Base that is en Postgres, the truth is that I didn’t think that
it was so hard to connect a DB with postgres because I was working with
Msyql and everything was easy. This are the thinks that I have install
in my computer.

Debian GNU/Linux, kernel 2.4.27-2-686.
Ruby 1.8.2
Postgresql 7.4.7-6 sarge1
Gems: actionmailer-1.2.5, actionpack-1.12.5, actionwebservice-1.1.6,
activerecord-1.14.4, activesupport-1.3.1, postgres-pr-0.2.1,
rails-1.1.6, rake-0.7.1
ruby-postgres-0.7.1.tar.tar

The error is that after I install everything that I need, I can’t
connect with my DB, in my project in the folder /app/models I made a
archive with the same name off my table, remembering that my real table
the name is in plural bout in my project in singular, the thinks that I
wrote look something like this

ActiveRecord::Base.establish_connection(
:adapter => “postgresql”,
:host => “localhost”,
:port => “5432”,
:database => “mundo”,
:username => “usuario”,
:password => “123456”

)

class Usuario < ActiveRecord::Base

end

When I try to save something in my DB the error that appears is like
this

TypeError in PruebaController#guardar
can’t convert String into Integer

RAILS_ROOT: script/…/config/…
Application Trace | Framework Trace | Full Trace

/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:24:in
initialize' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:24:inconnect’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/postgresql_adapter.rb:24:in
postgresql_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:insend’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
connection_without_query_cache=' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:inconnection=’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:inconnection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in
columns' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1969:inattributes_from_column_definition’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1351:in
initialize_without_callbacks' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/callbacks.rb:236:ininitialize’
app/controllers/prueba_controller.rb:9:in new' app/controllers/prueba_controller.rb:9:inguardar’
-e:4:in load' -e:4 /usr/lib/ruby/1.8/webrick/httpserver.rb:104:inservice’
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run' /usr/lib/ruby/1.8/webrick/server.rb:172:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:161:in start' /usr/lib/ruby/1.8/webrick/server.rb:161:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start’

Request
Parameters: {“commit”=>“Guardar”, “usuario”=>{“apellido”=>“GGGGGG”,
“cedula”=>“888888”, “nombre”=>“MMMMM”, “telefono”=>“5555555”}}
Show session dump
flash: !ruby/hash:ActionController::Flash::FlashHash {}

Response
Headers: {“cookie”=>[], “Cache-Control”=>“no-cache”}

Pleas if someone know how to help me I’ll be grateful.

From Venezuela. El_gocho says thank you.
P.S: sorry if I wrote something wrong, my English writhing is not so
good.

El_gocho · December 5, 2006, 4:31am

El_gocho wrote:

ActiveRecord::Base.establish_connection(
:adapter => “postgresql”,
:host => “localhost”,
:port => “5432”,
:database => “mundo”,
:username => “usuario”,
:password => “123456”

)

TypeError in PruebaController#guardar
can’t convert String into Integer

The problem is the line specifiying your port. it should be

:port => 5432

El_gocho · December 5, 2006, 9:00pm

On Dec 4, 11:31 pm, Michael G. [email protected]
wrote:

)

TypeError in PruebaController#guardar
can’t convert String into IntegerThe problem is the line specifiying your port. it should be
:port => 5432

Hello my friend, well I try to do what you wrote me bout I still have a
problem, I changed my
ActiveRecord::Base.establish_connection(
:adapter => “postgresql”,
:host => “localhost”,
:port => “5432”,
:database => “mundo”,
:username => “usuario”,
:password => “123456”

)

class Usuario < ActiveRecord::Base

end

for something like this

ActiveRecord::Base.establish_connection(
:adapter => “postgresql”,
:host => “localhost”,
:port => 5432,
:database => “mundo”,
:username => “usuario”,
:password => “123456”

)

class Usuario < ActiveRecord::Base

end

and now I have this problem, when I try to save some data I received a
javascript error that says "The connection was refused when
attempting to contact localhost:3000 ", there where a friend that
wrote me that the :host and :por are no necessary, I try the too bout I
gat the same javascript error.

Please if you can help I’ll be grateful.
Thank you. El gocho - From Venezuela

El_gocho · December 6, 2006, 12:45am

On Dec 6, 2006, at 4:58 , El_gocho wrote:

and now I have this problem, when I try to save some data I received a
javascript error that says "The connection was refused when
attempting to contact localhost:3000 ", there where a friend that
wrote me that the :host and :por are no necessary, I try the too
bout I
gat the same javascript error.

That’s most likely a web server error, not a database error. Do you
have your web server running on port 3000? It looks like it’s not.
Make sure your web server is running (e.g., script/server )

Michael G.
grzm seespotcode net

El_gocho · December 5, 2006, 10:28pm

El_gocho wrote:

Hello to everyone, I have a problem that is giving me a headache, and
trying to do a project in Ruby on Rails and I need to connect with a
Data Base that is en Postgres, the truth is that I didn’t think that
it was so hard to connect a DB with postgres because I was working with
Msyql and everything was easy. This are the thinks that I have install
in my computer.

This was answered in your previous post.

ilan

El_gocho · December 9, 2006, 4:01pm

On 5 dic, 19:42, Michael G. [email protected] wrote:

Michael G.
grzm seespotcode net

Hello my friends, well I try all the you gays wrote me bout I don’t
know
why I still have the problem, I just want to connect a DB that is in
Postgres with my project Ruby on Rails, bout nothing seems to work,
well
all that thinks that I had made are:

install all these:
o Debian GNU/Linux, kernel 2.4.27-2-686.
o Ruby 1.8.2
o Postgresql 7.4.7-6 sarge1
o Gems: actionmailer-1.2.5, actionpack-1.12.5, actionwebservice-1.1.6,

activerecord-1.14.4, activesupport-1.3.1, postgres-pr-0.2.1,
rails-1.1.6, rake-0.7.1
o ruby-postgres-0.7.1.tar.tar

in my project in the folder /app/models I made a archive with the
same name off my table, remembering that my real table the name is in
plural bout in my project in singular, the thinks that I wrote look
something like this

       ActiveRecord::Base.establish_connection(
       :adapter  => "postgresql",
       :host     => "localhost",
       :port     => "5432",
       :database => "mundo",
        :username => "usuario",
        :password => "123456"
 )

class Usuario < ActiveRecord::Base

end

Ok, the first error that I had was these:

TypeError in PruebaController#guardar
can’t convert String into Integer

RAILS_ROOT: script/…/config/…
Application Trace | Framework Trace | Full Trace

/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in

`retrieve_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in

`connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in

`columns’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1969:in

`attributes_from_column_definition’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1351:in

`initialize_without_callbacks’
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/callbacks.rb:236:in

initialize' app/controllers/prueba_controller.rb:9:in new’
app/controllers/prueba_controller.rb:9:in guardar' -e:4:in load’
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run’
/usr/lib/ruby/1.8/webrick/server.rb:172:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:161:in start’
/usr/lib/ruby/1.8/webrick/server.rb:161:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in start’

Request
Parameters: {“commit”=>“Guardar”, “usuario”=>{“apellido”=>“GGGGGG”,
“cedula”=>“888888”, “nombre”=>“MMMMM”, “telefono”=>“5555555”}}
Show session dump
flash: !ruby/hash:ActionController::Flash::FlashHash {}

Response
Headers: {“cookie”=>[], “Cache-Control”=>“no-cache”}

Well a friend wrote me that the host and port aren’t necessary if my
data was local and it is, so I changed my connection for something
like
these

ActiveRecord::Base.establish_connection(
:adapter => “postgresql”,
:database => “mundo”,
:username => “usuario”,
:password => “123456”
)

class Usuario < ActiveRecord::Base

end

So after that, I have a different error is a javascript error that says

"The connection was refused when attempting to contact localhost:3000
",
and the error happens when a try to save something in my DB, my host is

running because I can see all my web pages bout if I what to save
something and I click the save button the javascript error appear.

I don’t know if someone in this community can help me, with a
tutorial
or a example the connect Postgres and Ruby on Rails, or maybe tell me
what thinks do I have to install in what order. Please someone help me
I
don’t want to give-up with these error.

From Venezuela. El_gocho says thank you.
P.S: sorry if I wrote something wrong, my English writhing is not so
good

El_gocho · December 9, 2006, 4:03pm

On 5 dic, 17:28, Ilan B. [email protected] wrote:

–
Posted viahttp://www.ruby-forum.com/.

Hello my friends, well I try all the you gays wrote me bout I don’t
know
why I still have the problem, I just want to connect a DB that is in
Postgres with my project Ruby on Rails, bout nothing seems to work,
well
all that thinks that I had made are:

install all these:
o Debian GNU/Linux, kernel 2.4.27-2-686.
o Ruby 1.8.2
o Postgresql 7.4.7-6 sarge1
o Gems: actionmailer-1.2.5, actionpack-1.12.5, actionwebservice-1.1.6,

activerecord-1.14.4, activesupport-1.3.1, postgres-pr-0.2.1,
rails-1.1.6, rake-0.7.1
o ruby-postgres-0.7.1.tar.tar

in my project in the folder /app/models I made a archive with the
same name off my table, remembering that my real table the name is in
plural bout in my project in singular, the thinks that I wrote look
something like this

       ActiveRecord::Base.establish_connection(
       :adapter  => "postgresql",
       :host     => "localhost",
       :port     => "5432",
       :database => "mundo",
        :username => "usuario",
        :password => "123456"
 )