I just upgraded to RC 5 using gem. Now my 2 apps both fail with mysql saying "Access denied for user: ''@servername_removed (Using password: NO)" I have changed nothing in any of the files. It is a result of the upgrade. Any ideas? _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
I noticed the same problem - although I haven''t had time to resolve it. My database connection parameters I''m certain are correct. -k Quoting "Gray, Jeffrey" <jeff.gray-nsCYeiwbiy9BDgjK7y7TUQ@public.gmane.org>:> I just upgraded to RC 5 using gem. > > Now my 2 apps both fail with mysql saying > > "Access denied for user: ''@servername_removed (Using password: NO)" > > I have changed nothing in any of the files. It is a result of the > upgrade. > > Any ideas? > >Kevin Bedell http://www.kbedell.com "Imagination is more important than knowledge." - Albert Einstein
I''m not sure, but I think this may indicate that you are running on MySQL < 4.1. I had similar problems a while ago because of this. It usually means that your using the wrong style authentication method (it changed between versions). But I don''t understand what changed in RC5 cause this. Try ''mysql -V'' and see what version your running on. Cheers, Brett On Dec 9, 2005, at 11:57 AM, Christophe Vigny wrote:> Hi I have encounter the same probleme !! > it happen using the rails pure ruby driver ! > > “Access denied for user: ''@myserver.com (Using password: NO)” > have u report the bug ? > > > > Gray, Jeffrey wrote: >> I just upgraded to RC 5 using gem. >> >> Now my 2 apps both fail with mysql saying >> >> “Access denied for user: ''@servername_removed (Using password: NO)” >> >> I have changed nothing in any of the files. It is a result of the >> upgrade. >> >> Any ideas? >> >> _______________________________________________ >> Rails mailing list >> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> > > > "Ce message et toutes les pièces jointes sont des informations > strictement confidentielles et réservées au(x) destinataire(s). Ce > courriel n''a pas de valeur contractuelle et son contenu ne > constitue ni une acceptation, ni un engagement de la part de > l''auteur et des sociétés du groupe Serveur et Artprice, sauf dans > le cas où cela aurait été prévu avec le destinataire par un accord > écrit. Le contenu de ce message et les pièces jointes ne peuvent > constituer une preuve au sens de l''article 1316-1 du Code Civil. > L.auteur et les sociétés du groupe Serveur et Artprice déclinent > toute responsabilité au titre de ce courriel s''il a été altéré, > déformé, falsifié ou indûment utilisé par des tiers ou encore s''il > a causé tout dommage ou perte de toute nature. Si vous n''êtes pas > le bon destinataire, merci de nous contacter et de ne pas le > divulguer." > > "This message including any attachments are confidential and > privileged material intended solely for the addressees. Its > contents do not constitute a commitment by groupe Serveur sas and > Artprice SA, except when provided for in a written agreement with > the addressees. The contents of this message cannot constitute > neither the proof nor the acceptance of any agreement as per > article 1316-1 of the French civil code. Groupe Serveur sas and > Artprice SA shall not be rendered liable in any manner whatsoever > for the delay and/or loss in transit of this message, for > corruption, alteration, falsification, misuse or fraudulent use > (which may be made) of this message. If you receive this message in > error, please delete it and immediately notify the sender. If the > reader of this message is not the intended recipient, you are > hereby notified that any unauthorized use, copying or dissemination > is prohibited." > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails_______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
Quoting Christophe Vigny <cvigny-TzZIYC/1obNWk0Htik3J/w@public.gmane.org>:> Hi I have encounter the same probleme !! > it happen using the rails pure ruby driver ! > > "Access denied for user: ''@myserver.com (Using password: NO)" > have u report the bug ? >I''ve not reported it as I only had a few minutes early this morning to work on my app. This is identically the issue I had after upgrading using "gem update". It''s as if it can''t locate the database config.
Quoting Brett Walker <walkerbl-O5WfVfzUwx8@public.gmane.org>:> I''m not sure, but I think this may indicate that you are running on > MySQL < 4.1. I had similar problems a while ago because of this. It > usually means that your using the wrong style authentication method > (it changed between versions). >I''m using mysql 5.0. To be fair, I should state that as part of this upgrade I also switched from postgres to mysql - so in reality this is the first time I''ve used rails against mysql for this rails install. I''ll go back and try it again against postgres to see if the upgrade broke that. I won''t be able to check until later this afternoon or this evening. I''m leaving work now and up here in New Hampshire in america we''re having a small blizzard! -k
Here is my mysql version: mysql Ver 14.7 Distrib 4.1.15, for portbld-freebsd5.3 (amd64) using 4.3 It is definitely something with RC 5 because I have not changed anything. Is there any way to downgrade back to the previous version of rails with gems? -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Kevin Bedell Sent: Friday, December 09, 2005 1:13 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: Re: [Rails] RC5 Mysql Troubles Quoting Christophe Vigny <cvigny-TzZIYC/1obNWk0Htik3J/w@public.gmane.org>:> Hi I have encounter the same probleme !! > it happen using the rails pure ruby driver ! > > "Access denied for user: ''@myserver.com (Using password: NO)" > have u report the bug ? >I''ve not reported it as I only had a few minutes early this morning to work on my app. This is identically the issue I had after upgrading using "gem update". It''s as if it can''t locate the database config. _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
gem install activerecord -v 1.13.0 gem uninstall activerecord -v 1.13.1 Gray, Jeffrey wrote:> Here is my mysql version: > mysql Ver 14.7 Distrib 4.1.15, for portbld-freebsd5.3 (amd64) using > 4.3 > It is definitely something with RC 5 because I have not changed > anything. > Is there any way to downgrade back to the previous version of rails with > gems?[snip]
The error message is saying that you are trying to log on with both a blank user name and password. Is this true? What happens when you try to logon with a non-blank user name and password? AR 1.13.1 now allows for the new MySQL authentication scheme in MySQL versions 4.1+. This is likely causing the problem. What version of MySQL are you using? Are you running with new-style or old style passwords? The old-style passwords are only about 14 characters long when seen in mysql.`user`.password field, and the new-style are about 3 times longer than that. If you are using the old-style passwords, create a new user with the new-style passwords and try to logon with that user. It should work. Gray, Jeffrey wrote:> I just upgraded to RC 5 using gem. > > Now my 2 apps both fail with mysql saying > > “Access denied for user: ''@servername_removed (Using password: NO)” > > I have changed nothing in any of the files. It is a result of the upgrade. > > Any ideas?
Hi Lou, 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>:> gem install activerecord -v 1.13.0 > gem uninstall activerecord -v 1.13.1That worked, thanks, but now webrick doesn''t start again: C:\ruby\anwendungen\shop>ruby script/server c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:194:in `report_activate_error'': RubyG em version error: activerecord(1.13.0 not = 1.13.1) (Gem::LoadError) from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:136:in `activate'' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:162:in `activate'' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:161:in `each'' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:161:in `activate'' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:23:in `re quire'' from ./script/../config/boot.rb:14 from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `re quire__'' from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `re quire'' from script/server:2 Any ideas? Downgrading rails via gem install rails -v 0.14.3 produces an error (Error installing gem rails[.gem]: No metadata found!). Thanks, Beate
2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>:> The error message is saying that you are trying to log on with both a > blank user name and password. Is this true? What happens when you try > to logon with a non-blank user name and password?I only hat a blank password. But I created a new user in mysql with no blank password, wrote this user ind database.yml, but same error. I have MySQL 4.0.25, my mysql.`user`.password field is 16 chars long. I tried to get an longer password, but it is allways 16chars long. Beate
for some reason gem isn''t able to download the rails gem file intact. You can manually download it at http://rubyforge.lauschmusik.de/gems/ and then install it locally: gem install rails*gem -l In order to start webrick you now have to specify it on the command line, script/server webrick The default web server has been changed to lighty, which I don''t think you want (or even have). Beate Paland wrote:> Hi Lou, > > 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>: > >>gem install activerecord -v 1.13.0 >>gem uninstall activerecord -v 1.13.1 > > > That worked, thanks, but now webrick doesn''t start again: > > C:\ruby\anwendungen\shop>ruby script/server > c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:194:in `report_activate_error'': RubyG > em version error: activerecord(1.13.0 not = 1.13.1) (Gem::LoadError) > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:136:in `activate'' > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:162:in `activate'' > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:161:in `each'' > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems.rb:161:in `activate'' > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:23:in `re > quire'' > from ./script/../config/boot.rb:14 > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `re > quire__'' > from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `re > quire'' > from script/server:2 > > Any ideas? Downgrading rails via > gem install rails -v 0.14.3 > produces an error (Error installing gem rails[.gem]: No metadata found!). > > Thanks, > Beate
I have username and password. Same error. Haven''t changed anything after upgrading to RC5. Database error started after upgrading. -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Beate Paland Sent: Friday, December 09, 2005 2:21 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: Re: [Rails] Re: RC5 Mysql Troubles 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>:> The error message is saying that you are trying to log on with both a > blank user name and password. Is this true? What happens when you try > to logon with a non-blank user name and password?I only hat a blank password. But I created a new user in mysql with no blank password, wrote this user ind database.yml, but same error. I have MySQL 4.0.25, my mysql.`user`.password field is 16 chars long. I tried to get an longer password, but it is allways 16chars long. Beate _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
That means you are using old-style passwords but ActiveRecord is trying to log you on with new-style passwords because it mistakening detected MySQL 4.1 authentication. Need to look around some more... Beate Paland wrote:> 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>: > >>The error message is saying that you are trying to log on with both a >>blank user name and password. Is this true? What happens when you try >>to logon with a non-blank user name and password? > > > I only hat a blank password. But I created a new user in mysql with no > blank password, wrote this user ind database.yml, but same error. > > I have MySQL 4.0.25, my mysql.`user`.password field is 16 chars long. > I tried to get an longer password, but it is allways 16chars long. > > Beate
On 12/9/05, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org> wrote:> > The error message is saying that you are trying to log on with both a > blank user name and password. Is this true? What happens when you try > to logon with a non-blank user name and password? > > AR 1.13.1 now allows for the new MySQL authentication scheme in MySQL > versions 4.1+. This is likely causing the problem. > > What version of MySQL are you using?I have the same problem, running MySQL 3.23.58. Connections worked fine with 0.14.3, now borked with 0.14.4 I don''t think "new style"passwords are an option with MySQL 3.23.58 James _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
it''s not pretty, but you can revert back to rails 14.3, even if you have to download each gem off the website manually. If I were you, I think that''s what I''d do until they sort this ActiveRecord mess out. <526 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install rails-0.14.3.gem -l Attempting local installation of ''rails-0.14.3.gem'' ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires actionpack = 1.11.0 <527 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install actionpack-1.11.0.gem -l Attempting local installation of ''actionpack-1.11.0.gem'' Successfully installed actionpack, version 1.11.0 Installing RDoc documentation for actionpack-1.11.0... <528 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install rails-0.14.3.gem -l Attempting local installation of ''rails-0.14.3.gem'' ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires actionmailer = 1.1.3 <529 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install actionmailer-1.1.3.gem -l Attempting local installation of ''actionmailer-1.1.3.gem'' Successfully installed actionmailer, version 1.1.3 Installing RDoc documentation for actionmailer-1.1.3... <530 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install rails-0.14.3.gem -l Attempting local installation of ''rails-0.14.3.gem'' ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires actionwebservice = 0.9.3 <531 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install actionwebservice-0.9.3.gem -l Attempting local installation of ''actionwebservice-0.9.3.gem'' Successfully installed actionwebservice, version 0.9.3 Installing RDoc documentation for actionwebservice-0.9.3... <532 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install rails-0.14.3.gem -l Attempting local installation of ''rails-0.14.3.gem'' Successfully installed rails, version 0.14.3 Lou Vanek wrote:> That means you are using old-style passwords but ActiveRecord is trying to > log you on with new-style passwords because it mistakening detected MySQL > 4.1 authentication. > Need to look around some more... > > > > Beate Paland wrote: > >> 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>: >> >>> The error message is saying that you are trying to log on with both a >>> blank user name and password. Is this true? What happens when you try >>> to logon with a non-blank user name and password? >> >> >> >> I only hat a blank password. But I created a new user in mysql with no >> blank password, wrote this user ind database.yml, but same error. >> >> I have MySQL 4.0.25, my mysql.`user`.password field is 16 chars long. >> I tried to get an longer password, but it is allways 16chars long. >> >> Beate
I have the following code snippet and I don''t understand why the
logger.info "Datestr" line is always logging to the log file before
the
"Scope 2.1" line when it clearly succeeds, not precedes "Scope
2.1" in
the code. Shouldn''t this code always produce a Datestr when given an
empty params[:scope]??
And how is it even freakin possible that I get an empty @datestr when I
assign it if both clauses of an if -> else -> end statement?
def noway
@scope = "empty"
logger.info "Scope 1: #@scope"
if params[:scope]
@scope = params[:scope]
logger.info "Scope 2.2: #@scope"
else
@scope = "last three days"
logger.info "Scope 2.1: #@scope"
end if
if @scope == "last three days"
@datestr = (Date.today - 3).strftime("%Y/%m/%d")
else
@datestr = "empty"
end if
logger.info "Datestr: #@datestr"
render :text => ''hello''
end
Development.log
-----
Processing DashboardController#noway (for 10.6.15.149 at 2005-12-09
15:37:35) [GET]
Parameters: {"action"=>"noway",
"controller"=>"dashboard"}
Scope 1: empty
Datestr:
Scope 2.1: last three days
Completed in 0.01600 (62 reqs/sec) | Rendering: 0.00000 (0%) | DB:
0.00000 (0%) | 200 OK [http://matterhorn/serveradm/dashboard/noway]
I decided to do just that - revert production back to 14.3 until a deployment test passes mustard. One easy way to do this is rake VERSION=0.14.3 freeze_gems This pulled the 0.14.3 gems into vendor/rails (assuming the old gems are still installed, which they probably are). And it seems to be working fine (freeze_gems it was broken for me in earlier releases). Cheers, Brett On Dec 9, 2005, at 2:09 PM, Lou Vanek wrote:> it''s not pretty, but you can revert back to rails 14.3, even if you > have to download > each gem off the website manually. If I were you, I think that''s > what I''d do until > they sort this ActiveRecord mess out. > > > <526 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > rails-0.14.3.gem -l > Attempting local installation of ''rails-0.14.3.gem'' > ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires > actionpack = 1.11.0 > <527 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > actionpack-1.11.0.gem -l > Attempting local installation of ''actionpack-1.11.0.gem'' > Successfully installed actionpack, version 1.11.0 > Installing RDoc documentation for actionpack-1.11.0... > <528 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > rails-0.14.3.gem -l > Attempting local installation of ''rails-0.14.3.gem'' > ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires > actionmailer = 1.1.3 > <529 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > actionmailer-1.1.3.gem -l > Attempting local installation of ''actionmailer-1.1.3.gem'' > Successfully installed actionmailer, version 1.1.3 > Installing RDoc documentation for actionmailer-1.1.3... > <530 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > rails-0.14.3.gem -l > Attempting local installation of ''rails-0.14.3.gem'' > ERROR: Error installing gem rails-0.14.3.gem[.gem]: rails requires > actionwebservice = 0.9.3 > <531 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > actionwebservice-0.9.3.gem -l > Attempting local installation of ''actionwebservice-0.9.3.gem'' > Successfully installed actionwebservice, version 0.9.3 > Installing RDoc documentation for actionwebservice-0.9.3... > <532 Lou_Vanek bash buffy730:/cygdrive/e/tmp>gem install > rails-0.14.3.gem -l > Attempting local installation of ''rails-0.14.3.gem'' > Successfully installed rails, version 0.14.3 > > > > Lou Vanek wrote: > >> That means you are using old-style passwords but ActiveRecord is >> trying to >> log you on with new-style passwords because it mistakening >> detected MySQL >> 4.1 authentication. >> Need to look around some more... >> Beate Paland wrote: >>> 2005/12/9, Lou Vanek <vanek-9H8CmIPm+GA@public.gmane.org>: >>> >>>> The error message is saying that you are trying to log on with >>>> both a >>>> blank user name and password. Is this true? What happens when >>>> you try >>>> to logon with a non-blank user name and password? >>> >>> >>> >>> I only hat a blank password. But I created a new user in mysql >>> with no >>> blank password, wrote this user ind database.yml, but same error. >>> >>> I have MySQL 4.0.25, my mysql.`user`.password field is 16 chars >>> long. >>> I tried to get an longer password, but it is allways 16chars long. >>> >>> Beate > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails
On 12/9/05, Brett Walker <walkerbl-O5WfVfzUwx8@public.gmane.org> wrote:> I decided to do just that - revert production back to 14.3 until a > deployment test passes mustard. > > One easy way to do this is > > rake VERSION=0.14.3 freeze_gems > > This pulled the 0.14.3 gems into vendor/rails (assuming the old gems > are still installed, which they probably are). And it seems to be > working fine (freeze_gems it was broken for me in earlier releases).If you use subversion, using the ''externals'' feature is quite handy. To update to 0.14.3 to 0.14.4, I type ''svn propedit svn:externals vendor'' and modify the the http:// path. And then type ''svn update'' and that brings down the new update. When I''ve tested it and it works, then I save the upgrade via ''svn commit''. Works great!
Lou, thank you, thank you! Downgrading worked fine :) And the bug has been already posted now. Lets wait for a solution. regards, Beate
bpaland wrote:> Lou, > > thank you, thank you! Downgrading worked fine :) > > And the bug has been already posted now. Lets wait for a solution. > > regards, > BeateHad the same problem, upgrading from 4.0 to 4.1 solved the problem... -- Posted via http://www.ruby-forum.com/.