 | MentDB Weak MQL Functions |
Back to MQL Functions root
Go to MentDB Weak
Go to Innov-AI
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.
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
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).
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
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).
Download mail from a IMAP mail box (save mail in had disk).
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
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_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.
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
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.
Process to send mail.
admin
mail process;
mentdb
1
mail process_limit
Description
Show the mail config process limit.
Show the mail config process limit.
admin
mail process_limit;
mentdb
5
mail count_loaded
Description
Count the number of loaded process.
Count the number of loaded process.
admin
mail count_loaded;
mentdb
4
mail count_all
Description
Count all mails to send.
Count all mails to send.
admin
mail count_all;
mentdb
12
mail count_error
Description
Count all mails with error.
Count all mails with error.
admin
mail count_error;
mentdb
3
mail min_error_date
Description
Get the min error date (more old date).
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.
Show mails to send.
Parameters
limit: The limit (default 15) - number - required
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.
Show mail in error.
Parameters
limit: The limit (default 15) - number - required
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
Get the body for a specific mail
Parameters
id: The mail id - number - required
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
Get the error message for a specific mail
Parameters
id: The mail id - number - required
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.
Replay a specific mail en error.
Parameters
id: The mail id - number - required
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.
Replay all mails for a specific connection id.
Parameters
cm: The connection id - string - required
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
Replay all mails in error
admin
mail replay_error_all;
mentdb
1
mail delete_error_id <id>
Description
Delete a specific mail in error.
Delete a specific mail in error.
Parameters
id: The mail id - number - required
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.
Delete all mails for a specific connection id.
Parameters
cm: The connection id - string - required
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
Delete all mails in error
admin
mail delete_error_all;
mentdb
1
French Technology© 2004-2012 - 2022