User Tools

Site Tools


start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start [2012/10/25 00:53]
leland791 created
start [2017/10/18 16:56] (current)
daniel [Database schema]
Line 1: Line 1:
-cover a wide range of properties in the very popular Town of OakvilleNorth with the QEW in  Oakville lies Joshua Creek, River Oaks, College Park, Falgarwood, West Oak Trails and Bronte CreekThese locations are home to Oakville real estate listings that range from condostownhouses and big detached housesA lot of of those communities are so well-known that unless you've got an [[http://www.debracurran.ca/|Oakville Real Estate ​Agent ]]working ​for you, it is very likely you will miss out on one of these properties, or uncover your self in competitionTo the south, you've got Morrison, Olde Oakville and Central Oakville ​this area includes several ​of the most exclusive Oakville real estate listings ranging from properties where the worth is inside the lots (not the property and usually close to a million dollars ​for it) it is also where you will discover Oakville real estate listings ​that happen ​to be within ​the millions ​of dollars as this coveted area is close to the restaurants and shopping in Downtown Oakville along with the lakeFurther west and south of the QEW has a fantastic blend of older properties on bigger lotsbut not as pricey as their eastern counterparts!<br /><br />+====== 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 ​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.and above ==== 
 +[[schema_1_0_0_upgrade|Upgrade script]] To upgrade ​the db schema from 0.9.12 
 + 
 +Starting from 1.0it'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]] 
start.1351119223.txt.gz · Last modified: 2012/10/25 00:53 by leland791