Innov-AI: AGI & Data Interoperability Research

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Mail

mail download pop3 mail download imap mail download imap_disk mail send mail process mail process_limit mail count_loaded mail count_all mail count_error mail min_error_date mail show mail show_error mail get_body mail get_error mail replay_error_id mail replay_error_cm mail replay_error_all mail delete_error_id mail delete_error_cm mail 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
[
  {
    "lastattempt": "2018-02-26 06:43:57.0",
    "dtcreate": "2018-02-25 18:41:33.0",
    "nbattempt": "19",
    "subject": "subject",
    "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",
    "cm": "demo_cm_smtp",
    "id": "3",
    "state": "E",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": "2018-02-26 06:43:57.0",
    "dtcreate": "2018-02-25 18:44:40.0",
    "nbattempt": "18",
    "subject": "subject",
    "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",
    "cm": "demo_cm_smtp",
    "id": "4",
    "state": "E",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": "2018-02-26 06:54:23.0",
    "dtcreate": "2018-02-25 18:46:37.0",
    "nbattempt": "17",
    "subject": "subject",
    "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",
    "cm": "demo_cm_smtp",
    "id": "5",
    "state": "S",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": "2018-02-26 06:54:23.0",
    "dtcreate": "2018-02-25 18:51:14.0",
    "nbattempt": "17",
    "subject": "subject",
    "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",
    "cm": "demo_cm_smtp",
    "id": "6",
    "state": "S",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 18:59:01.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "7",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:05:22.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "8",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:08:32.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "9",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:15:30.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "10",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:17:53.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "11",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:20:08.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "12",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:23:01.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "13",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:36:39.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "14",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:38:44.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "15",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:41:46.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "16",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  },
  {
    "lastattempt": null,
    "dtcreate": "2018-02-25 19:43:18.0",
    "nbattempt": "0",
    "subject": "subject",
    "errmsg": null,
    "cm": "demo_cm_smtp",
    "id": "17",
    "state": "W",
    "maillist": "jimmitry.payet@gmail.com",
    "mailbcc": null,
    "mailcc": null
  }
]

mail show_error <limit>

Description

Show mail in error.

Parameters

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

admin
mail show_error 15;

mentdb
{
  "data": [
    {
      "lastattempt": "2018-02-26 06:43:57.0",
      "dtcreate": "2018-02-25 18:41:33.0",
      "nbattempt": "19",
      "subject": "subject",
      "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",
      "cm": "demo_cm_smtp",
      "id": "3",
      "state": "E",
      "maillist": "jimmitry.payet@gmail.com",
      "mailbcc": null,
      "mailcc": null
    },
    {
      "lastattempt": "2018-02-26 06:43:57.0",
      "dtcreate": "2018-02-25 18:44:40.0",
      "nbattempt": "18",
      "subject": "subject",
      "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",
      "cm": "demo_cm_smtp",
      "id": "4",
      "state": "E",
      "maillist": "jimmitry.payet@gmail.com",
      "mailbcc": null,
      "mailcc": null
    }
  ],
  "columns": [
    "id",
    "state",
    "dtcreate",
    "lastattempt",
    "nbattempt",
    "subject",
    "maillist",
    "mailcc",
    "mailbcc",
    "errmsg",
    "cm"
  ],
  "table": "mails"
}

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
535 5.7.8  https://support.google.com/mail/?p=BadCredentials 7sm2113093wry.18 - gsmtp


DEBUG: setDebug: JavaMail version 1.4.7
DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle]
DEBUG SMTP: useEhlo true, useAuth true
DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL true
220 smtp.gmail.com ESMTP 55sm6642082wrz.6 - gsmtp
DEBUG SMTP: connected to host "smtp.gmail.com", port: 465

EHLO macbook-pro-de-jimmitry.home
250-smtp.gmail.com at your service, [90.10.152.181]
250-SIZE 35882577
250-8BITMIME
250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-CHUNKING
250 SMTPUTF8
DEBUG SMTP: Found extension "SIZE", arg "35882577"
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH"
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "CHUNKING", arg ""
DEBUG SMTP: Found extension "SMTPUTF8", arg ""
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM 
DEBUG SMTP: AUTH LOGIN command trace suppressed
DEBUG SMTP: AUTH LOGIN failed
DEBUG SMTP: useEhlo true, useAuth true
DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL true
220 smtp.gmail.com ESMTP 7sm2113093wry.18 - gsmtp
DEBUG SMTP: connected to host "smtp.gmail.com", port: 465

EHLO macbook-pro-de-jimmitry.home
250-smtp.gmail.com at your service, [90.10.152.181]
250-SIZE 35882577
250-8BITMIME
250-AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-CHUNKING
250 SMTPUTF8
DEBUG SMTP: Found extension "SIZE", arg "35882577"
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH"
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "CHUNKING", arg ""
DEBUG SMTP: Found extension "SMTPUTF8", arg ""
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM 
DEBUG SMTP: AUTH LOGIN command trace suppressed
DEBUG SMTP: AUTH LOGIN failed

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

start: 2026-02-02 end: 2026-02-02 v_start: 401 v_end:

INNOV-AI

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

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

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

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

mail process

mail process_limit

mail count_loaded

mail count_all

mail count_error

mail min_error_date

mail show <limit>

mail show_error <limit>

mail get_body <id>

mail get_error <id>

mail replay_error_id <id>

mail replay_error_cm <cm>

mail replay_error_all

mail delete_error_id <id>

mail delete_error_cm <cm>

mail delete_error_all