Hello -- Please pardon my newness -- I'm just getting started with rails, and I'm having some difficulty getting it set up with MySQL.
I am able to get the basic ruby server running (script\server). When I created a new page (using script/generate controller about index), I am not able to navigate to the new page, and Ruby either crashes or gives me an error: /!\ FAILSAFE /!\ Tue Jun 15 13:53:08 -0700 2010 Status: 500 Internal Server Error Access denied for user 'root'@'localhost' (using password: NO) I have modified the database.yml file (full text of file pasted below). I know the password is correct, as it is what I use to launch mysql. When I enter 'show databases' into MySQL monitor, I see the two databases I specified (emporium_development and emporium_test). The MySQL service is running (I'm on Win7). I have tried both restarting the MySQL service and restarting the ruby server. I created the project with the command: 'rails emporium -d mysql' and prior to that, I installed the mysql driver for rails using the command 'gem install mysql'. I installed the 105.4 MB mysql from here: http://dev.mysql.com/downloads/mysql/5.1.html#downloads, but I have not installed anything else (outside of rails). Thank you for any help you can offer!! Sarah database.yml: # MySQL. Versions 4.1 and 5.0 are recommended. # # Install the MySQL driver: # gem install mysql # On Mac OS X: # sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql # On Mac OS X Leopard: # sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql- config=/usr/local/mysql/bin/mysql_config # This sets the ARCHFLAGS environment variable to your native architecture # On Windows: # gem install mysql # Choose the win32 build. # Install MySQL and put its /bin directory on your path. # # And be sure to use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html development: adapter: mysql encoding: utf8 reconnect: false database: emporium_development pool: 5 username: root password: hacked host: localhost # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test: adapter: mysql encoding: utf8 reconnect: false database: emporium_test pool: 5 username: root password: hacked host: localhost Full Error Text: C:\webapp\emporium>ruby script\server => Booting WEBrick => Rails 2.3.8 application starting on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server [2010-06-15 13:52:56] INFO WEBrick 1.3.1 [2010-06-15 13:52:56] INFO ruby 1.8.6 (2010-02-04) [i386-mingw32] [2010-06-15 13:52:56] INFO WEBrick::HTTPServer#start: pid=3664 port=3000 /!\ FAILSAFE /!\ Tue Jun 15 13:53:04 -0700 2010 Status: 500 Internal Server Error Access denied for user 'root'@'localhost' (using password: NO) C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `real_connect' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `connect' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:203:in `initialize' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:75:in `new' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:75:in `mysql_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:223:in `send' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:223:in `new_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:188:in `checkout' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:184:in `loop' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:184:in `checkout' C:/Ruby186/lib/ruby/1.8/monitor.rb:242:in `synchronize' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:183:in `checkout' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:98:in `connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:326:in `retrieve_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_specification.rb:123:in `retrieve_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_specification.rb:115:in `connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/query _cache.rb:9:in `cache' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/query _cache.rb:28:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:361:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/str ing_coercion.rb:25:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/head.rb:9:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/ methodoverride.rb:24:i n `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/par ams_parser.rb:15:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/ses sion/cookie_store.rb:99:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/fai lsafe.rb:26:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `synchro nize' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/dis patcher.rb:114:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/rel oader.rb:34:in `run' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/dis patcher.rb:108:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/rails/rack/ static.rb:31:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 47:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 41:in `each' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 41:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/rails/rack/ log_tailer.rb:1 7:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/ content_length.rb:13:i n `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/ webrick.rb:48: in `service' C:/Ruby186/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' C:/Ruby186/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:162:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:95:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:92:in `each' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:92:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:23:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:82:in `start' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/ webrick.rb:14: in `run' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/commands/ server.rb:111 C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_orig inal_require' C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' script/server:3 /!\ FAILSAFE /!\ Tue Jun 15 13:53:08 -0700 2010 Status: 500 Internal Server Error Access denied for user 'root'@'localhost' (using password: NO) C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `real_connect' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:619:in `connect' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:203:in `initialize' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:75:in `new' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/mysql_adapter.rb:75:in `mysql_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:223:in `send' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:223:in `new_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:188:in `checkout' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:184:in `loop' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:184:in `checkout' C:/Ruby186/lib/ruby/1.8/monitor.rb:242:in `synchronize' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:183:in `checkout' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:98:in `connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:326:in `retrieve_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_specification.rb:123:in `retrieve_connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_specification.rb:115:in `connection' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/query _cache.rb:9:in `cache' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/query _cache.rb:28:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/ active_record/conne ction_adapters/abstract/connection_pool.rb:361:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/str ing_coercion.rb:25:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/head.rb:9:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/ methodoverride.rb:24:i n `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/par ams_parser.rb:15:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/ses sion/cookie_store.rb:99:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/fai lsafe.rb:26:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `synchro nize' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/lock.rb: 11:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/dis patcher.rb:114:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/rel oader.rb:34:in `run' C:/Ruby186/lib/ruby/gems/1.8/gems/actionpack-2.3.8/lib/ action_controller/dis patcher.rb:108:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/rails/rack/ static.rb:31:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 47:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 41:in `each' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/urlmap.rb: 41:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/rails/rack/ log_tailer.rb:1 7:in `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/ content_length.rb:13:i n `call' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/ webrick.rb:48: in `service' C:/Ruby186/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' C:/Ruby186/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:162:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:95:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:92:in `each' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:92:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:23:in `start' C:/Ruby186/lib/ruby/1.8/webrick/server.rb:82:in `start' C:/Ruby186/lib/ruby/gems/1.8/gems/rack-1.1.0/lib/rack/handler/ webrick.rb:14: in `run' C:/Ruby186/lib/ruby/gems/1.8/gems/rails-2.3.8/lib/commands/ server.rb:111 C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_orig inal_require' C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' script/server:3 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
