http://www.manitou-mail.org/wiki/ 2012-05-19T09:13:57+02:00 http://www.manitou-mail.org/wiki/ http://www.manitou-mail.org/wiki/lib/tpl/default/images/favicon.ico text/html 2012-02-27T21:52:51+02:00 daniel http://www.manitou-mail.org/wiki/doku.php/support_functions?rev=1330375971&do=diff This recursive function takes the ID of a tag and returns its full name, including its hierarchy. CREATE OR REPLACE FUNCTION tag_path(in_tag_id INTEGER) RETURNS text AS $$ DECLARE r text; id INTEGER; BEGIN IF in_tag_id IS NULL THEN RETURN null; END IF; SELECT name, parent_id INTO r,id FROM tags WHERE tag_id=in_tag_id; IF (id IS NULL) THEN RETURN r; ELSE RETURN tag_path(id)||'->'||coalesce(r,''); END IF; END; $$ LANGUAGE plpgsql STABLE; text/html 2012-02-22T16:23:44+02:00 daniel http://www.manitou-mail.org/wiki/doku.php/start?rev=1329924224&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 2012-02-17T23:12:19+02:00 daniel http://www.manitou-mail.org/wiki/doku.php/sample_user_queries?rev=1329516739&do=diff Sample SQL queries Messages that have a private note attached to them: SELECT mail_id FROM notes The last 20 messages that have a private note: SELECT mail_id FROM notes ORDER BY mail_id DESC LIMIT 20 Messages that have a private note which has been added or modified during the last 7 days: text/html 2012-01-28T03:55:58+02: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+02: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+02: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-07-18T14:32:27+02: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+02: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.