Michael Fearn (gmail) wrote: [snip]
- Attempting to connect to database server as sitedb...success.
- Connected to 3.23.58-log -- mysql 4.0 or later required. Aborting.
This implies to me that the MediaWiki installer is being told the mysql intalled on the webserver is version 3.23.58 However when I ssh into the webserver and do mysql -V it comes up with
Ver 14.7 Distrib 4.1.13 for portbld-freebsd4.11 (i386) using readline 5.0
- Which version (or versions) of mysql do people think is installed?
Offhand it sounds like you have a mix: the command-line tools in your $PATH are 4.1, but you've got a 3.23 server running.
Connect to the server with mysql and run 'SELECT VERSION();' to find out the version of the server you're connecting to by default.
- Can i run any commands to see if multiple versions are installed?
Try the brute force approach! ;) $ locate mysql
- Can i change any settings in the MediaWiki installation or .htaccess to
force which version of mysql is used?
There are two components:
* Which running server you connect to is controlled by the server you specify. The default is 'localhost' which connects over a socket file, usually in /tmp/mysql.sock or /var/run/mysql.sock or something. If you are *running multiple servers at once* you can either connect explicitly to their TCP ports by eg "127.0.0.1:3307" or you can specify a different socket file in php.ini (see http://php.net/mysql for documentation on PHP's mysql interface)
* Which version of the MySQL client libraries are linked into your application. Generally this doesn't matter, unless your server is 4.1 or higher and your library is 4.0 or lower you may have authentication problems. In this case the installer will show a warning and a URL to MySQL's documentation on this issue.
-- brion vibber (brion @ pobox.com)