On 12/13/05, Jan Steinman <Jan(a)bytesmiths.com> wrote:
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.
If those sites were installed under the old version of MySQL and you
haven't done anything to change them, they'll still have the old-style
passwords on their db user accounts.
If you installed a new wiki under MySQL 5.0, it'll show
<?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...
PHP 4.x includes built-in libraries for MySQL 3.23.x, which is
compatible with MySQL 4.0.x. MySQL 4.1.x changes the protocol a bit,
most annoyingly in the authentication protocol. Please see the
documentation on
dev.mysql.com for more details there on workarounds
if you need to use the old libraries.
If you recompile PHP against the updated MySQL libraries, it will be
able to use the new-style passwords without problems.
Is there anything changed between 1.4 and 1.5 that
might be using a
new PHP <---> MySQL API?
Most likely you installed a new MediaWiki installation, so it assigned
new GRANTs and created a new password; a new 1.4 installation would do
the same.
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...
On my Mac boxen I'm actually using lighttpd and several versions of
PHP compiled using the CGI interface. However I use these boxes for
testing (hence the multiple versions of PHP!) not for production use.
-- brion vibber (brion @
pobox.com)