====== Manitou-Mail Wiki ======
Welcome to the Wiki for [[http://www.manitou-mail.org|Manitou-Mail]], a database-driven mail user agent.

===== manitou-mdx =====
manitou-mdx is a Perl program that is responsible for importing incoming mail into the database, and exporting outgoing mail to a [[http://en.wikipedia.org/wiki/Mail_transfer_agent|Mail Transfert Agent]]. MDX stands for **M**ail **D**atabase e**X**changer. It generally runs as a daemon (a permanent process in background) although it can also be invoked as a normal command to import existing mailboxes.\\ 
Its functionalities can be vastly extended by user-contributed plugins written in the Perl language.\\ 

The main documentation for manitou-mdx is part of the [[http://www.manitou-mail.org/doc/|Manitou-Mail's manual]].

Additional information is available on this wiki:
  * [[mdx_debian_package|Debian package]] How to create a debian package from scratch for manitou-mdx.
  * [[mdx_filters|Filters]] On the use of server-side mail filters.
  * [[mdx_word_extractors|Word extractors]] External scripts that extract text from attachments for the full-text indexer.

The [[mdx_plugins|Plugins page]] provides documentation and sample plugins.

manitou-mdx can be monitored with [[mdx_nagios_plugin|Nagios]]

===== manitou-spool =====
manitou-spool is a very simple shell maildrop script that copies its standard input into a separate file with a unique name in a spooldir. It is meant to be called by programs such as fetchmail or an stmp server through an entry in the /etc/aliases file.
[[spool_tips|Tips about the spool directory]]


===== Database schema =====
The current version of an installed Manitou-Mail database can be queried in SQL by:
<code sql>
SELECT rt_value FROM runtime_info WHERE rt_key='schema_version'
</code>

A visual representation of the schema can be seen on [[http://www.manitou-mail.org/screenshots/db-diagram.png|this diagram]]  

[[access_rights|Access rights]] Scripts to grant access rights for multi-user installations. For the latest version.

==== Version 1.0.0 and above ====
[[schema_1_0_0_upgrade|Upgrade script]] To upgrade the db schema from 0.9.12

Starting from 1.0, it's also possible to perform a schema upgrade to the latest version by this shell command:
 <code>$ manitou-mgr --upgrade-schema</code>
"Latest" here means the latest known to the manitou-mgr command.



===== User Interface =====
[[nsis_script|NSIS script for Windows]] The script that is used to create Manitou-Installer.exe

[[http://www.manitou-mail.org/showsource.php|Source code]] The C++ source code can be read online (one HTML page per file)

===== SQL tips and queries =====
[[sample_user_queries|Sample user queries (easy)]], with the Quick Selection panel in the user interface \\
[[adv_sample_user_queries_plus|Sample user queries (advanced)]] \\
[[sql_analysis|Queries for analysis]] \\
[[sql_analysis_dedup_attachments|Analyzing the attachments deduplication]] \\
[[inverted_word_index|Querying the full text search index]] \\
[[support_functions|Support functions]] \\
[[sql_basic_stats|Basic statistics]]