From: Rob Church <robchur(a)gmail.com>
Ordinarily I'd bawl at you to upgrade PHP as being the easier route;
this being a classic indicator of the old, "PHP's mySQL binaries are
out of date with the new authentication in mySQL 5"...however as other
applications are working, this might be a useless task...
Yea, I briefly considered that, but the other sites (including MW1.4
sites) ARE working with MySQL 5, and this is a spankin' brand new
installation of MacOS X 10.4.3, complete with the latest patches.
<?php phpinfo() ?> reports PHP Version 4.3.4, but I see that it also
reports mysql Client API Version 3.23.49. Sigh. I'll poke around a
bit more...
Is there anything changed between 1.4 and 1.5 that might be using a
new PHP <---> MySQL API?
I *really* don't want to change PHP from the Apple-supplied version
if I don't have to. The last time I did that, my clients' sites were
down for a week while I hunted down various things that broke. I
guess I'll go see what Liyanage is bundling these days...
Rob Church
On 13/12/05, Jan Steinman <Jan(a)bytesmiths.com> wrote:
> Well, I touched the GRANT table for the MySQL user for this site, and
> re-loaded, and now it gets a bit further. Instead of a stack trace, I
> now get the following:
>
>> Sorry! This site is experiencing technical difficulties.
>>
>> Try waiting a few minutes and reloading.
>>
>> (Can't contact the database server: Client does not support
>> authentication protocol requested by server; consider upgrading
>> MySQL client (localhost))
>
> Does this suggest anything?
>
> Again, this site (
www.EcoReality.org) was working fine with MySQL
> 4.0.16, and my other wikis that are at MW1.4 are working fine with
> MySQL 5.0.16.
>
> :::: He who joyfully marches to music in rank and file has already
> earned my contempt. He has been given a large brain by mistake, since
> for him the spinal cord would fully suffice. -- Albert Einstein
> :::: Jan Steinman <http://www.Bytesmiths.com/Item/99-6313-16>
:::: The better you live, the more oil you use. -- Esso
advertisement, New Yorker, 1949
:::: Jan Steinman <htp://www.Bytesmiths.com/Van>