Problem with "make initialize-database" - Client doesnot support authentication

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

Easy way is --old-passwords
Read about it on:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html

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?----- Original Message -----
From: “Ruslan U. Zakirov” Ruslan.Zakirov@acronis.com
To: “Allyn Baskerville” allynb@adsne.com
Cc: rt-users@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@bestpractical.com
To: “Allyn Baskerville” allynb@adsne.com
Cc: rt-users@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


The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com


The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

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:

Allyn Baskerville wrote:

I think I’m catching on here. Thanks for your input.
Where was problem? How did you fix it? solution should be posted on
wiki, may be you can do it?

		Regards. Ruslan.

PS: always cc to the lists even if answer is “works”.