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).
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).