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

[Allyn Baskerville]

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
>>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
>
>