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

We recommend using the Extension Manager to install this extension (Make sure that the text "Installable with the Extension Manager" is displayed at the top right location on this page to know if this extension can be installed with the Extension Manager). Note that installing Extensions when being offline is currently not supported and you'd need to use some complex manual method.

You can also use the following manual method, which is useful if this extension cannot be installed with the Extension Manager or if you're using an old version of XWiki that doesn't have the Extension Manager:

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
5. You'll also need to install all dependent Extensions that are not already installed in your wiki

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.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.

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.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.1

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