Check Config And Indexes Application

Check Config and Indexes application

Description

This XAR allows you to check config as well as check and create indexes in your XWiki Enterprise or XWiki Enterprise Manager.

The CheckConfig page checks:

• Memory settings
• Database pool settings
• Cache settings
• Encoding settings

The CheckIndexes page checks:

• indexes on the main wiki and on child wikis of an XEM instance
• allows to create the indexes directly from the wiki

The CheckDBEncoding page checks:

• the default encoding and collection settings of the MySQL engine
• the default encoding and collection of the 'xwiki' database 
• the encoding and collection of the xwikidoc table
• the encoding and collection of all the databases and xwikidoc tables of a XEM instance

The CheckRights page checks:

• every space, page that has rights against the standard user and one chosen user

TODO:

• add support for xwiki.db.prefix
• add support for xwiki.db

Prerequisites & Installation Instructions

1. Log in the wiki with a user having Administration rights
2. Go to the Administration page and select the Import category
3. Follow the on-screen instructions to upload the downloaded XAR
4. Click on the uploaded XAR and follow the instructions

After importing the XAR visit the pages on Admin.CheckConfig, Admin.CheckIndexes, Admin.CheckDBEncoding. The page Admin.CheckIndexesSQL lists the SQL statements used to create the indexes. 

Release Notes

v1.1

Import in your wiki and visit Admin.CheckConfig or Admin.CheckIndexes or Admin.CheckDBEncoding

v1.2

Import in your wiki and visit Admin.CheckConfig.

This version is compatible with XWiki 2.x and has an install script to complete the installation of the check config scripts.

v1.3

Import in your wiki and visit Admin.CheckConfig.

This version is compatible with XWiki 2.x to XWiki 2.3 (fails on XWiki 2.4) and has an install script to complete the installation of the check config scripts. It supports additional indexes for the activitystream and the recyclebin tables.

v1.4

Import in your wiki and visit Admin.CheckConfig.

This version is compatible with XWiki 2.x and in particular XWiki 2.4 and has an install script to complete the installation of the check config scripts. It supports additional indexes for the activitystream and the recyclebin tables.