Documentation | MentDB Weak Server

Show all mail to send

Create an SMTP connection

mail send "demo_cm_smtp" "jim@innov-ai.com.com" "" "" "subject" "body" "[]";

```
"1";
```
Your mail is waiting to be sent...
Open the connect tab, and double click on MENTDB connection
Double click on the table 'mails' (mail_files contains attachements in base 64 format)
You can see that the mail is in the state 'E' (Error)
Click on '535...' (column errmsg) and copy/paste the error message into a new MQL page

535-5.7.8 Username and Password not accepted. Learn more at
535 5.7.8  https://support.google.com/mail/?p=BadCredentials w7-20020aa7da47000000b005224c6b2183sm4805293eds.39 - gsmtp


DEBUG: setDebug: JavaMail version 1.6.2
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 bn21-20020a170906c0d500b00992665694f7sm4817106ejb.107 - gsmtp
DEBUG SMTP: connected to host "smtp.gmail.com", port: 465
EHLO jimmitry-WS-C621E-SAGE-Series
250-smtp.gmail.com at your service, [139.26.144.26]
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: protocolConnect login, host=smtp.gmail.com, user=your-account@gmail.com, password=<non-null>
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM XOAUTH2 
DEBUG SMTP: Using mechanism LOGIN
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 w7-20020aa7da47000000b005224c6b2183sm4805293eds.39 - gsmtp
DEBUG SMTP: connected to host "smtp.gmail.com", port: 465
EHLO jimmitry-WS-C621E-SAGE-Series
250-smtp.gmail.com at your service, [139.26.144.26]
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: protocolConnect login, host=smtp.gmail.com, user=your-account@gmail.com, password=<non-null>
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM XOAUTH2 
DEBUG SMTP: Using mechanism LOGIN
DEBUG SMTP: AUTH LOGIN command trace suppressed
DEBUG SMTP: AUTH LOGIN failed


						;

This is a bad credential (535-5.7.8 Username and Password not accepted)
Update your SMTP configuration (Generate update)
Or update the column 'cm'

sql connect "session1" {cm get "MENTDB";};
sql dml "session1" (concat "UPDATE mails SET cm='new_cm_smtp' WHERE id = 1;");
sql disconnect "session1";

mail replay_error_id 1;
# or mail replay_error_cm "new_cm_smtp";
# or mail replay_error_all;

Your email replay...