http://www.manitou-mail.org/wiki/ 2012-02-05T22:52:36+01:00 http://www.manitou-mail.org/wiki/ http://www.manitou-mail.org/wiki/lib/tpl/default/images/favicon.ico text/html 2012-01-28T03:55:58+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/sql_analysis?rev=1327719358&do=diff This query extracts, for each of the header fields from a fixed list, the number of occurrences of all distinct values of the field. SELECT split_part(substr(lines, 1+position(E'\n'||field in lines), 200), E'\n', 1) as ct, count(*) FROM header, (values ('X-Priority'), ('Importance'), ('Precedence'), ('Priority'), ('X-MSMail-Priority'), ('X-MS-Priority')) as h(field) WHERE position(E'\n'||field IN lines)>0 group by split_part(substr(lines, 1+position(E'\n'||field in lines), 200), E'\n', 1) text/html 2012-01-28T03:28:12+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/mdx_filters?rev=1327717692&do=diff Filters are normally edited in the user interface, in the window that appears when the File->Filters command is run. Once defined, they are applied server-side by manitou-mdx to messages that enter the database. A filter is defined to apply to incoming or outgoing mail or both. Applying a filter consists of evaluating its condition, and if the result is true, doing the actions that are associated to it. If a filter has no action, it can be considered inactive. A condition is basically an expr… text/html 2012-01-26T02:41:13+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/mdx_plugins?rev=1327542073&do=diff The functionalities of manitou-mdx can be extended by writing Perl modules that are hooked to manitou-mdx as plugins. A plugin module may be a self-contained piece of code, but more often it's used as an interface to an external program, such as a spam filter or a converter that extracts text from a complex file format. Also, plugins may use external Perl modules from the CPAN archive or other sources. text/html 2011-11-26T03:15:42+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/start?rev=1322273742&do=diff Welcome to the Wiki for 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 Mail Transfert Agent. MDX stands for Mail Database eXchanger. It is supposed to run as a daemon (always running 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 wr… text/html 2011-07-18T14:32:27+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/mdx_debian_package?rev=1310992347&do=diff We start from a fresh source tree for manitou-mdx, as obtained by un-tarring a manitou-mdx-<version>.tar.gz source archive. We'll use 0.9.11 as an example. The commands we need to create the package are available through the dpkg-dev (or fakeroot) and dh-make packages. text/html 2011-06-23T14:41:56+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/mdx_nagios_plugin?rev=1308832916&do=diff Nagios is a popular monitoring program that has plugins for a large number of programs and services. To integrate manitou-mdx monitoring inside Nagios, this Nagios plugin can be used: check_manitou. text/html 2011-04-09T22:49:27+01:00 daniel http://www.manitou-mail.org/wiki/doku.php/inverted_word_index?rev=1302382167&do=diff Context See also Implementation of the inverted word index for how the word index is stored in the database, and the definition of tables: * words * non_indexable_words * inverted_word_index Function The word index can be queried in SQL. Here is the code of a PL/pgSQL function that retrieves the IDs of messages containing a set of words. The words are given as an array of text. The function is already in the Manitou-Mail database for versions 1.1.0 and above