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.

rails mysql - Google Search 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?