ToddF
12/10/2005 10:21:00 PM
Lou Vanek wrote:
> When you look at field mysql.`user`.password do you see strings that are
> about 16 characters long? If so, then for some reason old passwords are
> being used (they would be much longer, 41 bytes, if they are new
> passwords).
>
> If you are currently trying to log on with a user that has new passwords,
> then I'd try updating the password to the old, 16-character hash format.
> On the other hand, if you trying to log on with a user that has an old
> password, then you might try updating the password to the new, 41-character
> hash format.
>
> To change to an old-style password:
> mysql> SET PASSWORD FOR 'members'@'localhost' =
> OLD_PASSWORD('the_password');
>
> To change to a new-style password:
> mysql> SET PASSWORD FOR 'members'@'localhost' =
> PASSWORD('the_password');
>
> Then either restart the mysql server or run,
> mysqladmin reload
>
> You may also want to try changing 'host' from 'localhost' to the actual IP
> address, '127.0.0.1' in the yml file.
>
> If you cannot get any of this to work I suggest rolling back the
> gems until the problem is fixed.
>
>
>
> Stephan wrote:
>
>> Yan-Fa Li wrote:
>>
>>> Jeremy Kemper wrote:
>>>
>>>> On Dec 9, 2005, at 2:32 PM, Lou Vanek wrote:
>>>>
>>>>
>>>>>> It looks like ActiveRecord 1.13.1 for some reason is now trying to
>>>>>> log on using the new authentication method that MySQL 4.1+ uses.
>>>>>> A bug has been filed for this.
>>>>
>>>>
>>>>
>>>>
>>>> Because AR bundles the latest version of the pure-Ruby mysql driver
>>>> (0.2.6) along with a patch to support 4.1/5.0 servers. The patch has
>>>> a bug which breaks compatibility with 3.23/4.0.
>>>>
>>>>
>>>>
>>>>>> In the mean time you may want to either revert your rails gems,
>>>>>> update the database, or perform some fu on mysql.rb 'real_connect'.
>>>>
>>>>
>>>>
>>>>
>>>> Or install the mysql-ruby C bindings, which have always worked:
>>>> gem install mysql
>>>>
>>>> jeremy
>>>
>>>
>>>
>>>
>>> On FC4 you may need to type:
>>>
>>> sudo gem install mysql -- --with-mysql-lib=/location/of/your/mysqllibs
>>>
>>> e.g. sudo gem install mysql -- --with-mysql-lib=/usr/lib64/mysql
>>>
>>> on an AMD64 system
>>>
>>>
>>> Yan
>>>
>>>
>>
>> Thanks for your help, but I still didn't get it working.
>>
>> I have MySQL version 4.1.15 and I have set old_passwords=0 in the
>> MySQL config file. So the MySQL version should not be a problem here,
>> right?
>>
>> I installed the gem with the command given above, with the following
>> result:
>> gem install mysql -- --with-mysql-lib=/usr/lib/mysql
>> <...cut...>
>> Successfully installed mysql-2.7
>>
>> After this the problem remains. There is a slight difference in the
>> error message, it is now: "Access denied for user
>> 'members'@'localhost' to database 'dev_members'", so the error number
>> is missing now.
>>
>> Any more ideas?
>>
>>
>> Stephan
>>
>>
>
>
>
Ok thanks to all who answered, this OLD_PASSWORD thing seems to have
fixed the problem.
Stephan