Topic on Project:Support desk

138.106.53.101 (talkcontribs)

info about installation

uname -a

Linux myserver 4.18.0-425.10.1.el8_7.x86_64 #1 SMP Wed Dec 14 16:00:01 EST 2022 x86_64 x86_64 x86_64 GNU/Linux


mediawiki-1.39.3.tar.gz


mysql --version

mysql  Ver 8.0.30 for Linux on x86_64 (Source distribution)


mysql> show engines;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |

| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |

| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |

| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |

| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |

| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |

| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+


This is the error message that i got.

The environment has been checked. You can install MediaWiki.

Setting up database

done

Creating tables, step one

Wikimedia\Rdbms\DBQueryError from line 1618 of /var/www/html/iwswiki/includes/libs/rdbms/database/Database.php: Error 3161: Storage engine MyISAM is disabled (Table creation is disallowed).

Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/iwswiki/maintenance/tables-generated.sql )

Query: CREATE TABLE `searchindex` (

si_page INT UNSIGNED NOT NULL,

si_title VARCHAR(255) DEFAULT '' NOT NULL,

si_text MEDIUMTEXT NOT NULL,

UNIQUE INDEX si_page (si_page),

FULLTEXT INDEX si_title (si_title),

FULLTEXT INDEX si_text (si_text)

) ENGINE = MyISAM DEFAULT CHARSET = utf8

139.122.191.225 (talkcontribs)

isnt this database version supported?

139.122.191.225 (talkcontribs)

I changed to innodb in tables-generated.sql and it looks ok but idont know if this breaks anything

CREATE TABLE /*_*/searchindex (

  si_page INT UNSIGNED NOT NULL,

  si_title VARCHAR(255) DEFAULT '' NOT NULL,

  si_text MEDIUMTEXT NOT NULL,

  UNIQUE INDEX si_page (si_page),

  FULLTEXT INDEX si_title (si_title),

  FULLTEXT INDEX si_text (si_text)

) ENGINE = innodb DEFAULT CHARSET = utf8;

Bawolff (talkcontribs)

It should be fine. It is myisam by default for that table because old versions of mysql did not support fulltext indexes on innodb tables, and nobody ever changed mediawiki after support was added to mysql.

Reply to "Cant install db"