[Codestriker-user] Re: Problem with mysql 5.0.20 and codestriker 1.9.1

[David S. <si...@us...>]

Hi Thomas,

> I am having a problem using Codestriker 1.9.1 with mysql 5.0.20 and
> apache 2.0.52 on a Solaris 9 server. Codestriker was working with mysql
> 4.0.14 - but I upgraded to 5.0.20. I am getting the following error:

I have had other people telling me they have had problems with MySQL 
5.0.  There seems to be issues with Perl 5.6.X in particular, but we 
never had the chance to fully track down the root causes.  This may not 
be at play here anyway.

> [Thu May 04 16:10:12 2006] [error] [Thu May  4 16:10:12 2006] -e: DBI
> connect('database=codestrikerdb','codestriker',...) failed: Client does
> not support authentication protocol requested by server; consider
> upgrading MySQL client at
> /usr/local/apache2/codestriker/codestriker-1.9.1/bin/../lib/Codestriker/
> DB/Database.pm line 58\n
> 
> So the first thing I thought was I needed to upgrade (or recompile
> DBD:mysql I am on version 3.0002) which I did and also upgraded DBI to
> v1.50.

You probably did this already, but bear in mind if you recompile 
DBD:mysql, make sure the source distribution of MySQL it is compiling 
against is indeed version 5.0, and not an older version.

> DBI and DBD are working for Bugzilla and a few other programs - so I
> know the modules are working. The curious thing is that Codestriker
> install.pl program is working just fine - no errors.

Strange - perhaps the user running apache has a difference environment 
setup such that it is picking up an older version of the DBD::mysql perl 
module compared to root?

Perhaps you could try running install.pl as the same user that runs 
apache as a test.

Cheers,
David