BACK	MQL Functions \| MentDB Weak

Mail

Mail sender.

mail download pop3mail download imapmail download imap_diskmail sendmail processmail process_limitmail count_loadedmail count_allmail count_errormail min_error_datemail showmail show_errormail get_bodymail get_errormail replay_error_idmail replay_error_cmmail replay_error_allmail delete_error_idmail delete_error_cmmail delete_error_all

mail download pop3 <output_dir> <nbMsgToDownload> <deleteMsgAfterDownload> <jsonPOP3config>

Description

Download mail from a POP3 mail box.

Parameters

output_dir: The output directory - string - required
nbMsgToDownload: The number of message to download - string - required
deleteMsgAfterDownload: Mark the message as deleted after download (true|false) - number - required
jsonPOP3config: The JSON POP3 config - string - required

admin
mail download pop3 "/Users/jimmitry/Desktop/tmp"
	3 true
	{cm get "demo_cm_pop3";}

mentdb
"{
  \"Total\": 14368,
  \"NbReceived\": 1,
  \"Directory\": \"/Users/jimmitry/Desktop/tmp/20180106160818\"
};"

mail download imap <output_dir> <nbMsgToDownload> <unreadOrAll> <copyMessageInAnotherFolder> <deleteMsgAfterDownload> <markAsRead> <startDate> <endDate> <fromCondition> <subjectCondition> <jsonIMAPconfig>

Description

Download mail from a IMAP mail box (save mail in json base 64).

Parameters

output_dir: The output directory - string - required
nbMsgToDownload: The number of message to download - string - required
unreadOrAll: Filter unread or all (unread|all) - string - required
copyMessageInAnotherFolder: If not null or empty, copy mail into the folder - string - required
deleteMsgAfterDownload: Mark the message as deleted after download (true|false) - number - required
markAsRead: Mark messages as read (true|false) - string - required
startDate: Start date - string - required
endDate: End date - string - required
fromCondition: The MQL from condition (variable: [imap_from]) - string - required
subjectCondition: The MQL subject condition (variable: [imap_subject]) - string - required
jsonIMAPconfig: The JSON IMAP config - string - required

admin
-> "[receive_dir]" "tmp";

	#Récupération des mails;
	json load "receive_state" (mail download imap [receive_dir]
		1 "unread" null false false
		"2019-05-07" null
		(mql true)
		(mql true)
		{cm get "demo_cm_imap";};
	);

	if (> (json select "receive_state" "/NbReceived") 0) {

		-> "[sub_receive_dir]" (json select "receive_state" "/Directory");

		json load "sub_receive_dir" (file dir_list [sub_receive_dir]);
		json parse_array "sub_receive_dir" "/" "[mail]" {

			if (string ends_with [mail] ".json") {

				json load "current_mail" (file load (concat [sub_receive_dir] "/" [mail]));

				log trace (json doc "current_mail");

			};
		
		};

	};

	json doc "receive_state";

mentdb
"{
  \"Unread\": 0,
  \"Total\": 14368,
  \"NbReceived\": 1,
  \"Directory\": \"/Users/jimmitry/Desktop/tmp/20180106160818\"
}"

mail download imap_disk <output_dir> <nbMsgToDownload> <unreadOrAll> <copyMessageInAnotherFolder> <deleteMsgAfterDownload> <markAsRead> <startDate> <endDate> <fromCondition> <subjectCondition> <jsonIMAPconfig>

Description

Download mail from a IMAP mail box (save mail in had disk).

admin
-> "[receive_dir]" "tmp";

	#Récupération des mails;
	json load "receive_state" (mail download imap_disk [receive_dir]
		1 "unread" null false false
		"2019-05-07" null
		(mql true)
		(mql true)
		{cm get "demo_cm_imap";};
	);

	if (> (json select "receive_state" "/NbReceived") 0) {

		-> "[sub_receive_dir]" (json select "receive_state" "/Directory");

		json load "sub_receive_dir" (file dir_list [sub_receive_dir]);
		json parse_array "sub_receive_dir" "/" "[mail]" {

			if (string ends_with [mail] ".json") {

				json load "current_mail" (file load (concat [sub_receive_dir] "/" [mail]));

				log trace (json doc "current_mail");

			};
		
		};

	};

	json doc "receive_state";

mentdb
"{
  \"Unread\": 0,
  \"Total\": 14368,
  \"NbReceived\": 1,
  \"Directory\": \"/Users/jimmitry/Desktop/tmp/20180106160818\"
}"

mail send <cm> <to> <cc> <bcc> <subject> <body> <jsonAttachments>

Description

Add a mail to send into the mail spooler.

Parameters

cm: The connection id - string - required
to: The mail list to (separate by ; ) - string - required
cc: The mail list copy (separate by ; ) - string - required
bcc: The mail list secret copy (separate by ; ) - string - required
subject: The subject - string - required
body: The body - string - required
jsonAttachments: The JSON attachments - string - required

admin
mail send "demo_cm_smtp" "jimmitry.payet@gmail.com" "" "" "subject" "body" "[]";

mentdb
1

