[Wikide-l] MediaWiki soll umziehen, mysql nicht

Michael Renner michael.renner at gmx.de
Mo Aug 9 09:15:51 UTC 2010


Moin,

ich bin auf der Suche nach dem perfekten Vorgehen: Derzeit läuft sowohl
der Apsche mit php als auch mysql unter Solaris. Nun soll das wiki selbst
auf Linux (RHEL) umziehen, die Datenbank aber unter Solaris bleiben.

Die rpm-Pakete waren schnell installiert, /wiki/config/index.php
aufgerufen und ausgefüllt, doch dann:



    * PHP 5.1.6 installed
    * Found database drivers for: MySQL PostgreSQL SQLite
    * PHP server API is apache2handler; ok, using pretty URLs
(index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * Session save path (/var/lib/php/session) appears to be valid.
    * PHP's memory_limit is 128M.
    * Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use
these for object caching.
    * 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: /var/www/wiki
    * Script URI path: /wiki
    * Installing MediaWiki with php file extensions
    * Environment checked. You can install MediaWiki.
    *

      Generating configuration file...
    * Database type: MySQL
    * Loading class: DatabaseMysql
    * Attempting to connect to database server as wikiuser...success.
    * Connected to mysql 4.0.15-log; MySQL 4.1/5.0 charset mode enabled,
but older version detected; will likely fail.
    * Database wikidb exists
    * Creating tables...Query "CREATE TABLE `user` ( user_id int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT, user_name varchar(255) binary NOT NULL
default '', user_real_name varchar(255) binary NOT NULL default '',
user_password tinyblob NOT NULL, user_newpassword tinyblob NOT NULL,
user_newpass_time binary(14), user_email tinytext NOT NULL, user_options
blob NOT NULL, user_touched binary(14) NOT NULL default '', user_token
binary(32) NOT NULL default '', user_email_authenticated binary(14),
user_email_token binary(32), user_email_token_expires binary(14),
user_registration binary(14), user_editcount int ) ENGINE=InnoDB, DEFAULT
CHARSET=binary " failed with error code "You have an error in your SQL
syntax. Check the manual that corresponds to your MySQL server version for
the right syntax to use near 'ENGINE=InnoDB, DEFAULT CHARSET=binary' at
line 17 (wiki.example.org)".

Was nun?

Danke
-- 
|Michael Renner      E-mail: michael.renner at gmx.de  |
|D-81541 Munich      Germany        ICQ: #112280325 |
|Germany             Don't drink as root!      ESC:wq