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.
I'm not sure if it's the same for all OS, but you can try this:

# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
  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.
  adapter: mysql
  database: your_database_test
  username: user
  password: password

  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: *** 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

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?