[rt-users] Problem with "make initialize-database" - Client doesnot support authentication

[Ruslan U. Zakirov]

Allyn Baskerville wrote:
> I've already read about this and done it, but I have the same problem. 
> This system never had any other version of MySQL other than the current 
> one of 4.1.8-0. Given that, should I even have to do this?
May be you've done wrong things? 'old-passwords' should work.

Other way is _build_ DBD::mysql 2.9004 from sources and necessarily 
against mysql 4.1.x client libs. Binary RPMs wouldn't help you here. If 
you have SRC.RPM of the DBD::mysql 2.9004 then you can use it too.

See also:
http://www.issociate.de/board/post/147728/MySQL_4.1.7_req'd_DBD_Version.html

> 
> 
> ----- Original Message ----- From: "Ruslan U. Zakirov" 
> <Ruslan.Zakirov at acronis.com>
> To: "Allyn Baskerville" <allynb at adsne.com>
> Cc: <rt-users at lists.bestpractical.com>
> Sent: Tuesday, January 11, 2005 9:25 AM
> Subject: Re: [rt-users] Problem with "make initialize-database" - Client 
> doesnot support authentication
> 
> 
>> Easy way is --old-passwords
>> Read about it on:
>> http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
>>
>> Allyn Baskerville wrote:
>>
>>> OK, I completely rebuilt the system. The only errors I saw was when I 
>>> built mysql-server:
>>>
>>> warning: MySQL-server-4.1.8-0.i386.rpm: V3 DSA signature: NOKEY, key 
>>> ID 5072e1f5
>>> Preparing...                
>>> ########################################### [100%]
>>>   1:MySQL-server           
>>> ########################################### [100%]
>>> 050111  7:45:37 [Warning] Asked for 196608 thread stack, but got 126976
>>> 050111  7:45:38 [Warning] Asked for 196608 thread stack, but got 126976
>>>
>>> I read a couple posts that these warnings were not serious, so I 
>>> continued. All the database information was built when I did a "make 
>>> install" with RT3. Not a single error here. So after completing the 
>>> install, I went to the web page, which returned an "internal server 
>>> error." The logs show the following:
>>>
>>> DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Client 
>>> does not support authentication protocol requested by server; 
>>> consider upgrading MySQL client at 
>>> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 96
>>> [Tue Jan 11 09:03:43 2005] [error] Connect Failed Client does not 
>>> support authentication protocol requested by server; consider 
>>> upgrading MySQL client\n at /usr/local/rt3/lib/RT.pm line 168\n
>>>
>>> For both DBI and DBD, I've installed RPMs and tarballs, and I still 
>>> can't get past this error. I'm a noob with sql, so I'm not sure what 
>>> to try. I've found a couple of sites that show this error when 
>>> upgrading MySQL from 3.x to 4.x because of a password hashing scheme, 
>>> but MySQL-4.1.8 was installed from scratch.
>>>
>>> Thanks for any help. Allyn
>>>
>>>
>>>
>>>> ----- Original Message ----- From: "Jesse Vincent" 
>>>> <jesse at bestpractical.com>
>>>> To: "Allyn Baskerville" <allynb at adsne.com>
>>>> Cc: <rt-users at lists.bestpractical.com>
>>>> Sent: Sunday, January 09, 2005 1:49 AM
>>>> Subject: Re: [rt-users] Problem with "make initialize-database" - 
>>>> Client does not support authentication
>>>>
>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Sun, Jan 09, 2005 at 01:35:19AM -0600, Allyn Baskerville wrote:
>>>>>
>>>>>> I have made it to step 14 of the Fedora Core 2 + RT 3.2.x Install 
>>>>>> Guide, but I've run into a MySQL error shown at the bottom. I have 
>>>>>> the following MySQL RPMs installed:
>>>>>>
>>>>>> MySQL-server-4.1.8-0
>>>>>> MySQL-client-4.1.8-0
>>>>>> MySQL-devel-4.1.8-0
>>>>>> MySQL-shared-compat-4.1.8-0
>>>>>> MySQL-shared-4.1.8-0
>>>>>>
>>>>>> I've found a lot of mailing lists that show this error, but I 
>>>>>> haven't found a solution.  I also have no experience with 
>>>>>> databases, so I'm not really sure how to start troubleshooting and 
>>>>>> there isn't anything significant in the logs.
>>>>>
>>>>>
>>>>>
>>>>> Probably time to rebuild your DBD::MySQL
>>>>>