To fix the error, “This application has failed to start because LIBMYSQL.DLL was not found. Re-installing the application may fix this problem.” while working on rails using mysql as the database,
Copy the libmysql.dll found in the mysql installation directory (mysql\bin) and paste it in your ruby installation directory (ruby\bin)
Restart the server and viola, the error is fixed.
Trying out a sample application using rails, I faced a problem, getting the database tables created (migrated) using ‘rake’. Running the command
rake migrate
threw the following error
(in /home/rajesh/Programming/rails/todolist) rake aborted! Don't know how to build task 'migrate' (See full trace by running task with --trace)
The search on internet forums only said that ‘rake migrate’ should do the job, but to no avail.
The actual command to get the tables created is
rake db:migrate
Hope this helps!
After installing rails, to test it, I created a rails application using the following command at the command prompt.
rails -d mysql todolist
Pointing to http://localhost:3000 displayed the expected Welcome message.
But then clicking on the About your application’s environment displayed a error message like below.
That’s the least thing I expected. Digging into the development.log file located in the project log directory, displayed the actual error message, “Client does not support authentication protocol requested by server; consider upgrading MySQL client”.
Looking into the web for help, the problem with the way rails (as a client) was trying to access MySQL server. Rails uses a old password hashing used in MySQL 4.1, and the current version that I am running is MySQL 5.0. This had caused the error. The fix is running the following script in mysql prompt.
mysql> SET PASSWORD FOR 'railsuser'@'host' = OLD_PASSWORD('password');
That fixes it and you would get the following screen.
After a unsuccessful installation of rails that took nearly 5 hours, I decided to get rid of Ruby. But the geek inside me, wanted me to go for the kill. That started the quest of successfully installing and deploying rails on WAMP server. Here are the steps.
Requirements:
Installation Instructions:
gem install rake-x.x.x --local
gem install gem-x.x.x --local
This will get Rails installed on the machine. The total install time should be close to 10 minutes.
Installing Rails needs a lot of patience. The command is simple “gem install rails”. But it is a resource hungry and a time consuming installation.
I started the installation at 00:00:00 HRS and it is 03:22:23 HRS now and the installation is still going on.
And look at the memory footprint of the ruby program that is installing rails.
And here is the Performance Statistics:
Why is an installation taking such a long time?
Raasukutty's 