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
1) 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.
2) Can i run any commands to see if multiple versions
are installed?
Try the brute force approach! ;)
$ locate mysql
3) 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)