[rt-users] Installing a rt-3.4.0 on fedora 3 - mysql issue during the make initialize-database

[Maxime Levasseur]

Hi all,

I'm trying a new install on a new box.
Fedora Core 3, full install.
I made the Mysql upgrade to a 4.1.9 standard version without any problem.
No missing dependancies at all.

Off course i'm root during the install.

make install ==> no problem.
make initialize-Database ==>

[root at rt2 rt-3.4.0]# 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 or update your RT 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: I give the good 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, <STDIN> line 1.
make: *** [initialize-database] Erreur 255

Ooops ... 

So I passed the following command : SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('xxxxxxx');
and tried a Make initialize-database again and now i have : 

[root at rt2 rt-3.4.0]# make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password

In order to create or update your RT 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:xxxxxx
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Done setting up database ACLs.
Now inserting RT core system objects
[Tue Feb  1 22:44:29 2005] [crit]: Connect Failed Client does not support authentication protocol requested by server; consider upgrading MySQL client
 at //opt/rt3/sbin/rt-setup-database line 384
 (/opt/rt3/lib/RT.pm:285)
make: *** [initialize-database] Error 255

What can ( must) i do now ?


Best Regards and thanks for your help.

Max.