Hi, I''m new to Ruby, Rails and MySQL... Before Dropping my database, I went back to a previous Grant problem. On page 54, there are three create database commands...these all worked fine for me. I then tried the following Grant command: Grant all on depot_development.* to ''dave''@''localhost''; I got back the following error message: Error 1133 (42000): can''t find any matching row in the user table Just for the heck of it, I ran the following query: Select host,user,password from mysql.user And sure enuf ''dave'' is not there... So, I figured that I would insert dave into mysql.user. This succeeded and when I tried to do the grant again it worked. But when I tried the command on page 57: Ruby script/generate scaffold Product admin I got the error message on the previous email. I tried this command with ''Product'', ''Products'', ''product'' and ''products'' -- all failed... I''m just following what''s in the book...Other folks have run into this same problem...but no fix has been given... The author''s statement: "That wasn''t hard now, was it?" This is on page 57. The question is obviously rhetorical but it is severely mocking me... Can anyone help me with this? Cheers, Pat -----Original Message----- From: Pat Lynch [mailto:lynchnco@patmedia.net] Sent: Monday, May 08, 2006 9:27 PM To: ''benr@x-cr.com''; ''rails@lists.rubyonrails.org'' Subject: RE: [Rails] Agile Web Development with Rails Hi, Thanks for responding... I set the Database.yml file to those given by the author on page 56 in Figure 6.1. I couldn''t grant permissions using the procedures shown by the author on pg 54. I''ll delete the database and try again... Wish me luck, Pat -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Ben Reubenstein Sent: Monday, May 08, 2006 9:01 PM To: rails@lists.rubyonrails.org Subject: Re: [Rails] Agile Web Development with Rails Your database is not configured properly. Rails cannot access it. Check your database.yml file and database user/pass settings. ~Ben On 5/8/06, Pat Lynch <lynchnco@patmedia.net> wrote:> > > > Hi, > > I put this on the forum.but perhaps one of you can help me solve this > problem.but the problem has been on it for about 5 months and still noreal> answer. > > > > On page 57 in the book "Agile Web Development with Rails" there is the > following command: > > "ruby script/generate scaffold Product Admin" > > When I invoke it, I get the following error message: > > "#28000 access denied for user ''root''@''localhost'' using password [NO]" > > > > I''d appreciate any help. > > > > Thanks, > > Pat > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-- Ben Reubenstein 303-947-0446 http://www.benr75.com _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails
Hey Pat, are you referencing the errata as you''re going through the tutorials. This may help a GREAT deal. If not, I would recommend going to the pragmaticprogrammer.com. Peace, -Conrad On 5/8/06, Pat Lynch <lynchnco@patmedia.net> wrote:> > Hi, > I''m new to Ruby, Rails and MySQL... > Before Dropping my database, I went back to a previous Grant problem. > > On page 54, there are three create database commands...these all worked > fine for me. > > I then tried the following Grant command: > Grant all on depot_development.* to ''dave''@''localhost''; > I got back the following error message: > Error 1133 (42000): can''t find any matching row in the user table > > Just for the heck of it, I ran the following query: > Select host,user,password from mysql.user > And sure enuf ''dave'' is not there... > > So, I figured that I would insert dave into mysql.user. This succeeded > and when I tried to do the grant again it worked. > > But when I tried the command on page 57: > Ruby script/generate scaffold Product admin > I got the error message on the previous email. > > I tried this command with ''Product'', ''Products'', ''product'' and > ''products'' -- all failed... > > I''m just following what''s in the book...Other folks have run into this > same problem...but no fix has been given... > > The author''s statement: "That wasn''t hard now, was it?" This is on page > 57. The question is obviously rhetorical but it is severely mocking > me... > > Can anyone help me with this? > > Cheers, > Pat > > -----Original Message----- > From: Pat Lynch [mailto:lynchnco@patmedia.net] > Sent: Monday, May 08, 2006 9:27 PM > To: ''benr@x-cr.com''; ''rails@lists.rubyonrails.org'' > Subject: RE: [Rails] Agile Web Development with Rails > > Hi, > > Thanks for responding... > > I set the Database.yml file to those given by the author on page 56 in > Figure 6.1. > > I couldn''t grant permissions using the procedures shown by the author on > pg 54. > > I''ll delete the database and try again... > > Wish me luck, > Pat > > -----Original Message----- > From: rails-bounces@lists.rubyonrails.org > [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Ben > Reubenstein > Sent: Monday, May 08, 2006 9:01 PM > To: rails@lists.rubyonrails.org > Subject: Re: [Rails] Agile Web Development with Rails > > Your database is not configured properly. Rails cannot access it. > Check your database.yml file and database user/pass settings. > > ~Ben > > On 5/8/06, Pat Lynch <lynchnco@patmedia.net> wrote: > > > > > > > > Hi, > > > > I put this on the forum.but perhaps one of you can help me solve this > > problem.but the problem has been on it for about 5 months and still no > real > > answer. > > > > > > > > On page 57 in the book "Agile Web Development with Rails" there is the > > following command: > > > > "ruby script/generate scaffold Product Admin" > > > > When I invoke it, I get the following error message: > > > > "#28000 access denied for user ''root''@''localhost'' using password [NO]" > > > > > > > > I''d appreciate any help. > > > > > > > > Thanks, > > > > Pat > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > > > > -- > Ben Reubenstein > 303-947-0446 > http://www.benr75.com > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060509/fd3443e0/attachment-0001.html
Pat Lynch wrote:> I then tried the following Grant command: > Grant all on depot_development.* to ''dave''@''localhost''; > I got back the following error message: > Error 1133 (42000): can''t find any matching row in the user table > > Just for the heck of it, I ran the following query: > Select host,user,password from mysql.user > And sure enuf ''dave'' is not there... > > So, I figured that I would insert dave into mysql.user. This succeeded > and when I tried to do the grant again it worked.This is good sleuthing.> But when I tried the command on page 57: > Ruby script/generate scaffold Product admin > I got the error message on the previous email.The error in the previous email said:> "#28000 access denied for user ''root''@''localhost'' using password [NO]"This means that you haven''t changed you database.yml. You need to change the username to ''dave''.> The author''s statement: "That wasn''t hard now, was it?" This is on page > 57. The question is obviously rhetorical but it is severely mocking > me...This configuration step is one of the hardest, just because there are so many possibilities. And it isn''t hard if it just works, but if it doesn''t, it is. Good luck, -- Ray
Hi, Yeah, I went thru the errata and went on the forum. The forum is not very active though. The same problem was posted about 6 months ago - but no answer was given. It turns out that the answer was in the book on page 56 all the time. The author had me change database.yml to username: <blank>. He then states: "Should you get an error such as Access denied for user ''root''@''localhost.locoaldomain'', put an explicit username in these two fields". Well my face is red.problem solved. Let me give you one more puzzle.it is: On page 54, the author had me create three databases and then do three grants. One of the grants was: Grant all on depot_development.* to ''dave''@''localhost''; The response was: Error 1133(42000): can''t find any matching row in the user table. When I ran the query: Select host,user,password from mysql.user Sure enuf dave was not there. When I inserted ''localhost'', ''dave'' '' '' and then reran the grant it worked fine. I''d appreciate any help.I''m just curious about this one.I''ll check the errata. Good day.hope I can return the favor someday. Cheers, Pat It turns -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Conrad Taylor Sent: Monday, May 08, 2006 9:43 PM To: rails@lists.rubyonrails.org Subject: Re: [Rails] Agile Web Development with Rails Hey Pat, are you referencing the errata as you''re going through the tutorials. This may help a GREAT deal. If not, I would recommend going to the pragmaticprogrammer.com. Peace, -Conrad On 5/8/06, Pat Lynch <lynchnco@patmedia.net> wrote: Hi, I''m new to Ruby, Rails and MySQL... Before Dropping my database, I went back to a previous Grant problem. On page 54, there are three create database commands...these all worked fine for me. I then tried the following Grant command: Grant all on depot_development.* to ''dave''@''localhost''; I got back the following error message: Error 1133 (42000): can''t find any matching row in the user table Just for the heck of it, I ran the following query: Select host,user,password from mysql.user And sure enuf ''dave'' is not there... So, I figured that I would insert dave into mysql.user. This succeeded and when I tried to do the grant again it worked. But when I tried the command on page 57: Ruby script/generate scaffold Product admin I got the error message on the previous email. I tried this command with ''Product'', ''Products'', ''product'' and ''products'' -- all failed... I''m just following what''s in the book...Other folks have run into this same problem...but no fix has been given... The author''s statement: "That wasn''t hard now, was it?" This is on page 57. The question is obviously rhetorical but it is severely mocking me... Can anyone help me with this? Cheers, Pat -----Original Message----- From: Pat Lynch [mailto:lynchnco@patmedia.net] Sent: Monday, May 08, 2006 9:27 PM To: ''benr@x-cr.com''; ''rails@lists.rubyonrails.org'' Subject: RE: [Rails] Agile Web Development with Rails Hi, Thanks for responding... I set the Database.yml file to those given by the author on page 56 in Figure 6.1. I couldn''t grant permissions using the procedures shown by the author on pg 54. I''ll delete the database and try again... Wish me luck, Pat -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto: <mailto:rails-bounces@lists.rubyonrails.org> rails-bounces@lists.rubyonrails.org] On Behalf Of Ben Reubenstein Sent: Monday, May 08, 2006 9:01 PM To: rails@lists.rubyonrails.org Subject: Re: [Rails] Agile Web Development with Rails Your database is not configured properly. Rails cannot access it. Check your database.yml file and database user/pass settings. ~Ben On 5/8/06, Pat Lynch < <mailto:lynchnco@patmedia.net> lynchnco@patmedia.net> wrote:> > > > Hi, > > I put this on the forum.but perhaps one of you can help me solve this > problem.but the problem has been on it for about 5 months and still noreal> answer. > > > > On page 57 in the book "Agile Web Development with Rails" there is the > following command: > > "ruby script/generate scaffold Product Admin" > > When I invoke it, I get the following error message: > > "#28000 access denied for user ''root''@''localhost'' using password [NO]" > > > > I''d appreciate any help. > > > > Thanks, > > Pat > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org <mailto:Rails@lists.rubyonrails.org> > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-- Ben Reubenstein 303-947-0446 http://www.benr75.com _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060509/427be7a4/attachment-0001.html
Hi, Thanks Ray...it turns out that the author had given the answer you gave below...So ''my face is red''... I changed from <blank> to dave and it worked fine... Thanks for you good advice... I hope I can return the favor someday. Ciao, Pat -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Ray Baxter Sent: Monday, May 08, 2006 9:54 PM To: rails@lists.rubyonrails.org Subject: [Rails] Re: Agile Web Development with Rails Pat Lynch wrote:> I then tried the following Grant command: > Grant all on depot_development.* to ''dave''@''localhost''; > I got back the following error message: > Error 1133 (42000): can''t find any matching row in the user table > > Just for the heck of it, I ran the following query: > Select host,user,password from mysql.user > And sure enuf ''dave'' is not there... > > So, I figured that I would insert dave into mysql.user. This succeeded > and when I tried to do the grant again it worked.This is good sleuthing.> But when I tried the command on page 57: > Ruby script/generate scaffold Product admin > I got the error message on the previous email.The error in the previous email said:> "#28000 access denied for user ''root''@''localhost'' using password [NO]"This means that you haven''t changed you database.yml. You need to change the username to ''dave''.> The author''s statement: "That wasn''t hard now, was it?" This is onpage> 57. The question is obviously rhetorical but it is severely mocking > me...This configuration step is one of the hardest, just because there are so many possibilities. And it isn''t hard if it just works, but if it doesn''t, it is. Good luck, -- Ray _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails