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