Problem with "make initialize-database" - Client does not support authentication

RT Users
1

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.

[root@lionheart rt-3.2.2]# make initialize-database
/usr/bin/perl //usr/local/rt3/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user’s database password below. If the user has no database
password, just press return.

Password: DBI connect(’;host=localhost’,‘root’,…) failed: Client does not support authentication protocol requested by server;
consider upgrading MySQL client at //usr/local/rt3/sbin/rt-setup-database line 101
Failed to connect to dbi:mysql:;host=localhost as root: Client does not support authentication protocol requested by server;
consider upgrading MySQL client at //usr/local/rt3/sbin/rt-setup-database line 101, line 1.
make: *** [initialize-database] Error 255

Thanks for your help. Allyn

2

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

3

Thanks - I’ll give that a shot.----- 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