Sarcastic tone on -> Thanks for the help!
Since I figured it out...I'll share.
In this case the problem was the fact that I was using PHP4.x.x and mysql4.1.10. There is a basic incompatability between the two in terms of password authentication. I upgraded to PHP5 and everything worked. The mysql client within php4 used an older method of encryption(?). The capability to use older style sql passwords exists via an "old_password" function, but that defeats the improved security.
-----Original Message----- From: mediawiki-l-bounces@wikimedia.org [mailto:mediawiki-l- bounces@wikimedia.org] On Behalf Of Terry Lalonde Sent: Tuesday, March 01, 2005 1:09 PM To: mediawiki-l@wikimedia.org Subject: [Mediawiki-l] installation problem: ... cannot contact the databaseserver
My log page is attached below...The error message does not help me, maybe someone have seen it before.
Any help is appreciated.
Terry
MediaWiki 1.3.11 installation
Please include all of the lines below when reporting installation problems.
Checking environment...
- PHP 4.3.10RC1: ok
- PHP server API is apache2handler; ok, using pretty URLs
(index.php/Page_Title)
- Have XML / Latin1-UTF-8 conversion support.
- PHP is configured with no memory_limit.
- No zlib support.
- Couldn't find GD library or ImageMagick; image thumbnailing
disabled.
- Installation directory: /cad/local/Linux/apache2/htdocs/wiki
- Script URI path: /wiki
- Connected as root (automatic)
- Connected to database... 4.1.10; enabling MySQL 4 enhancements
- Database wikidb exists
- There are already MediaWiki tables in this database. Checking if
updates are needed...
...ipblocks is up to date. ...already have interwiki table ...indexes seem up to 20031107 standards ...have linkscc table. ...linkscc is up to date, or does not exist. Good. ...have hitcounter table. Converting links table to ID-ID... Sorry! The wiki is experiencing some technical difficulties, and
cannot
contact the database server.
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Terry Lalonde wrote:
Sarcastic tone on -> Thanks for the help!
Congratulations on solving your problem on your own; less than 10 hours elapsed between your first post and your follow-up.
Since I figured it out...I'll share.
In this case the problem was the fact that I was using PHP4.x.x and mysql4.1.10. There is a basic incompatability between the two in terms of password authentication.
If you were to search the mailing list archives for "MySQL 4.1" you'd see a number of previous notes on this with pointers to the help pages on dev.mysql.com. This is also mentioned in the release notes for all 1.4 beta releases.
Note that there is not actually a basic incompatibility between PHP 4.x and MySQL 4.1; PHP 4.x will work fine with MySQL 4.1 if you link it against the MySQL 4.1 client libraries. Most precompiled binary distributions however are linked against older, incompatible libraries. If you received both PHP and MySQL distributions from the same vendor, you should let them know they're shipping incompatible versions.
If you're using MySQL 4.1, you should also be aware that mysqldump may corrupt your data if it performs character set conversion. Use the same charset setting for dumping as the database is set to (eg, latin1 for both).
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org