Connect Ruby on rails to MySQL

Le Sa wrote:

Nik Kumar wrote:

Can anyone please give the steps(commands) how to connect ruby on rails
to MySQl in fedora8.

I have installed MySQL and Ruby in my system.

Please specify any further installations to be done

Reply will be appreciated.

http://www.google.com/search?q=rails+mysql
I'm not sure if it's the same for all OS, but you can try this:
your_app/config/database.yml

# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
  adapter: mysql
  database: your_database
  username: user
  password: password

# 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.
test:
  adapter: mysql
  database: your_database_test
  username: user
  password: password

production:
  adapter: mysql
  database: your_database_production
  username: user
  password: password

I have tried this in my system(fedora 8) and I am getting this error

[root@xenhost]# SQLite version 3.x
bash: SQLite: command not found
[root@xenhost]# gem install sqlite3-ruby
Building native extensions. This could take a while...
ERROR: Error installing sqlite3-ruby:
        ERROR: Failed to build gem native extension.

/usr/bin/ruby extconf.rb
checking for fdatasync() in -lrt... no
checking for sqlite3.h... no

make
make: *** No rule to make target `ruby.h', needed by
`sqlite3_api_wrap.o'. Stop.

Gem files will remain installed in
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4 for inspection.
Results logged to
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3_api/gem_make.out

NIk,
Are all these installed on your pc: libdbd-sqlite3-ruby sqlite3 libsqlite3-dev libsqlite3-ruby

Why are you doing this if you want to use MySQL?