Newbie Trouble with RubyOnRails Bible

[Arthur_Fuller]

Hello all,
I am new to RoR and am working my way through Timothy Fisher’s Ruby On
Rails
Bible. I’m stuck on page 81. I have followed the steps leading to this
page,
i.e.

cd rails_projects
rails contactlist

ruby script/server webrick

open a cmd window and run mysql: create database
contactlist_development;
use contactlist_development;
create table contacts (id int not null auto_increment, …etc.);
show tables;

describe contacts;


ruby script/generate model Contact

<look at app/models/contact.rb, which shows:>
class Contact < ActiveRecord:: Base
end
ruby script/console
Loading development environment

my_contact = Contact.new
<here’s the problem: instead of showing me the attributes of the
instance, I
get the message:
ActiveRecord::StatementInvalid: Could not find table ‘contacts’ from
c:\program files\BitNami RubyStack/ruby/lib/ruby/gems… etc… and
many
other error messages too.

Ohhh! I just noticed that another of the error messages indicates that
it is
looking for a sqlite3_adapter.rb:29. Hmmm. How do I tell it that I’m
using
mySQL not sqlite?

For most or all of you, this is probably a trivial question, but for me
it
is a show stopper. I’m very excited by the language and the framework
and
the book, but at the moment I’m slamming my forehead on this wall.
Please
help.

TIA,
Arthur

[Arthur_Fuller]

Hi –

On Sun, 27 Sep 2009, Arthur Fuller wrote:

Ohhh! I just noticed that another of the error messages indicates that it is looking for a
sqlite3_adapter.rb:29. Hmmm. How do I tell it that I’m using mySQL not sqlite?

When you create the app, you can do:

rails myapp --database=mysql

If you’ve already created the app, do the above on a second app, then
look at config/database.yml and you’ll see the difference in
configuration (which you can then adapt for your original app by
editing its database.yml).

David

–
David A. Black, Director
Ruby Power and Light, LLC (http://www.rubypal.com)
Ruby/Rails training, consulting, mentoring, code review
Book: The Well-Grounded Rubyist (http://www.manning.com/black2)

[Arthur_Fuller]

Also, after creating the app with the appropriate database selected,
you will want to confirm the settings in the db configuration file
“application/config/database.yml”. Specifically check the values for
“database”, “username”, and “password” that are associated with all 3
modes (development, test, production).

By the way, “rails --help” will give you a list of all command line
options.

See also: http://guides.rubyonrails.org/

[Arthur_Fuller]

Here’s a helpful resource:

http://guides.rubyonrails.org/getting_started.html

search for ‘mysql’ and you’ll find an example configuration.