https://manitou-mail.org/wiki/ 2026-04-29T00:31:59+00:00 https://manitou-mail.org/wiki/ https://manitou-mail.org/wiki/lib/exe/fetch.php/wiki:dokuwiki-128.png text/html 2015-05-19T15:27:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/access_rights?rev=1432049225&do=diff Schema access rights 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: text/html 2021-05-15T12:21:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/adv_sample_user_queries_plus?rev=1621081317&do=diff Advanced examples of SQL queries Messages sent, with senders or recipients from a specific domain, but not tagged with a specified tag: SELECT m.mail_id FROM mail m JOIN mail_addresses ma ON (ma.mail_id=m.mail_id) JOIN addresses USING(addr_id) WHERE status&256<>0 AND email_addr like '%@example.org' AND not exists (select 1 from mail_tags mt JOIN (select tag_id FROM tags WHERE name='Sample Tag') t ON (t.tag_id=mt.tag) WHERE mt.mail_id=m.mail_id) ; text/html 2016-05-16T12:27:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/inverted_word_index?rev=1463401652&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 text/html 2011-07-18T12:32:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/mdx_debian_package?rev=1310992347&do=diff How to create a debian package for manitou-mdx 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 text/html 2012-01-28T02:28:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/mdx_filters?rev=1327717692&do=diff Overview 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 text/html 2011-08-06T22:52:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/mdx_nagios_plugin?rev=1312671136&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 2012-01-26T01:41:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/mdx_plugins?rev=1327542073&do=diff What are plugins? 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 2012-10-09T19:12:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/mdx_word_extractors?rev=1349809943&do=diff Word extractors are external commands that are launched by manitou-mdx with attachments contents piped to their standard input. They extract words and output them encoded in utf-8 to the standard output. manitou-mdx associates these words in the inverted word index to the message being processed. text/html 2009-09-07T19:01:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://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 2014-08-04T11:23:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/sample_user_queries?rev=1407151421&do=diff Sample SQL queries See the database schema documentation for definitions of tables and columns. Messages with a private note attached 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 with a private note which has been added or modified during the last 7 days text/html 2008-11-02T22:30:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_10?rev=1225665033&do=diff Schema creation script Below is the SQL script for PostgreSQL that creates from scratch all the database objects. Before running it through psql, those preconditions should be met: * The database should exist and have UTF8 encoding (createdb -E UTF8 name_of_database text/html 2008-11-09T01:19:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_10_functions?rev=1226193542&do=diff Non-trigger Functions These functions are called by the UI or manitou-mdx trash_msg CREATE OR REPLACE FUNCTION trash_msg(in_mail_id integer, in_op integer) RETURNS integer AS $$ DECLARE new_status int; BEGIN UPDATE mail SET status=status|16,operator=in_op WHERE mail_id=in_mail_id; SELECT INTO new_status status FROM mail WHERE mail_id=in_mail_id; RETURN new_status; END; $$ LANGUAGE 'plpgsql'; text/html 2008-11-08T18:02:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_10_grants?rev=1226167367&do=diff Schema access rights 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: text/html 2008-11-02T22:12:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_10_upgrade?rev=1225663951&do=diff Below is the SQL script for PostgreSQL that upgrades the schema from 0.9.9 to 0.9.10. The changes fall mostly in two categories: * removing the trashed_mail table, the trashcan being merged into the mail table * setting referential integrity constraints text/html 2008-11-04T12:27:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_10_upgrade_notes?rev=1225801643&do=diff Referential integrity constraints Before 0.9.10, there were no referential integrity constraints in the schema. The reason was mainly that most RI constraints refer to a message and messages were split between the mail and trashed_mail tables (as opposed to one table only), thus making simple RI constraints impractical. In 0.9.10, those tables are unified so RI constraints are enabled. text/html 2009-06-13T20:45:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_11?rev=1244925906&do=diff Schema creation script Below is the SQL script for PostgreSQL that creates from scratch all the database objects. Before running it through psql, the database should exist and have UTF8 encoding (createdb -E UTF8 name_of_database in shell or CREATE DATABASE name_of_database ENCODING 'UTF8 text/html 2009-06-13T20:57:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_11_grants?rev=1244926677&do=diff Schema access rights 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: text/html 2009-08-08T11:43:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_11_upgrade?rev=1249731811&do=diff Below is the SQL script for PostgreSQL that upgrades the schema from 0.9.10 to 0.9.11. This script as well as all the SQL files are available in <http://www.manitou-mail.org/source/manitou-sql-0.9.11.tar.gz> -- This SQL script upgrades the database schema for manitou-mail -- from 0.9.10 to 0.9.11 version \set ON_ERROR_STOP 1 BEGIN; CREATE TABLE filter_log ( expr_id int, -- No reference to filter_expr, we don't want any constraint here mail_id int, -- No reference to mail to be able t… text/html 2009-08-08T11:44:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_0_9_13_upgrade?rev=1249731887&do=diff Below is the SQL script for PostgreSQL that upgrades the schema from 0.9.12 to 0.9.13. This script as well as all the SQL files are available in <http://www.manitou-mail.org/source/manitou-sql-0.9.13.tar.gz> -- This SQL script upgrades the database schema for manitou-mail -- from 0.9.12 to 0.9.13 version \set ON_ERROR_STOP 1 BEGIN; ALTER TABLE body DROP COLUMN textsize; ALTER TABLE body ADD bodyhtml TEXT; UPDATE runtime_info SET rt_value='0.9.13' WHERE rt_key='schema_version'; END; text/html 2010-07-20T20:12:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/schema_1_0_0_grants?rev=1279656735&do=diff Schema access rights 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: text/html 2010-07-20T19:37:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://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 2011-01-27T18:37:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/spool_tips?rev=1296153435&do=diff Format of filenames manitou-spool uses the result of: date "+%Y%m%d-%H%M%S"`"-$$ as the variable part for mail filenames. $$ denotes the Unix pid and has the property of being unique at any particular time. It is used in this case to avoid name clashes for files created within the same second. The full name is text/html 2019-01-24T17:55:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/sql_analysis?rev=1548352547&do=diff Presence and count of specific mail headers 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 1 text/html 2018-09-09T17:53:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/sql_analysis_dedup_attachments?rev=1536515595&do=diff Attachments deduplication Attachments are stored into 3 tables: attachments, attachment_contents and the pg_largeobject system table. At import time, the SHA1 fingerprint of attachments are computed and compared to contents already in the database. When a match is found, a new reference is created in attachment_contents to the already existing OID (large object reference) instead of importing again the same contents. text/html 2015-11-18T04:58:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/sql_basic_stats?rev=1447822711&do=diff Number of messages for a given month (including days with no message). Example for July, 2015 SELECT day::date, coalesce(cnt,0) as cnt FROM (select date_trunc('day',msg_date) as day, count(*) as cnt from mail where msg_date>='2015-07-01'::timestamptz and msg_date<'2015-07-01'::timestamptz+interval '1 month' -- and other optional conditions group by 1 ) as list RIGHT JOIN generate_series('2015-07-01'::timestamptz, '2015-07-01'::timestamptz+interval '1 mo… text/html 2017-10-18T14:56:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/start?rev=1508338577&do=diff Manitou-Mail Wiki 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 e text/html 2013-01-10T20:47:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/start_doku.php?rev=1357850821&do=diff In this current economy, the job market is quite difficult. It could be definitely tough to locate work, especially if you’re fresh new out of school. This is why several people turn to the web to locate employment. There are lots of opportunities to be found on the web. An example of this kind of opportunity is the internet site getweeklypaychecks.com. This site provides you the opportunity to become an independent referral agent with a earnings ranging from 500 to 2000 dollars a month. You … text/html 2018-04-20T11:17:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://manitou-mail.org/wiki/doku.php/support_functions?rev=1524223049&do=diff tag_path(int) Extract the tag name with its hierarchy. 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;…