Madhusudhan H R
2012-Jan-03 12:30 UTC
Access denied for user ''root''@''localhost'' (using password: YES) even though i have added in mysql
Hi, I am getting the error "Access denied for user ''root''@''localhost'' (using password: YES)" in my application. I have granted full permissions for the device in mysql. My applications runs perfectly fine. But if i keep the browser idle for some time and then try to load the page I get the above error. When I do ctrl + F5 few times the app is up and running. Why am I getting such an error? The same code with the same DB is running fine in another system. Any help is appreciated. Regards, Madhu. -- 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.
Peter Vandenabeele
2012-Jan-03 12:47 UTC
Re: Access denied for user ''root''@''localhost'' (using password: YES) even though i have added in mysql
On Tue, Jan 3, 2012 at 1:30 PM, Madhusudhan H R <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote:> Hi, > > I am getting the error "Access denied for user ''root''@''localhost'' (using > password: YES)" in my application. I have granted full permissions for > the device in mysql. > > My applications runs perfectly fine. But if i keep the browser idle for > some time and then try to load the page I get the above error. When I do > ctrl + F5 few times the app is up and running. > > Why am I getting such an error? The same code with the same DB is > running fine in another system. > > Any help is appreciated. >Could you show: Operating system on which the server is running? Which Rails version? Is that database on the same server, same user, different server? (I presume you are going over TCP/IP ?) Content of config/database.yml (hide the password !). Do you see an error trace in your log file (grep for FATAL or ''500'') Thanks, Peter -- Peter Vandenabeele http://twitter.com/peter_v http://rails.vandenabeele.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.
Madhusudhan H R
2012-Jan-03 12:59 UTC
Re: Access denied for user ''root''@''localhost'' (using password: YES) even though i have added in mysq
I am running it on windows 2003 VM. Rails versions in 2.3.5. Database is in another server not the same server. Here is the database.yml conf development: adapter: mysql encoding: utf8 database: db username: root password: *** host: 172.16.1.50 port: 3306 Yes the request is through TCP/IP. Below is the error trace: /!\ FAILSAFE /!\ Tue Jan 03 18:38:51 +0530 2012 Status: 500 Internal Server Error Lost connection to MySQL server during query c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/mysql_adapter.rb:597:in `real_connect'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/mysql_adapter.rb:597:in `connect'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/mysql_adapter.rb:203:in `initialize'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/mysql_adapter.rb:75:in `new'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/mysql_adapter.rb:75:in `mysql_connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:223:in `send'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:223:in `new_connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:245:in `checkout_new_connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:188:in `checkout'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:184:in `loop'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:184:in `checkout'' c:/Ruby187/lib/ruby/1.8/monitor.rb:242:in `synchronize'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:183:in `checkout'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:98:in `connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:326:in `retrieve_connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_specification.rb:123:in `retrieve_connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_specification.rb:115:in `connection'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:9: in `cache'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:28 :in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapte rs/abstract/connection_pool.rb:361:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/string_coercion .rb:25:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/params_parser.r b:15:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/session/cookie_ store.rb:93:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/failsafe.rb:26: in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `synchronize'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:1 14:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/reloader.rb:34: in `run'' c:/Ruby187/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:1 08:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/static.rb:31:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `each'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/log_tailer.rb:17:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/content_length.rb:13:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/chunked.rb:15:in `call'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/mongrel.rb:64:in `process'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:159:in `proce ss_client'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `each'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:158:in `proce ss_client'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `initi alize'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `new'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:285:in `run'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `initi alize'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `new'' c:/Ruby187/lib/ruby/gems/1.8/gems/mongrel-1.1.5-x86-mingw32/lib/mongrel.rb:268:in `run'' c:/Ruby187/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/mongrel.rb:34:in `run'' c:/Ruby187/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/commands/server.rb:111 c:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require '' c:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'' script/server:3 -- 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.
Peter Vandenabeele
2012-Jan-03 14:15 UTC
Re: Re: Access denied for user ''root''@''localhost'' (using password: YES) even though i have added in mysq
On Tue, Jan 3, 2012 at 1:59 PM, Madhusudhan H R <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote:> I am running it on windows 2003 VM. > Rails versions in 2.3.5. Database is in another server not the same > server. >... Thank you :-) Sorry, I have little experience with this combination. I hope others can help here. Peter -- Peter Vandenabeele http://twitter.com/peter_v http://rails.vandenabeele.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.
Alex Mercer
2012-Jan-03 14:55 UTC
Re: Access denied for user ''root''@''localhost'' (using password: YES) even though i have added in mysq
hmm.. try to add in config/database.yml below `password` this line: ` reconnect: true` On Jan 3, 4:15 pm, Peter Vandenabeele <pe...-jNuWw7i2w7syMbTcgqFhxg@public.gmane.org> wrote:> On Tue, Jan 3, 2012 at 1:59 PM, Madhusudhan H R <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote: > > > I am running it on windows 2003 VM. > > Rails versions in 2.3.5. Database is in another server not the same > > server. > > ... > > Thank you :-) > > Sorry, I have little experience with this combination. I hope others > can help here. > > Peter > > -- > Peter Vandenabeelehttp://twitter.com/peter_vhttp://rails.vandenabeele.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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.