http://www.manitou-mail.org/wiki/ 2010-09-07T06:47:12+02:00 http://www.manitou-mail.org/wiki/ http://www.manitou-mail.org/wiki/lib/images/favicon.ico text/html 2010-08-22T01:45:42+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/sql_analysis?rev=1282434342&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 2010-08-20T10:22:15+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/start?rev=1282292535&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 2010-07-23T19:56:01+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/mdx_debian_package?rev=1279907761&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 2010-07-20T22:12:15+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/schema_1_0_0_grants?rev=1279656735&do=diff Access rights management is left to the administrator by way of self-written SQL commands, as is the creation of database users. This page gives some basic guidelines on how to manage a database with multiple users in a typical scenario: * One dedicated database user is the owner of the database and all its objects. This is the user that runs the initial creation script. * One or several roles (=groups) are created with CREATE ROLE commands. * Access rights are assigned to each role for … text/html 2010-07-20T21:37:32+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/schema_1_0_0_upgrade?rev=1279654652&do=diff Below is the SQL script for PostgreSQL that upgrades the schema from 0.9.12 to 1.0.0 -- This SQL script upgrades the database schema for manitou-mail -- from 0.9.12 to 1.0.0 version \set ON_ERROR_STOP 1 BEGIN; ALTER TABLE body DROP COLUMN textsize; ALTER TABLE body ADD bodyhtml TEXT; ALTER TABLE header DROP COLUMN header_size; ALTER TABLE mail DROP COLUMN msg_day; ALTER TABLE mail RENAME attachments TO flags; UPDATE mail SET flags=1 WHERE flags!=0; UPDATE mail SET flags=flags|2 WHERE mail… text/html 2009-09-07T21:01:17+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/nsis_script?rev=1252350077&do=diff NSIS (<http://nsis.sourceforge.net>) is used to create the install program for the Windows version of the Manitou-Mail user interface. It assumes the existence of a c:\manitou\nsis-installer directory, and that this directory contains manitou.exe, the Qt DLLs, and help/ xpm/ translations/ sub-directories, as well as assistant_adp.exe, which is the program for the Qt help system. text/html 2009-08-15T15:06:28+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/plugins:html_indexer?rev=1250341588&do=diff Purpose This is an incoming_mimeprocess plugin that recursively searches for HTML parts in the message, convert them to a text format, and pass them to the full text indexer. Dependencies Requires * manitou-mdx 0.9.11 or above * CPAN HTML::FormatText module text/html 2009-08-15T14:49:21+02:00 Daniel Vérité http://www.manitou-mail.org/wiki/doku.php/mdx_plugins?rev=1250340561&do=diff Plugins overview Plugins reference documentation spamc - Calls spamassassin to score messages and tag them spam or not. html_indexer - Extracts the text from HTML parts and pass it to the full text indexer to allow subsequent searches inside HTML-only contents.