Import e-mails from IMAP (and POP3) into Elasticsearch 2.x
This importer connects to IMAP4 or POP3 servers, poll your mail and index it. The emails on the server will be never modified or removed from the server. The importer tracks (after the first initial full load) which mails are new or deleted and then only update the index for this mails.
Features:
- Incremental indexing of e-mails from a IMAP or POP3 server
- Support indexing of attachments
- Support for UTF-7 encoded e-mails (through jutf7)
- SSL, STARTTLS and SASL are supported (through JavaMail API)
- IMAP only: Folders which should be indexed can be specified with a regex pattern
- IMAP only: Subfolders can also be indexed (whole traversal of all folders)
- No special server capabilities needed
- Bulk indexing
- Works also with Gmail, iCloud, Yahoo, etc.
The importer acts as a disconnected client. This means that the importer is polling and for every indexing run a new server connection is opened and, after work is done, closed.
Prerequisites:- Java 7 or 8
- Elasticsearch 2.x
- At least one IMAP4 or POP3 server to connect to
Download .zip or .tar.gz from https://github.com/salyh/elasticsearch-river-imap/releases/latest (only Version 0.8.6 or higher) and unpack them somewhere.
Then run
bin/importer.sh [-e] <config-file>
- -e: Start embedded elasticsearch node (only for testing !!)
- config-file: path to the json configuration file (see next chapter)
{ "mail.store.protocol":"imap", "mail.imap.host":"imap.server.com", "mail.imap.port":993, "mail.imap.ssl.enable":true, "mail.imap.connectionpoolsize":"3", "mail.debug":"false", "mail.imap.timeout":10000, "users":["[email protected]"], "passwords":["secret"], "schedule":null, "interval":"60s", "threads":5, "folderpattern":null, "bulk_size":100, "max_bulk_requests":"30", "bulk_flush_interval":"5s", "mail_index_name":"imapriverdata", "mail_type_name":"mail", "with_striptags_from_textcontent":true, "with_attachments":false, "with_text_content":true, "with_flag_sync":true, "keep_expunged_messages":false, "index_settings" : null, "type_mapping" : null, "user_source" : null, "ldap_url" : null, "ldap_user" : null, "ldap_password" : null, "ldap_base" : null, "ldap_name_field" : "uid", "ldap_password_field" : null, "ldap_refresh_interval" : null, "master_user" : null, "master_password" : null,"client.transport.ignore_cluster_name": false, "client.transport.ping_timeout": "5s", "client.transport.nodes_sampler_interval": "5s", "client.transport.sniff": true, "cluster.name": "elasticsearch", "elasticsearch.hosts": "localhost:9300,127.0.0.1:9300"
}
mail.*
- see JAVAMail documentation https://javamail.java.net/nonav/docs/api/ (default: none)user
- user name for server login (default:null
) - deprecated, useusers
password
- password for server login (default:null
) - deprecated, usepasswords
users
- array of users name for server login (default:null
)passwords
- array of passwords for server login (default:null
)schedule
- a cron expression like0/3 0-59 0-23 ? * *
(default:null
)interval
- if noschedule
is set then this is will be the indexing interval (default:60s
)threads
- How many thready for parallel indexing (must be 1 or higher) (default:5
)folderpattern
- IMAP only: regular expressions which folders should be indexed (default:null
)bulk_size
- the length of each bulk index request submitted (default:100
)max_bulk_requests
- the maximum number of concurrent bulk requests (default:30
)bulk_flush_interval
- the time period the bulk processor is flushing outstanding documents (default:5s
)mail_index_name
- name of the index which holds the mail (default:imapriverdata
)mail_index_name_strategy
- how the indexname should be composed for each user (default:all_in_one
)all_in_one
- Put all mails from all users, the index name ismail_index_name
username
- Put mail from each user in a index with the users usernameusername_crop
- Put mail from each user in a index with the users username but crop at the @ signprefixed_username
- Put mail from each user in a index with the users username prefixed bymail_index_name
prefixed_username_crop
- Put mail from each user in a index with the users username prefixed bymail_index_name
but crop at the @ sign
mail_type_name
- name of the type (default:mail
)with_striptags_from_textcontent
- iftrue
then html/xml tags are stripped from text content (default:true
)with_attachments
- iftrue
then attachments will be indexed (default:false
)with_text_content
- iftrue
then the text content of the mail is indexed (default:true
)with_flag_sync
- IMAP only: iftrue
then message flag changes will be detected and indexed. Maybe slow for very huge mailboxes. (default:true
)keep_expunged_messages
- iftrue
then message which are expunged/deleted on the server will be kept in elasticsearch. (default:false
)index_settings
- optional settings for the Elasticsearch indextype_mapping
- optional mapping for the Elasticsearch index typeheaders_to_fields
- array with e-mail header names to include as proper fields. To create a legal field name, the header name is prefixed withheader_
, lowercased and has all non-alphanumeric characters replaced with_
. For example, an input of["Message-ID"]
will copy that header into a field with nameheader_message_id
.user_source
- If "ldap" then query user and passwords from an ldap directory, if null or missing use users/passwords from the config file (default: null)ldap_url
- LDAP host and port (default: null), example: "ldap:https://ldaphostname:389"ldap_user
- Ldap user which is used to query IMAP users (default: null), example: "cn=Directory Manager"ldap_password
- Ldap password forldap_user
(default: null)ldap_base
- Base Dn where to search for users, (default: null), example: "ou=users,ou=accounts,dc=company,dc=org"ldap_name_field
- The fieldname (attribute) where the IMAP username is stored (default "dn"), example: "uid"ldap_password_field
- The fieldname (attribute) of the IMAP password (default: "userPassword")ldap_refresh_interval
- Refresh interval in minutes (default:"60"), set to "0" to disable automatic refreshing. If enabled this will automatically refresh the users/passwords from ldap every n minutes.master_user
- For Dovecot, a master user account can be supplied who can access all users' mailboxes, even if their passwords are encrypted (default: null)master_password
- master user password (default: null)
client.transport.*
see https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/transport-client.htmlcluster.name
see https://www.elastic.co/guide/en/elasticsearch/client/java-api/current/transport-client.htmlelasticsearch.hosts
Comma separated list of elasticsearch nodes/servers (mandatory)
Note: For POP3 only the "INBOX" folder is supported. This is a limitation of the POP3 protocol.
```json "mail" : { "properties" : { "attachmentCount" : { "type" : "long" }, "bcc" : { "properties" : { "email" : { "type" : "string" }, "personal" : { "type" : "string" } } }, "cc" : { "properties" : { "email" : { "type" : "string" }, "personal" : { "type" : "string" } } }, "contentType" : { "type" : "string" }, "flaghashcode" : { "type" : "integer" }, "flags" : { "type" : "string" }, "folderFullName" : { "type" : "string", "index" : "not_analyzed" }, "folderUri" : { "type" : "string" }, "from" : { "properties" : { "email" : { "type" : "string" }, "personal" : { "type" : "string" } } }, "headers" : { "properties" : { "name" : { "type" : "string" }, "value" : { "type" : "string" } } }, "mailboxType" : { "type" : "string" }, "receivedDate" : { "type" : "date", "format" : "basic_date_time" }, "sentDate" : { "type" : "date", "format" : "basic_date_time" }, "size" : { "type" : "long" }, "subject" : { "type" : "string" }, "textContent" : { "type" : "string" }, "to" : { "properties" : { "email" : { "type" : "string" }, "personal" : { "type" : "string" } } }, "uid" : { "type" : "long" } } } } ```For advanced mapping ideas look here:
```json { "mail":{ "properties":{ "textContent":{ "type":"langdetect" }, "email":{ "type":"string", "index":"not_analyzed" }, "subject":{ "type":"multi_field", "fields":{ "text":{ "type":"string" }, "raw":{ "type":"string", "index":"not_analyzed" } } }, "personal":{ "type":"multi_field", "fields":{ "title":{ "type":"string" }, "raw":{ "type":"string", "index":"not_analyzed" } } } } } } ``` ```json { "_index" : "imapriverdata", "_type" : "mail", "_id" : "50220::imap:https://test%[email protected]/import", "_score" : 1.0, "_source" : { "attachmentCount" : 0, "attachments" : null, "bcc" : null, "cc" : null, "contentType" : "text/plain; charset=ISO-8859-15", "flaghashcode" : 16, "flags" : [ "Recent" ], "folderFullName" : "test", "folderUri" : "imap:https://test%[email protected]/import", "from" : { "email" : "[email protected]", "personal" : null }, "headers" : [ { "name" : "Subject", "value" : "Suchagent Wohnung mieten in Berlin - 1 neues Objekt gefunden!" }, { "name" : "Return-Path", "value" : "" }, { "name" : "Content-Transfer-Encoding", "value" : "quoted-printable" }, { "name" : "To", "value" : "[email protected]" }, { "name" : "X-OfflineIMAP-1722382714-52656d6f7465-6165727a7465", "value" : "1248516496-0146849121575-v5.99.4" }, { "name" : "Message-ID", "value" : "<[email protected]>" }, { "name" : "Mime-Version", "value" : "1.0" }, { "name" : "X-Gmail-Labels", "value" : "ablage,[email protected]" }, { "name" : "X-GM-THRID", "value" : "1309162987234255956" }, { "name" : "Delivered-To", "value" : "GMX delivery to [email protected]" }, { "name" : "Reply-To", "value" : "[email protected]" }, { "name" : "Date", "value" : "Fri, 18 Nov 2005 04:17:24 +0100 (MET)" }, { "name" : "Auto-Submitted", "value" : "auto-generated" }, { "name" : "Received", "value" : "(qmail invoked by alias); 18 Nov 2005 03:17:25 -0000" }, { "name" : "Content-Type", "value" : "text/plain; charset=\"ISO-8859-15\"" }, { "name" : "From", "value" : "[email protected]" } ], "mailboxType" : "IMAP", "popId" : null, "receivedDate" : 1132283845000, "sentDate" : 1132283844000, "size" : 3645, "subject" : "Suchagent Wohnung mieten in Berlin - 1 neues Objekt gefunden!", "textContent" : "Sehr geehrter Nutzer, ... JETZT AUCH IM FERNSEHEN: IMMOBILIENANGEBOTE FÜR HAMBURG UND UMGEBUNG!\r\n\tFinden Sie Ihre Wunschwohnung oder ..." "to" : [ { "email" : "[email protected]", "personal" : null } ], "uid" : 50220 } } ``` If you want also indexing your mail attachments look here: * salyh#10 (comment) * salyh#13 * https://tinyurl.com/nbujv7h * https://github.com/salyh/elasticsearch-river-imap/blob/master/src/test/java/de/saly/elasticsearch/imap/AttachmentMapperTest.java * Hans Jørgen Hoel (https://github.com/hansjorg) * Stefan Thies (https://github.com/megastef) * René Peinl (University Hof) Copyright (C) 2014-2015 by Hendrik Saly (https://saly.de) and others.Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
https://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.