Please see notes in RELEASE-NOTES about MySQL 4.1 and try MediaWiki 1.5rc4 as well.

In my.cnf you can use 'old-passwords' in the [mysqld] section.

erick.melgarejo wrote:

I did everything as instructed I changed the passwords to 16 hex set. for users
in question. It is still giving me an error the only ones I have left are these.
I changed the my domain to "my domain" and i changed the passwords to x's but
everything else seems alright, any suggestions?

+-----------------------+----------+-------------------------------------------+

+-----------------------+----------+-------------------------------------------+

+-----------------------+----------+-------------------------------------------+

MediaWiki 1.5rc4 installation

Please include all of the lines below when reporting installation problems.
Checking environment...

• PHP 5.0.4: ok
• PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
• Have XML / Latin1-UTF-8 conversion support.
• PHP's memory_limit is 8M. If this is too low, installation may fail!

Attempting to raise limit to 20M... ok.

• Have zlib support; enabling output compression.
• Neither Turck MMCache nor eAccelerator are installed, can't use object

caching functions

• Found GNU diff3: /usr/bin/diff3.
• Found GD graphics library built-in, image thumbnailing will be enabled if

you enable uploads.

• Installation directory: /var/www/html/mediawiki/wiki
• Script URI path: /mediawiki/wiki
• PHP is linked with old MySQL client libraries. If you are using a MySQL

4.1 server and have problems connecting to the database, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.

• Trying to connect to MySQL on localhost as root... o Connected as root (automatic)
• Connected to 4.1.11-standard; enabling MySQL 4 enhancements; You are using

MySQL 4.1 server, but PHP is linked to old client libraries; if you have trouble
with authentication, see http://dev.mysql.com/doc/mysql/en/old-client.html for help.

erick.melgarejo wrote:

Hello, I havent heard any news on this post, can you please help me on this one?
Thank you

Erick

miranda wrote:

I'm having somewhat-similar problems during installation, too. Like the original poster, I'm running on RedHat Enterprise (Advanced Server; release 4, update 3).

First, here's the output from the install script:

PHP 4.3.9 installed
PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
Have XML / Latin1-UTF-8 conversion support.
PHP's memory_limit is 24M. If this is too low, installation may fail!
Have zlib support; enabling output compression.
Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions
Found GNU diff3: /usr/bin/diff3.
Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
Found GD graphics library built-in.
Installation directory: /webroot/syndetic.org/wiki.syndetic.org/www/mediawiki-1.6.3
Script URI path:
Environment checked. You can install MediaWiki.
Generating configuration file...
Database type: mysql

Attempting to connect to database server as root...failed due to authentication errors. Check passwords.

I verified that the config/ directory is writable by the user that the web server is running as.

I tailed the mysql error log during installation and saw the following message:

060423 16:27:49      89 Connect     Access denied for user 'root'@'localhost' (using password: NO)

I'm able to login to the server just fine from the mysql utility. It's obvious that the installation script
is somehow NOT attempting to perform a password-based login to the database server (since the detailed part of
the mysqld error is "(using password: NO)").

I also tried performing a non-root installation by doing the following:

1.) keeping the 'Superuser account' field as 'root'
2.) keeping the 'Superuser password' field as '-' (hyphen)
3.) Correctly populating the 'DB username', 'DB password' and 'DB password confirm' fields
4.) Correctly granting USAGE and "SELECT,INSERT,UPDATE,DELETE" rights to the MySQL user whose
     authentication information was placed into the aforementioned form fields.
5.) Flushing the MySQL privileges (FLUSH PRIVILEGES)

However, what happens is this:

It still attempts to login to the database server as 'root' (still not using a password), even though
the non-root-user form fields have red error messages next to them indicating that the authentication
information was incorrect.  So at least the installation script notices that it should be using the non-root
account instead of the root account in this case.

I even went so far as to hardcode the proper root-user authentication information into the Database.php script.
(I overrode the auth info in numerous places, including the mysql_connect(...) function.)
However, none of that worked, either. So there's SOMETHING erroneous going on on a low level.

/usr/lib/php4/mysql.so IS linked correctly to my MySQL client library (/usr/lib/mysql/libmysqlclient.so.14 in my case),
and the mysql command-line utility that I used to successfully connect to the database server is also linked to the
same mysql client library.

Any ideas? This is my first try at installing MediaWiki, and things aren't looking too good thus far.
Is there a command-line version of the installation script that I can try? Also, is there a debug CGI parameter
or a debug variable in one of the scripts that I can turn on in order to get a better idea of what's going on?

Regards,
Michael

miranda wrote:

This is just a reply to my own comment to say that I've resolved my problem.

I found that setting 'sql.safe_mode' inside /etc/php.ini to the value of 'Off' allowed
the installation script to succeed as expected. I'm not sure what the property 'safe_mode'
entails or what effect it has on a low level; but, by disabling it, the installer script
was finally able to perform an authenticated connection to the database server.
Note that 'safe_mode', which is inside the '[SQL]' section, is enabled by default
under RHEL 4 (I'm not sure about previous versions).

I'm leaving the status the same (REOPENED) since I can't tell if the original poster's problem
has been resolved or not.

I hope this quick fix helps other people who have the same problem (I'm actually surprised to
not see any other bugs like this).

Regards,
Michael

robchur wrote:

To the original poster:

This is a common problem; start with the URL provided in the error message which
should explain it in more detail and provide advice and instructions on
workarounds and a real solution.

Consider also searching the mailing list archives; this was discussed on
mediawiki-l around October/November, IIRC. Googling for "MediaWiki MySQL
authentication problem" or similar might also help.