similar to: ruby-postgres: can''t convert string to integer

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"

Hi, I followed the instructions I founded here : http://developer.apple.com/tools/rubyonrails.html I can run a small RoR application with webrick, everything is fine in this case. But when I try to use lighttpd i can access http://localhost:3000/images/rails.png for example but not a dynamic page. In the latter case I dont get any page, the browser is just waiting infinitely. If I force

My databases.yml makes no mention of root and in my dev environment everything works fine, however following a deployment with Capistrano about an hour ago, I get the following error: PGError in HomeController#index FATAL: role "root" does not exist /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:713:in `connect''

My Application runs fine when run on webrick, but throws up database error when run from apache. this is the copy of the FULL TRACE i get /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `create'' /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:131:in `initialize'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb:515:in

Hi all, my computer decide to take a dirt nap today so I am trying to relaod rails on another machine and I am getting this error message which I can''t make heads or tails about: no such file to load -- postgres RAILS_ROOT: ./script/../config/.. c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require''

hi. i''ve an application which is using a local mysql server (on localhost). i then moved the mysql server to another machine (remote host) and changed accordingly the "database.yml" file. when i launch webrick from the "localhost", it can connect to the database but as soon as i call a controller of the application (for example

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

Hello, I successfully dumped the database in postgresql. Now I want to connect my rails application to the postgresql database, able to start the server, but I am getting this error when I browse the application from the browser. script/server => Booting WEBrick => Rails 2.3.5 application starting on http://0.0.0.0:3000 Sphinx cannot be found on your system. You may need to configure the

Hello, Thank you for the fast responses, I really appreciate. I really enjoy being a part of such a great community. I still could not solve my problem. To make sure that I can not connect beacuse of access rights, I have started mysql server --skip-grant-tables option. (I have read the part of the manual about access rights, which I was to read in this list, but 4 AM in the morning, I had hard

Hi, I''m totally new to Ruby and Rails and I''m trying to set up a prototype web site. Unfortunately, I''m having problems with ActiveRecord using multiple threads. What I want to do is fairly simple. I have a Controller that receives and saves data from the web in the DB, but once that''s done I want to process this data in another thread and then save the

Hi, for some reason, all timestamp fields with or without time zone in my Postgres tables seem to be casted to nil. From console: >> me = User.find(''PS12345'') => #<User:0x2379788 @attributes={"mtime"=>"01.03.2006 13:26:32.737166", "valid"=>"8", "valid_from"=>"01.03.1999 14:09:21 CET",

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. 1. Debian GNU/Linux, kernel

Hello everyone, I''m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking

I would appreciate any tips/clues/advice very much. I have started using ruby on rails and when the MS SQL Server database is on a different box than my dev box (where the RoR app is located) I can connect fine. However when I try to connect to a MS SQL Server database on the same box as my RoR app I get an error. I have tried to use the IP address of the dev box as the value of

OK, I''m diving into new things - a .net programmer and windows user trying to develop in Rails on my Mac. Initial setup was easy, and I had things working and was thrilled with myself. Then I shut down. Next time I booted up, mysql was acting all kinds of funny. I finally got that working again (I *think* it mostly had to do with me not having the right path, I unfortunately

Hi everybody, I''ve been reading lot of material about Ruby on Rails, and it looks like really rocks. I''ve downloaded the one-click version for Windows and started to build the example cookbook app, found in: http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html?page=1 Everything looks good, but when I''m trying to create a new Recipe

Trying to get Rails and mysql running on OS X, and I''m a Nuby. Everything ran smoothly when I first installed, but after rebooting things were out of whack. I finally got back into mysql after re-installing, and at first when I tried to connect with Rails/Ruby I got a message that my client was not up to date. So after reading some info online, I set my mysql passwords with

I just ported my Rails app from OSX/Linux to Windows XP for the first time. I am running PostgreSQL 8.0 and the postgres-pr 4.0 adapter. Some of the queries in my Rails app work, but for others I get a weird error: ArgumentError: Invalid Ruby/cstring: select sa.name as activity_name, max(sah.created_at) as created_at from site_activity_histories sah, site_activities sa where

Hi all, Please help me.In my first attempt to creat a simple controller and working with hello world program.I got some error though I have my action and view correctly....... In general..When I type http://localhost:3000/ I can get the welcome page.But when I see the "About your application Envinorment"..I get some error as following.. MissingSourceFile in

I am reading the agile web development with rails book, and starting to create the depot. I am getting the below error after setting up the "ruby script/generate scaffold Product Admin" does anyone know what the problem is? NameError in AdminController#index uninitialized constant Mysql RAILS_ROOT: ./script/../config/../ Application Trace | Framework Trace | Full Trace