Last modified: 2010-05-15 15:56:54 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'".
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.
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.
Hello, I havent heard any news on this post, can you please help me on this one? Thank you Erick
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
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
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.