elgocho
05-12-2006, 22:59:31
Hola a todos, tengo un problema que me esta dando dolores de cabeza, pues estoy haciendo un proyecto en Ruby on Rails y necesito conectarme con una Base de Datos en Postgres la verdad no creía que fuera tan difícil pero ya no se que mas hacer para conectarme con la BD pues con Mysql no se me presentaron tantos problemas, estas son las cosas que tengo instalada en mi maquina:
1. Debian GNU/Linux, kernel 2.4.27-2-686.
2. Ruby 1.8.2
3. Postgresql 7.4.7-6 sarge1
4. 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
5. ruby-postgres-0.7.1.tar.tar
El error que se me está presentando es el siguiente: luego de haber instalado todas las cosas que creo que son necesarias no puedo conectarme a la BD, en la carpeta /app/models de mi proyecto hice un archivo con el mismo nombre de mi tabla la cual se llama usuario, recordando que originalmente tiene nombre en plural, la conexión que hice es la siguiente:
ActiveRecord::Base.establish_connection(
:adapter => "postgresql",
:host => "localhost",
:port => "5432",
:database => "mundo",
:username => "usuario",
:password => "123456"
)
class Usuario < ActiveRecord::Base
end
El error cuando trato de conectarme para guardar algo es el siguiente:
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:in `connect'
/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:in `send'
/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:in `connection='
/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'
-e:4
/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"}
Por favor si alguien sabe como solucionar este problema se lo agradezco.
Gracias de antemano.
El gocho. Venezuela.
1. Debian GNU/Linux, kernel 2.4.27-2-686.
2. Ruby 1.8.2
3. Postgresql 7.4.7-6 sarge1
4. 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
5. ruby-postgres-0.7.1.tar.tar
El error que se me está presentando es el siguiente: luego de haber instalado todas las cosas que creo que son necesarias no puedo conectarme a la BD, en la carpeta /app/models de mi proyecto hice un archivo con el mismo nombre de mi tabla la cual se llama usuario, recordando que originalmente tiene nombre en plural, la conexión que hice es la siguiente:
ActiveRecord::Base.establish_connection(
:adapter => "postgresql",
:host => "localhost",
:port => "5432",
:database => "mundo",
:username => "usuario",
:password => "123456"
)
class Usuario < ActiveRecord::Base
end
El error cuando trato de conectarme para guardar algo es el siguiente:
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:in `connect'
/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:in `send'
/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:in `connection='
/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'
-e:4
/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"}
Por favor si alguien sabe como solucionar este problema se lo agradezco.
Gracias de antemano.
El gocho. Venezuela.