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.

To install, import it in your wiki and visit the pages on Admin.CheckConfig, Admin.CheckIndexes, Admin.CheckDBEncoding. The page Admin.CheckIndexesSQL lists the SQL statements used to create the indexes. 

• Version 1.4 of Check Config has been tested on XE 2.1-XE 2.4 and has additional indexes and the CheckRights page
• Version 1.3 of Check Config has been tested on XE 2.3 and has additional indexes (fails on 2.4)
• Version 1.2 of Check Config has been tested on XE 2.1.1
• Version 1.1 has been tested on XE 1.8.4 and on XEM based (with core XE 2.0M1).

NOTE: V1.4 and older versions can create indexed only when the database is named 'xwiki'.

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