Last modified: 2010-05-15 15:56:54 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 3308 - MediaWiki Installation Problem
MediaWiki Installation Problem
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.6.x
PC Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-08-30 17:35 UTC by y030790!
Modified: 2010-05-15 15:56 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description y030790! 2005-08-30 17:35:35 UTC
I keep on getting an error when trying to install Mediawiki. I have these
current versions:

MySQL-server-4.1.11-0
MySQL-shared-compat-4.1.11-0
php-mysql-5.0.4-9_RS
libdbi-dbd-mysql-0.6.5-5
MySQL-devel-4.1.11-0
MySQL-client-4.1.11-0

I also have PHP 5.0.4 and RedHat Enterprise Edition. I have pasted the error
below, I have test the connection between the server and the database, I can
login through the shell, for root@localhost. Please help, thank you.

MediaWiki 1.4.9 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.
    * Turck MMCache not installed, can't use object caching functions
    * 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
    * Connected as root (automatic)
    * Connected to database... 4.1.11-standard; enabling MySQL 4 enhancements
    * Database wikidb exists
    * There are already MediaWiki tables in this database. Checking if updates
are needed...
    * Granting user permissions...
      Query "GRANT ALL ON `wikidb`.* TO root@'%' IDENTIFIED BY 'cleanp1g'"
failed with error code "Access denied for user 'root'@'localhost' to database
'wikidb'".
Comment 1 Brion Vibber 2005-08-30 22:20:21 UTC
Please see notes in RELEASE-NOTES about MySQL 4.1 and try MediaWiki 1.5rc4 as well.
Comment 2 Antoine "hashar" Musso (WMF) 2005-08-31 12:04:03 UTC
In my.cnf you can use 'old-passwords' in the [mysqld] section.
Comment 3 y030790! 2005-08-31 14:15:01 UTC
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?

+-----------------------+----------+-------------------------------------------+
| Host                  | User     | Password                                  |
+-----------------------+----------+-------------------------------------------+
| server."mydomain".com |          | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| localhost             |          | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| %                     | mcordero | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| %                     | erick    | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| localhost             | cohana   | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| %                     | nurquiza | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
+-----------------------+----------+-------------------------------------------+


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.
Comment 4 y030790! 2005-09-02 13:37:49 UTC
Hello, I havent heard any news on this post, can you please help me on this one?
Thank you


Erick
Comment 5 Michael Chang 2006-04-23 21:06:56 UTC
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
Comment 6 Michael Chang 2006-04-25 17:28:47 UTC
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
Comment 7 Rob Church 2006-04-26 10:16:26 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links