I'm installing MediaWiki for the first time onto a clean system. I had a number of problems getting the install script to work. It mainly boils down to a MySQL connect problem. I get the following error when ever the DB user is not "root" with an empty password.
Sorry! The wiki is experiencing some technical difficulties, and cannot contact the database server. Client does not support authentication protocol requested by server; consider upgrading MySQL client
My workaround: edit "includes/Database.php" and force the connect to always use root. For example at line 106 I did the following:
# @$this->mConn = mysql_connect( $server, $user, $password ); @$this->mConn = mysql_connect( $server, "root", "" );
The install works with the DB being created and the "wikiadmin" user is created. I moved the LocalSettings.php file from wiki/config/ to wiki/ and removed the blank line at the beginning of the file (because that was causing problems). The Main_Page comes up, and everything seems to be working fine.
But if I change the root password for mysql, and in the Database.php file, I get the connect error. (Connecting with the mysql client works fine with the password change.) If I change the code in Database.php back to the original code, I get the same connect error.
Any help with getting this configured, so that I can secure MySQL with passwords, would be much appreciated.
Best regards,
_BruceR
Version details ---------------
Linux: Fedora Core release 2 (Tettnang) (Last updated: 08/18/04 10:29) uname -a: Linux xxx.xxx.xxx 2.6.7-1.494.2.2 #1 Tue Aug 3 09:39:58 EDT 2004 i686 athlon i386 GNU/Linux
Packages: httpd-2.0.50-2.1
php-4.3.8-2.1 php-ldap-4.3.8-2.1 php-mbstring-4.3.8-2.1 php-mysql-4.3.8-2.1 php-pear-4.3.8-2.1 php-xmlrpc-4.3.8-2.1 php-domxml-4.3.8-2.1
MySQL-shared-compat-4.1.3-0 MySQL-devel-4.1.3-0 MySQL-Max-4.1.3-0 MySQL-client-4.1.3-0 MySQL-embedded-4.1.3-0 MySQL-server-4.1.3-0 MySQL-bench-4.1.3-0 MySQL-debuginfo-4.1.3-0
mediawiki-1.3.1.tar.gz
I manually installed MySQL-shared-compat, after making symlinks to the libs that it wanted. (Then I used yum to install the php and MySQL packages.) ln -s /lib/libssl.so.0.9.7a /lib/libssl.so.0.9.6 ln -s /lib/libcrypto.so.0.9.7a /lib/libcrypto.so.0.9.6
The MySQL rpms were recompiled from MySQL-4.1.3-0.src.rpm on the same HW/OS (rpmbuild --rebuild MySQL-4.1.3-0.src.rpm), but MySQL-shared-compat was downloaded from rpmfind.net (it references the same src.rpm file).