mail process

Description

Process to send mail.

admin
mail process;

mentdb
1

mail process_limit

Description

Show the mail config process limit.

admin
mail process_limit;

mentdb
5

mail count_loaded

Description

Count the number of loaded process.

admin
mail count_loaded;

mentdb
4

mail count_all

Description

Count all mails to send.

admin
mail count_all;

mentdb
12

mail count_error

Description

Count all mails with error.

admin
mail count_error;

mentdb
3

mail min_error_date

Description

Get the min error date (more old date).

admin
mail min_error_date;

mentdb
2017-12-12 10:00:00

mail show <limit>

Description

Show mails to send.

Parameters

limit: The limit (default 15) - number - required

admin
mail show 15

mentdb
[<br>  {<br>    "lastattempt": "2018-02-26 06:43:57.0",<br>    "dtcreate": "2018-02-25 18:41:33.0",<br>    "nbattempt": "19",<br>    "subject": "subject",<br>    "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials 188sm7482946wmx.12 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 123sm6579371wmt.31 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 188sm7482946wmx.12 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>    "cm": "demo_cm_smtp",<br>    "id": "3",<br>    "state": "E",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": "2018-02-26 06:43:57.0",<br>    "dtcreate": "2018-02-25 18:44:40.0",<br>    "nbattempt": "18",<br>    "subject": "subject",<br>    "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials 7sm2113093wry.18 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 55sm6642082wrz.6 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 7sm2113093wry.18 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>    "cm": "demo_cm_smtp",<br>    "id": "4",<br>    "state": "E",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": "2018-02-26 06:54:23.0",<br>    "dtcreate": "2018-02-25 18:46:37.0",<br>    "nbattempt": "17",<br>    "subject": "subject",<br>    "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials e191sm5921603wmg.12 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP h194sm21470505wma.8 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP e191sm5921603wmg.12 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>    "cm": "demo_cm_smtp",<br>    "id": "5",<br>    "state": "S",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": "2018-02-26 06:54:23.0",<br>    "dtcreate": "2018-02-25 18:51:14.0",<br>    "nbattempt": "17",<br>    "subject": "subject",<br>    "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials 8sm1655247wmf.13 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP p104sm12967120wrb.47 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 8sm1655247wmf.13 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>    "cm": "demo_cm_smtp",<br>    "id": "6",<br>    "state": "S",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 18:59:01.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "7",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:05:22.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "8",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:08:32.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "9",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:15:30.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "10",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:17:53.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "11",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:20:08.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "12",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:23:01.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "13",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:36:39.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "14",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:38:44.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "15",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:41:46.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "16",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  },<br>  {<br>    "lastattempt": null,<br>    "dtcreate": "2018-02-25 19:43:18.0",<br>    "nbattempt": "0",<br>    "subject": "subject",<br>    "errmsg": null,<br>    "cm": "demo_cm_smtp",<br>    "id": "17",<br>    "state": "W",<br>    "maillist": "jimmitry.payet@gmail.com",<br>    "mailbcc": null,<br>    "mailcc": null<br>  }<br>]

mail show_error <limit>

Description

Show mail in error.

Parameters

limit: The limit (default 15) - number - required

admin
mail show_error 15;

mentdb
{<br>  "data": [<br>    {<br>      "lastattempt": "2018-02-26 06:43:57.0",<br>      "dtcreate": "2018-02-25 18:41:33.0",<br>      "nbattempt": "19",<br>      "subject": "subject",<br>      "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials 188sm7482946wmx.12 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 123sm6579371wmt.31 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 188sm7482946wmx.12 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>      "cm": "demo_cm_smtp",<br>      "id": "3",<br>      "state": "E",<br>      "maillist": "jimmitry.payet@gmail.com",<br>      "mailbcc": null,<br>      "mailcc": null<br>    },<br>    {<br>      "lastattempt": "2018-02-26 06:43:57.0",<br>      "dtcreate": "2018-02-25 18:44:40.0",<br>      "nbattempt": "18",<br>      "subject": "subject",<br>      "errmsg": "535-5.7.8 Username and Password not accepted. Learn more at\n535 5.7.8  https://support.google.com/mail/?p\u003dBadCredentials 7sm2113093wry.18 - gsmtp\n\n\nDEBUG: setDebug: JavaMail version 1.4.7\nDEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 55sm6642082wrz.6 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\nDEBUG SMTP: useEhlo true, useAuth true\nDEBUG SMTP: trying to connect to host \"smtp.gmail.com\", port 465, isSSL true\n220 smtp.gmail.com ESMTP 7sm2113093wry.18 - gsmtp\nDEBUG SMTP: connected to host \"smtp.gmail.com\", port: 465\n\nEHLO macbook-pro-de-jimmitry.home\n250-smtp.gmail.com at your service, [90.10.152.181]\n250-SIZE 35882577\n250-8BITMIME\n250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\n250-ENHANCEDSTATUSCODES\n250-PIPELINING\n250-CHUNKING\n250 SMTPUTF8\nDEBUG SMTP: Found extension \"SIZE\", arg \"35882577\"\nDEBUG SMTP: Found extension \"8BITMIME\", arg \"\"\nDEBUG SMTP: Found extension \"AUTH\", arg \"LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH\"\nDEBUG SMTP: Found extension \"ENHANCEDSTATUSCODES\", arg \"\"\nDEBUG SMTP: Found extension \"PIPELINING\", arg \"\"\nDEBUG SMTP: Found extension \"CHUNKING\", arg \"\"\nDEBUG SMTP: Found extension \"SMTPUTF8\", arg \"\"\nDEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM \nDEBUG SMTP: AUTH LOGIN command trace suppressed\nDEBUG SMTP: AUTH LOGIN failed\n",<br>      "cm": "demo_cm_smtp",<br>      "id": "4",<br>      "state": "E",<br>      "maillist": "jimmitry.payet@gmail.com",<br>      "mailbcc": null,<br>      "mailcc": null<br>    }<br>  ],<br>  "columns": [<br>    "id",<br>    "state",<br>    "dtcreate",<br>    "lastattempt",<br>    "nbattempt",<br>    "subject",<br>    "maillist",<br>    "mailcc",<br>    "mailbcc",<br>    "errmsg",<br>    "cm"<br>  ],<br>  "table": "mails"<br>}

mail get_body <id>

Description

Get the body for a specific mail

Parameters

id: The mail id - number - required

admin
mail get_body 4;

mentdb
body

mail get_error <id>

Description

Get the error message for a specific mail

Parameters

id: The mail id - number - required

admin
mail get_error 4;

mentdb
535-5.7.8 Username and Password not accepted. Learn more at<br>535 5.7.8  https://support.google.com/mail/?p=BadCredentials 7sm2113093wry.18 - gsmtp<br><br><br>DEBUG: setDebug: JavaMail version 1.4.7<br>DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]<br>DEBUG SMTP: useEhlo true, useAuth true<br>DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL true<br>220 smtp.gmail.com ESMTP 55sm6642082wrz.6 - gsmtp<br>DEBUG SMTP: connected to host "smtp.gmail.com", port: 465<br><br>EHLO macbook-pro-de-jimmitry.home<br>250-smtp.gmail.com at your service, [90.10.152.181]<br>250-SIZE 35882577<br>250-8BITMIME<br>250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH<br>250-ENHANCEDSTATUSCODES<br>250-PIPELINING<br>250-CHUNKING<br>250 SMTPUTF8<br>DEBUG SMTP: Found extension "SIZE", arg "35882577"<br>DEBUG SMTP: Found extension "8BITMIME", arg ""<br>DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH"<br>DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""<br>DEBUG SMTP: Found extension "PIPELINING", arg ""<br>DEBUG SMTP: Found extension "CHUNKING", arg ""<br>DEBUG SMTP: Found extension "SMTPUTF8", arg ""<br>DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM <br>DEBUG SMTP: AUTH LOGIN command trace suppressed<br>DEBUG SMTP: AUTH LOGIN failed<br>DEBUG SMTP: useEhlo true, useAuth true<br>DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL true<br>220 smtp.gmail.com ESMTP 7sm2113093wry.18 - gsmtp<br>DEBUG SMTP: connected to host "smtp.gmail.com", port: 465<br><br>EHLO macbook-pro-de-jimmitry.home<br>250-smtp.gmail.com at your service, [90.10.152.181]<br>250-SIZE 35882577<br>250-8BITMIME<br>250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH<br>250-ENHANCEDSTATUSCODES<br>250-PIPELINING<br>250-CHUNKING<br>250 SMTPUTF8<br>DEBUG SMTP: Found extension "SIZE", arg "35882577"<br>DEBUG SMTP: Found extension "8BITMIME", arg ""<br>DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH"<br>DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""<br>DEBUG SMTP: Found extension "PIPELINING", arg ""<br>DEBUG SMTP: Found extension "CHUNKING", arg ""<br>DEBUG SMTP: Found extension "SMTPUTF8", arg ""<br>DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM <br>DEBUG SMTP: AUTH LOGIN command trace suppressed<br>DEBUG SMTP: AUTH LOGIN failed<br>

mail replay_error_id <id>

Description

Replay a specific mail en error.

Parameters

id: The mail id - number - required

admin
mail replay_error_id 4;

mentdb
1

mail replay_error_cm <cm>

Description

Replay all mails for a specific connection id.

Parameters

cm: The connection id - string - required

admin
mail replay_error_cm "smtp_1";

mentdb
1

mail replay_error_all

Description

Replay all mails in error

admin
mail replay_error_all;

mentdb
1

mail delete_error_id <id>

Description

Delete a specific mail in error.

Parameters

id: The mail id - number - required

admin
mail delete_error_id 4;

mentdb
1

mail delete_error_cm <cm>

Description

Delete all mails for a specific connection id.

Parameters

cm: The connection id - string - required

admin
mail delete_error_cm "smtp_1";

mentdb
1

mail delete_error_all

Description

Delete all mails in error

admin
mail delete_error_all;

mentdb
1