Hello I,ve installed Mediawiki 1.2.3 on a Linux Debian 3.1 When i try to ugrade to Version 1.3.1 everything ist going fine until the Webinstaller creates the following messages.
MediaWiki 1.3.1 installation /Please include all of the lines below when reporting installation problems./ Checking environment...
* PHP 4.3.4: ok * PHP server API is apache; 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. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /opt/mediawiki/mediawiki-1.3.1 * Script URI path: * Connected as root (automatic) * Connected to database... 4.0.18-log; 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... Loading IDs from cur table... Finished loading IDs.
Dropping temporary links table if it exists...A database error has occurred Query: DROP TABLE IF EXISTS links_temp Function: -2 Error: 1142 drop Kommando abgelehnt f�r User: 'wikiuser@localhost' f�r Tabelle 'links_temp'
Backtrace: Database.php line 196, in wfdebugdiebacktrace() convertLinks.inc line 170, in database::query() convertLinks.inc line 81, in createtemptable() index.php line 474, in convertlinks()
Does anybody know a solution for this problem?
-- Regards Markus Gillich
Markus Gillich wrote:
Dropping temporary links table if it exists...A database error has occurred Query: DROP TABLE IF EXISTS links_temp Function: -2 Error: 1142 drop Kommando abgelehnt f�r User: 'wikiuser@localhost' f�r Tabelle 'links_temp'
Can you confirm that you gave it the correct database username and password? How did you set up your 1.2 installation -- using the old manual install or the web installer? Did you create the MySQL user account manually or let the installer do it? Can you check that the user has sufficient permissions to make the database alterations?
I haven't had any trouble upgrading 1.2.x test wikis to 1.3 when using the web installer for both.
-- brion vibber (brion @ pobox.com)
Brion Vibber schrieb:
Markus Gillich wrote:
Dropping temporary links table if it exists...A database error has occurred Query: DROP TABLE IF EXISTS links_temp Function: -2 Error: 1142 drop Kommando abgelehnt f�r User: 'wikiuser@localhost' f�r Tabelle 'links_temp'Can you confirm that you gave it the correct database username and password? How did you set up your 1.2 installation -- using the old manual install or the web installer? Did you create the MySQL user account manually or let the installer do it? Can you check that the user has sufficient permissions to make the database alterations?
I haven't had any trouble upgrading 1.2.x test wikis to 1.3 when using the web installer for both.
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-the user and the password are correct -the 1.2.3 installation was done with the scipt install.php, not with the web installer -the mysql user account was created by the install script -the permissins for the user 'wikiuser' for 'wikidb' are SELECT, INSERT, UPDATE, DELETE, other permissions are missing
I set the permissions for 'wikiuser' manually to 'all privileges' (includes DROP, GRANT , LOCK, CREATE TEMPOARY ...) an now the upgrade installation is working fine. Mediawiki 1.3.1 is now running my old, but converted database. Does this create security problems ?
Maybe the install.php script created the wikiuser with to few permissions ?
Greetings
Markus Gillich
mediawiki-l@lists.wikimedia.org