Problem when changing default sqlite to mysql

Rails
1

hi all,
i installed rails 2.1.0 just now before i was working with rails
1.2.6. when i try to check the application enviroment link in the index
page of the application it gave me
" MissingSourceFile in Rails/infoController#properties
no such file to load – sqlite3RAILS_ROOT:
D:/RadRails/Workspace/Varsha "
here i am using win XP, no sqlite installed.

i have mysql in my network so i changed (default db sqlite to mysql in
)the app_enviroment.rb file of rails gem folder but it’s raised an error
like…

Errno::EBADF in Rails/infoController#properties
Bad file descriptor - connect(2)
RAILS_ROOT: D:/RadRails/Workspace/Varsha

Application Trace | Framework Trace | Full Trace
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/vendor/mysql.rb:111:in
`initialize’
…
…

plz. guide me to solve the above.

thanks in advance
madhan.

2

Hi Madhan,

My guess is that Rails is trying to connect to your MySql server via a
socket, which - on Windoze - can be a tad problematic… try
configuring Rails so that it makes a TCP connection instead, by setting:

host: THE_NAME_OF_YOUR_WINDOZE_BOX
port: 3306

… in your application’s database.yml file.

Good luck,

Peter