Women in Technology

Hear us Roar



Article:
  Rolling with Ruby on Rails
Subject:   ActiveRecord error?
Date:   2005-09-20 21:01:30
From:   curth
Response to: ActiveRecord error?

Can you run the source code as it exists in the zip file you downloaded? If so, then use a comparison tool to see what is different between that version and yours.
Full Threads Oldest First

Showing messages 1 through 5 of 5.

  • ActiveRecord error?
    2005-09-21 12:19:43  CSBaum [View]

    Found out the issue, according to the Wiki on MySQL access problems, MySql version 4.1.x introduced a new password hashing mechanism that is incompatible with the previously used scheme. The quick work around was to create a new user w/o a password that only has access to the cookbook db. The other proposed solution is to install the mysql gem, which I quickly tried, but it looks like it uses *nix make files, etc...

    Thanks for the help, I really like the article and am looking forward to the second installment.

    Sean
    • ActiveRecord error?
      2005-11-26 17:29:08  jaykali [View]

      I just got on board with this tutorial and I'm having trouble with the password hash/invalid error. I ended up using the quick fix by resetting the root password to nothing but I'd rather know how to fix it so that users can have passwords. Little help?
      • Curt Hibbs photo ActiveRecord error?
        2005-11-26 19:25:10  Curt Hibbs | O'Reilly AuthorO'Reilly Blogger [View]

        If you're using a recent version of MySQL 4.1.x and the most recent version of rails, then passwords should work without any problems. Otherwise, you'll need to read up on the issue:

        http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

        http://mysqld.active-venture.com/Password_hashing.html

        http://dev.mysql.com/doc/refman/5.0/en/old-client.html

        You can also post questions to the Rails mailing list:

        http://wiki.rubyonrails.com/rails/pages/MailingLists
    • Curt Hibbs photo ActiveRecord error?
      2005-09-21 12:26:56  Curt Hibbs | O'Reilly AuthorO'Reilly Blogger [View]

      I'm glad to hear you are moving forward. Although I am still a little puzzled, because for at least the las six months, all versions of Rails support the new password scheme.
  • ActiveRecord error?
    2005-09-21 04:08:46  CSBaum [View]

    Curth,

    I have tried manually recreating the db and it's tables and tried the zip set of code based on your suggestion, both of which did not work...any other ideas as to why the ActiveRecord would have a problem with the SHOW FIELDS query?

    Sean