Hey, I im using Rails 3.2.3 for my app, and everything its ok when I run rails s. But when I go to the browser i got this: ActiveRecord::ConnectionNotEstablished And this is the full trace: activerecord (3.2.3) lib/activerecord/connection_adapters/abstract/ connection_pool.rb:398:in retrieve_connection'' activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ connection_specification.rb:168:inretrieve_connection'' activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ connection_specification.rb:142:in connection'' activerecord (3.2.3) lib/active_record/query_cache.rb:67:inrescue in call'' activerecord (3.2.3) lib/active_record/query_cache.rb:61:in call'' activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ connection_pool.rb:467:incall'' actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb:28:in block in call'' activesupport (3.2.3) lib/active_support/callbacks.rb: 405:in_run4231786738375313579call1989705551904492368_callbacks'' activesupport (3.2.3) lib/active_support/callbacks.rb:405:in __run_callback'' activesupport (3.2.3) lib/active_support/callbacks.rb: 385:in_run_call_callbacks'' activesupport (3.2.3) lib/active_support/callbacks.rb:81:in run_callbacks'' actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb: 27:incall'' actionpack (3.2.3) lib/action_dispatch/middleware/reloader.rb:65:in call'' actionpack (3.2.3) lib/action_dispatch/middleware/remote_ip.rb: 31:incall'' actionpack (3.2.3) lib/action_dispatch/middleware/debug_exceptions.rb: 16:in call'' actionpack (3.2.3) lib/action_dispatch/middleware/show_exceptions.rb: 56:incall'' railties (3.2.3) lib/rails/rack/logger.rb:26:in call_app'' railties (3.2.3) lib/rails/rack/logger.rb:16:incall'' actionpack (3.2.3) lib/action_dispatch/middleware/request_id.rb:22:in call'' rack (1.4.1) lib/rack/methodoverride.rb:21:incall'' rack (1.4.1) lib/rack/runtime.rb:17:in call'' activesupport (3.2.3) lib/active_support/cache/strategy/local_cache.rb: 72:incall'' rack (1.4.1) lib/rack/lock.rb:15:in call'' actionpack (3.2.3) lib/action_dispatch/middleware/static.rb:62:incall'' railties (3.2.3) lib/rails/engine.rb:479:in call'' railties (3.2.3) lib/rails/application.rb:220:incall'' rack (1.4.1) lib/rack/content_length.rb:14:in call'' railties (3.2.3) lib/rails/rack/log_tailer.rb:14:incall'' rack (1.4.1) lib/rack/handler/webrick.rb:59:in service'' /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ httpserver.rb:111:inservice'' /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ httpserver.rb:70:in run'' /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ server.rb:183:inblock in start_thread'' And this is my database.yml # SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: mysql encoding: utf8 reconnect: false database: pool: 5 username: root password: socket: /tmp/mysql.sock # 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. development: adapter: mysql encoding: utf8 reconnect: false database: pool: 5 username: root password: socket: /tmp/mysql.sock And I really dont know what it can be :/ Thx guys -- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On 1 May 2012 15:18, viicviicviic <vih_rock-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote:> Hey, I im using Rails 3.2.3 for my app, and everything its ok when I > run rails s. > > But when I go to the browser i got this: > > ActiveRecord::ConnectionNotEstablished > > And this is the full trace: > > activerecord (3.2.3) lib/activerecord/connection_adapters/abstract/ > connection_pool.rb:398:in retrieve_connection'' > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > connection_specification.rb:168:inretrieve_connection'' > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > connection_specification.rb:142:in connection'' > activerecord (3.2.3) lib/active_record/query_cache.rb:67:inrescue in > call'' > activerecord (3.2.3) lib/active_record/query_cache.rb:61:in call'' > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > connection_pool.rb:467:incall'' > actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb:28:in > block in call'' > activesupport (3.2.3) lib/active_support/callbacks.rb: > 405:in_run4231786738375313579call1989705551904492368_callbacks'' > activesupport (3.2.3) lib/active_support/callbacks.rb:405:in > __run_callback'' > activesupport (3.2.3) lib/active_support/callbacks.rb: > 385:in_run_call_callbacks'' > activesupport (3.2.3) lib/active_support/callbacks.rb:81:in > run_callbacks'' > actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb: > 27:incall'' > actionpack (3.2.3) lib/action_dispatch/middleware/reloader.rb:65:in > call'' > actionpack (3.2.3) lib/action_dispatch/middleware/remote_ip.rb: > 31:incall'' > actionpack (3.2.3) lib/action_dispatch/middleware/debug_exceptions.rb: > 16:in call'' > actionpack (3.2.3) lib/action_dispatch/middleware/show_exceptions.rb: > 56:incall'' > railties (3.2.3) lib/rails/rack/logger.rb:26:in call_app'' > railties (3.2.3) lib/rails/rack/logger.rb:16:incall'' > actionpack (3.2.3) lib/action_dispatch/middleware/request_id.rb:22:in > call'' > rack (1.4.1) lib/rack/methodoverride.rb:21:incall'' > rack (1.4.1) lib/rack/runtime.rb:17:in call'' > activesupport (3.2.3) lib/active_support/cache/strategy/local_cache.rb: > 72:incall'' > rack (1.4.1) lib/rack/lock.rb:15:in call'' > actionpack (3.2.3) lib/action_dispatch/middleware/static.rb:62:incall'' > railties (3.2.3) lib/rails/engine.rb:479:in call'' > railties (3.2.3) lib/rails/application.rb:220:incall'' > rack (1.4.1) lib/rack/content_length.rb:14:in call'' > railties (3.2.3) lib/rails/rack/log_tailer.rb:14:incall'' > rack (1.4.1) lib/rack/handler/webrick.rb:59:in service'' > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > httpserver.rb:111:inservice'' > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > httpserver.rb:70:in run'' > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > server.rb:183:inblock in start_thread'' > > > And this is my database.yml > > # SQLite version 3.x > # gem install sqlite3-ruby (not necessary on OS X Leopard) > development: > adapter: mysql > encoding: utf8 > reconnect: false > database:It might be helpful to tell it which database to use. I don''t understand how rake db:create or db:migrate worked with this file. Colin> pool: 5 > username: root > password: > socket: /tmp/mysql.sock > > # 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. > development: > adapter: mysql > encoding: utf8 > reconnect: false > database: > pool: 5 > username: root > password: > socket: /tmp/mysql.sock > > And I really dont know what it can be :/ > Thx guys > > -- > 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >-- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Use mysql2 gem for 3x version of rails instead of mysql -- Best Regards, Ryan Cheung On Wed, May 2, 2012 at 3:34 PM, Colin Law <clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:> On 1 May 2012 15:18, viicviicviic <vih_rock-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote: > > Hey, I im using Rails 3.2.3 for my app, and everything its ok when I > > run rails s. > > > > But when I go to the browser i got this: > > > > ActiveRecord::ConnectionNotEstablished > > > > And this is the full trace: > > > > activerecord (3.2.3) lib/activerecord/connection_adapters/abstract/ > > connection_pool.rb:398:in retrieve_connection'' > > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > > connection_specification.rb:168:inretrieve_connection'' > > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > > connection_specification.rb:142:in connection'' > > activerecord (3.2.3) lib/active_record/query_cache.rb:67:inrescue in > > call'' > > activerecord (3.2.3) lib/active_record/query_cache.rb:61:in call'' > > activerecord (3.2.3) lib/active_record/connection_adapters/abstract/ > > connection_pool.rb:467:incall'' > > actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb:28:in > > block in call'' > > activesupport (3.2.3) lib/active_support/callbacks.rb: > > 405:in_run4231786738375313579call1989705551904492368_callbacks'' > > activesupport (3.2.3) lib/active_support/callbacks.rb:405:in > > __run_callback'' > > activesupport (3.2.3) lib/active_support/callbacks.rb: > > 385:in_run_call_callbacks'' > > activesupport (3.2.3) lib/active_support/callbacks.rb:81:in > > run_callbacks'' > > actionpack (3.2.3) lib/action_dispatch/middleware/callbacks.rb: > > 27:incall'' > > actionpack (3.2.3) lib/action_dispatch/middleware/reloader.rb:65:in > > call'' > > actionpack (3.2.3) lib/action_dispatch/middleware/remote_ip.rb: > > 31:incall'' > > actionpack (3.2.3) lib/action_dispatch/middleware/debug_exceptions.rb: > > 16:in call'' > > actionpack (3.2.3) lib/action_dispatch/middleware/show_exceptions.rb: > > 56:incall'' > > railties (3.2.3) lib/rails/rack/logger.rb:26:in call_app'' > > railties (3.2.3) lib/rails/rack/logger.rb:16:incall'' > > actionpack (3.2.3) lib/action_dispatch/middleware/request_id.rb:22:in > > call'' > > rack (1.4.1) lib/rack/methodoverride.rb:21:incall'' > > rack (1.4.1) lib/rack/runtime.rb:17:in call'' > > activesupport (3.2.3) lib/active_support/cache/strategy/local_cache.rb: > > 72:incall'' > > rack (1.4.1) lib/rack/lock.rb:15:in call'' > > actionpack (3.2.3) lib/action_dispatch/middleware/static.rb:62:incall'' > > railties (3.2.3) lib/rails/engine.rb:479:in call'' > > railties (3.2.3) lib/rails/application.rb:220:incall'' > > rack (1.4.1) lib/rack/content_length.rb:14:in call'' > > railties (3.2.3) lib/rails/rack/log_tailer.rb:14:incall'' > > rack (1.4.1) lib/rack/handler/webrick.rb:59:in service'' > > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > > httpserver.rb:111:inservice'' > > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > > httpserver.rb:70:in run'' > > /Users/VictorHugo/.rvm/rubies/ruby-1.9.2-p318/lib/ruby/1.9.1/webrick/ > > server.rb:183:inblock in start_thread'' > > > > > > And this is my database.yml > > > > # SQLite version 3.x > > # gem install sqlite3-ruby (not necessary on OS X Leopard) > > development: > > adapter: mysql > > encoding: utf8 > > reconnect: false > > database: > > It might be helpful to tell it which database to use. > I don''t understand how rake db:create or db:migrate worked with this file. > > Colin > > > pool: 5 > > username: root > > password: > > socket: /tmp/mysql.sock > > > > # 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. > > development: > > adapter: mysql > > encoding: utf8 > > reconnect: false > > database: > > pool: 5 > > username: root > > password: > > socket: /tmp/mysql.sock > > > > And I really dont know what it can be :/ > > Thx guys > > > > -- > > 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > > > -- > 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Were you able to solve the issue? I am getting the exact same error and I using the mysql2 gem. I also have the database name in database.yml. -- Posted via http://www.ruby-forum.com/. -- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On 4 May 2012 12:39, Fernando Cano <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Were you able to solve the issue? I am getting the exact same error and > I using the mysql2 gem. I also have the database name in database.yml.It seems likely the OP realised he was doing something silly and was too embarrassed to post back here. Are you able to access the database using mysql command line or similar tool? Are you able to create the db ok using rake db:create If not copy and paste the result here. Colin -- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Thanks Colin. Your response actually helped solved the problem. I started having the issue after I upgraded to Rails 3.2.3. I tried to create a new database using rake db:create (as you suggested) and it showed me that the problem was a version difference between MySQL and the client used by rails. The following article helped me solve the problem: http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick Thanks again, Fernando. -- Posted via http://www.ruby-forum.com/. -- 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-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.