BACK | MQL Functions | MentDB Weak |
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\" };"
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\" }"
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\" }"
admin
mail send "demo_cm_smtp" "jimmitry.payet@gmail.com" "" "" "subject" "body" "[]";
mentdb
1
admin
mail process;
mentdb
1
admin
mail process_limit;
mentdb
5
admin
mail count_loaded;
mentdb
4
admin
mail count_all;
mentdb
12
admin
mail count_error;
mentdb
3
admin
mail min_error_date;
mentdb
2017-12-12 10:00:00
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>]
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>}
admin
mail get_body 4;
mentdb
body
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>
admin
mail replay_error_id 4;
mentdb
1
admin
mail replay_error_cm "smtp_1";
mentdb
1
admin
mail replay_error_all;
mentdb
1
admin
mail delete_error_id 4;
mentdb
1
admin
mail delete_error_cm "smtp_1";
mentdb
1
admin
mail delete_error_all;
mentdb
1