similar to: postgres connection problems

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

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

This might be obvious to everyone but it is something that i haven''t been able to find an answer to. Do I need to have either scgi/fastcgi/cgi running on either lighttpd/apache for ruby scripts to work? If yes, why? I have installed the scgi server and i can get the service to run, i have also installed the following mod_fastcgi/2.4.2 mod_ruby/1.2.4 Ruby/1.8.2(2004-12-25) mod_scgi,

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anyone know what''s going on with ActiveRecord Edge and 1.2RC1 unit tests. I get 13 failures from the "async_exec" method call. ie: test_callback_rollback_in_save(ConcurrentTransactionTest): ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_exec'' for #<PGconn:0xb75a8754>: SET

Hi, I am having Mysql connection problem for my first AddressBook application (which I took it from http://www-128.ibm.com/developerworks/linux/library/l-rubyrails/) I have gem installed the latest ruby, rails, lighttpd, fastcgi, mysql-4.1.14 on linux. Everything looks good. When I do: mysql -h localhost -u test -ptest -D AddressBook mysql> SELECT COUNT(*) FROM contacts; +----------+ |

My app runs fine on webrick, but I get a ActiveRecord::ConnectionNotEstablished when I try to run it on lighttpd. Here''s the app''s lighttpd config: $HTTP["host"] =~ "(www\.)?mysite\.com" { server.document-root = "/home/pergesuteore/public/" server.error-handler-404 = "/dispatch.fcgi" fastcgi.server = ( ".fcgi" => (

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

I just deployed my rails app to my production server. It''s all working locally, but when I switched it over to the production server (at dreamhost) I get this error: # Logfile created on Sun Aug 19 15:22:48 -0700 2007 by logger.rb/ 1.5.2.9 [19/Aug/2007:15:22:48 :: 1841] starting [19/Aug/2007:15:22:48 :: 1841] Dispatcher failed to catch: You have a nil object when you didn''t

Hi everybody, I''m experiencing trouble when trying to use ruby-postgres with a legacy database I need access to. To me it seems the problem is the VARCHAR columns used there as primary keys. On a simple me = User.find(''PS12345'') I get a type error exception with the message ''can''t convert String into Integer''. The trace is:

Hello All, If I run my unit tests individually using Ruby, they all work correctly. However, if I try to run them using "rake test_units", I get a bunch of error messages. The error messages appear to be caused by rake not loading any of the fixtures into the test database. I am using PostgreSQL on Windows. Does anyone have any suggestions? Many thanks, Bruce. -- Posted via

All of a sudden, I''m getting this error: 1) Error: test_index(AccountControllerTest): RuntimeError: The number of parameters does not match the number of substitutions. /home/joe/projects/tanga/trunk/config/../vendor/rails/actionpack/lib/action_controller/assertions.rb:92:in `assert_redirected_to''

Hi, I''m new to Ruby on Rails and am having a little difficulty working through the ''Rolling with Ruby on Rails'' tutorial. Can anyone help? I''m trying to get the cookbook application to work via a Postgresql db. But get the following error when trying to access http://127.0.0.1:3000/recipe/new Errno::EINVAL in RecipeController#new Invalid argument

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

Dear all, Please help me in this regards, I am using models to access LegacySchemas using set_table_name and set_primary_key... [code for model] class CdDetails < ActiveRecord::Base def self.find_data set_table_name ''cd_details'' set_primary_key ''cd_label'' find (:first, :select => "cd_label") end

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

To all fellow Dreamhosters out there... Sometimes my app mysteriously loses its connection to the database, resulting in a big ugly "Application Error (Rails)" page. Usually refreshing the page makes it go away, but not today. :-( In production.log I see this: MysqlError (Lost connection to MySQL server during query): Any idea why this happens? It''s rather intermittent

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

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