Mailing List Archive

MediaWiki installation fails communicating to DB even though user has been created with all privileges.
Dear All,


I've just been trying to install MediaWiki on a Windows XP (SP2) box for
development purposes. Eventually the wiki will be hosted on a Linux
box. My basic configuration is Apache 2.0.50, PHP 4.3.8, and MySQL 4.1
beta (needed for another project). After supplying all the
configuration parameters I get the following output:

MediaWiki 1.3.2 installation

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

* PHP 4.3.8: 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.
* Have zlib support; enabling output compression.
* Found GD graphics library built-in, image thumbnailing will be
enabled if you enable uploads.
* Installation directory: C:\\Apache\\Apache2\\htdocs\\cvc
* Script URI path: /cvc
* Warning: $wgProxyKey is insecure Connected as root (automatic)
* Connected to database... 4.1.3-beta-nt; enabling MySQL 4
enhancementsWarning: $wgProxyKey is insecure
* Database wikidb exists
* Creating tables... done.
* Initializing data...
* Granting user permissions...
Sorry! The wiki is experiencing some technical difficulties, and
cannot contact the database server.

I have tried this using the automated AND manual DB / user creation. I
have created the mysql user as follows:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'wikiuser'@'localhost' IDENTIFIED
BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'wikiuser'@'holly' IDENTIFIED BY
'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

...so I would have thought the user should have all the database
privileges it needs. Does anybody have any idea why I can't get the
installation to work properly? I've searched the web but to no avail:
lots of people reporting this error message in slightly different
circumstances, but mostly nobody has been able to provide any assistance.

I'd be really grateful if anybody does know why this is happening
because I simply can't make any progress with my project until it is fixed.


Many thanks,
Bart Read
Re: MediaWiki installation fails communicating to DB even though user has been created with all privileges. [ In reply to ]
Bart Read wrote:
> I've just been trying to install MediaWiki on a Windows XP (SP2) box for
> development purposes. Eventually the wiki will be hosted on a Linux
> box. My basic configuration is Apache 2.0.50, PHP 4.3.8, and MySQL 4.1
> beta (needed for another project).

Can you confirm that you have the same problem with a non-beta version
of MySQL (eg 4.0.20)?

-- brion vibber (brion @ pobox.com)
Re: MediaWiki installation fails communicating to DB even though user has been created with all privileges. [ In reply to ]
Hi Brion,


Just resurrected an old Win2K box with MySQL 4.0 (not sure which
subversion) and PHP 4.3.4... and guess what? It works fine. NOW we're
cooking.


Many thanks,
Bart



Brion Vibber wrote:

> Bart Read wrote:
>
>> I've just been trying to install MediaWiki on a Windows XP (SP2) box
>> for development purposes. Eventually the wiki will be hosted on a
>> Linux box. My basic configuration is Apache 2.0.50, PHP 4.3.8, and
>> MySQL 4.1 beta (needed for another project).
>
>
> Can you confirm that you have the same problem with a non-beta version
> of MySQL (eg 4.0.20)?
>
> -- brion vibber (brion @ pobox.com)
>
>------------------------------------------------------------------------
>
>_______________________________________________
>MediaWiki-l mailing list
>MediaWiki-l@Wikimedia.org
>http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>