Tag: error

  • Rails: Error with MySQL in welcome screen

    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.

     

    Welcome Message
    Welcome Message

    But then clicking on the About your application’s environment displayed a error message like below.

     

    Error in Rails
    Error in Rails

    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.

    Success message
    Success message