Mailing List Archive

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