On 12/13/05, Jan Steinman Jan@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)