Need Help Mautic Installation On AWS- SES

Your software
My Mautic version is: 3.3.2.0 via bitnami
My PHP version is: 7.3.27
My Database type and version is: Mysql 5.0.12
Hosting: AWS - EC2 - SES

Your problem

I am new with mautic and have no coding background.
I took @joeyk advice and try to install Mautic on AWS. Thanks @joeyk

My problem is:

  1. Please check my cronjob and correct it if any suggestion.

  2. on mautic configuration > email settings > mail send settings → I;ve sucess for test connection

But, when send test email, there nothing happen. See the error log

  1. is there any tutorial for using mautic on SES?
    i also have problem sending test example on mautic with SES

These errors are showing in the log:
[2021-04-11 00:06:01] mautic.NOTICE: PHP Notice - Undefined index: path - in file /opt/bitnami/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 120 {“request”:"[object] (Symfony\Component\HttpFoundation\Request: GET //console HTTP/1.1\r\nAccept-Encoding: gzip\r\nConnection: close\r\nHost: mautic.training.andonpokayoke.com\r\nReferer: http://13.213.7.72:80/console/\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36\r\nX-Php-Ob-Level: 1\r\n\r\n)",“exception”:"[object] (Symfony\Component\Debug\Exception\FlattenException: {})",“logger”:null,“class”:“Symfony\Component\HttpKernel\Exception\NotFoundHttpException”,“currentContent”:"",“layout”:“Error”,“code”:404,“anonymous”:true,“baseTemplate”:“MauticCoreBundle:Default:slim.html.php”,“templatePage”:false,“template”:“MauticCoreBundle:Error:404.html.php”,“templating”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\DelegatingEngine: {})",“statusText”:“Not Found”,“url”:"//console",“urlParts”:{“host”:“console”}}
[2021-04-11 01:07:15] mautic.NOTICE: PHP Notice - Undefined index: path - in file /opt/bitnami/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 120 {“request”:"[object] (Symfony\Component\HttpFoundation\Request: GET //console HTTP/1.1\r\nAccept-Encoding: gzip\r\nConnection: close\r\nHost: mautic.training.andonpokayoke.com\r\nReferer: http://18.139.199.194:80/console/\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36\r\nX-Php-Ob-Level: 1\r\n\r\n)",“exception”:"[object] (Symfony\Component\Debug\Exception\FlattenException: {})",“logger”:null,“class”:“Symfony\Component\HttpKernel\Exception\NotFoundHttpException”,“currentContent”:"",“layout”:“Error”,“code”:404,“anonymous”:true,“baseTemplate”:“MauticCoreBundle:Default:slim.html.php”,“templatePage”:false,“template”:“MauticCoreBundle:Error:404.html.php”,“templating”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\DelegatingEngine: {})",“statusText”:“Not Found”,“url”:"//console",“urlParts”:{“host”:“console”}}
[2021-04-11 01:08:22] mautic.NOTICE: PHP Notice - Undefined index: path - in file /opt/bitnami/mautic/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 120 {“request”:"[object] (Symfony\Component\HttpFoundation\Request: GET //console HTTP/1.1\r\nAccept-Encoding: gzip\r\nConnection: close\r\nHost: mautic.training.andonpokayoke.com\r\nReferer: http://18.138.27.229:80/console/\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36\r\nX-Php-Ob-Level: 1\r\n\r\n)",“exception”:"[object] (Symfony\Component\Debug\Exception\FlattenException: {})",“logger”:null,“class”:“Symfony\Component\HttpKernel\Exception\NotFoundHttpException”,“currentContent”:"",“layout”:“Error”,“code”:404,“anonymous”:true,“baseTemplate”:“MauticCoreBundle:Default:slim.html.php”,“templatePage”:false,“template”:“MauticCoreBundle:Error:404.html.php”,“templating”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\DelegatingEngine: {})",“statusText”:“Not Found”,“url”:"//console",“urlParts”:{“host”:“console”}}

Problem with send example on mautic

[2021-04-11 08:20:21] mautic.ERROR: [MAIL ERROR] Expected response code 250 but got code “554”, with message "554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari " Log data: ++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport << 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> STARTTLS << 220 Ready to start TLS >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> AUTH LOGIN << 334 VXNlcm5hbWU6 >> QUtJQVZIRFFXRU5OV0hESlU0N1k= << 334 UGFzc3dvcmQ6 >> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI= << 235 Authentication successful. ++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started >> MAIL FROM: << 250 Ok >> RCPT TO: << 250 Ok >> DATA << 354 End data with . >> . << 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari !! Expected response code 250 but got code “554”, with message "554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari " (code: 554) Log data: ++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport << 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> STARTTLS << 220 Ready to start TLS >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> AUTH LOGIN << 334 VXNlcm5hbWU6 >> QUtJQVZIRFFXRU5OV0hESlU0N1k= << 334 UGFzc3dvcmQ6 >> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI= << 235 Authentication successful. ++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started >> MAIL FROM: << 250 Ok >> RCPT TO: << 250 Ok >> DATA << 354 End data with . >> . << 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari !! Expected response code 250 but got code “554”, with message "554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari " (code: 554) !! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari " Log data: ++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport << 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> STARTTLS << 220 Ready to start TLS >> EHLO mautic.training.andonpokayoke.com << 250-email-smtp.amazonaws.com 250-8BITMIME 250-STARTTLS 250-AUTH PLAIN LOGIN 250 Ok >> AUTH LOGIN << 334 VXNlcm5hbWU6 >> QUtJQVZIRFFXRU5OV0hESlU0N1k= << 334 UGFzc3dvcmQ6 >> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI= << 235 Authentication successful. ++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started >> MAIL FROM: << 250 Ok >> RCPT TO: << 250 Ok >> DATA << 354 End data with . >> . << 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari !! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari " (code: 554) (code: 554) (send); info@training.andonpokayoke.com {“exception”:”[object] (Swift_TransportException(code: 554): Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n”\nLog data:\n++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport\n<< 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> STARTTLS\r\n\n<< 220 Ready to start TLS\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> AUTH LOGIN\r\n\n<< 334 VXNlcm5hbWU6\r\n\n>> QUtJQVZIRFFXRU5OV0hESlU0N1k=\r\n\n<< 334 UGFzc3dvcmQ6\r\n\n>> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI=\r\n\n<< 235 Authentication successful.\r\n\n++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started\n>> MAIL FROM:\r\n\n<< 250 Ok\r\n\n>> RCPT TO:\r\n\n<< 250 Ok\r\n\n>> DATA\r\n\n<< 354 End data with .\r\n\n>> \r\n.\r\n\n<< 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n\n!! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n” (code: 554)\nLog data:\n++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport\n<< 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> STARTTLS\r\n\n<< 220 Ready to start TLS\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> AUTH LOGIN\r\n\n<< 334 VXNlcm5hbWU6\r\n\n>> QUtJQVZIRFFXRU5OV0hESlU0N1k=\r\n\n<< 334 UGFzc3dvcmQ6\r\n\n>> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI=\r\n\n<< 235 Authentication successful.\r\n\n++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started\n>> MAIL FROM:\r\n\n<< 250 Ok\r\n\n>> RCPT TO:\r\n\n<< 250 Ok\r\n\n>> DATA\r\n\n<< 354 End data with .\r\n\n>> \r\n.\r\n\n<< 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n\n!! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n” (code: 554)\n!! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n”\nLog data:\n++ Starting Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport\n<< 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> STARTTLS\r\n\n<< 220 Ready to start TLS\r\n\n>> EHLO mautic.training.andonpokayoke.com\r\n\n<< 250-email-smtp.amazonaws.com\r\n250-8BITMIME\r\n250-STARTTLS\r\n250-AUTH PLAIN LOGIN\r\n250 Ok\r\n\n>> AUTH LOGIN\r\n\n<< 334 VXNlcm5hbWU6\r\n\n>> QUtJQVZIRFFXRU5OV0hESlU0N1k=\r\n\n<< 334 UGFzc3dvcmQ6\r\n\n>> Qk45elZDZVFWemN0RjZ2QmlnSW45R2lzd2x2KzVPdnNRZld2N20xS3BFWHI=\r\n\n<< 235 Authentication successful.\r\n\n++ Mautic\EmailBundle\Swiftmailer\Transport\AmazonTransport started\n>> MAIL FROM:\r\n\n<< 250 Ok\r\n\n>> RCPT TO:\r\n\n<< 250 Ok\r\n\n>> DATA\r\n\n<< 354 End data with .\r\n\n>> \r\n.\r\n\n<< 554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n\n!! Expected response code 250 but got code “554”, with message “554 Message rejected: Email address is not verified. The following identities failed the check in region AP-SOUTHEAST-1: Rosita Lasari \r\n” (code: 554) (code: 554) at /opt/bitnami/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Plugins/LoggerPlugin.php:124)”}

Steps I have tried to fix the problem:

You need to move out your Amazon SES account from the sandbox.
Go into your AWS Console and the region you use. Complete the instructions regarding moving to production access in SES.

Thank you @joeyk

I’ve succeed move out from sandbox.

I am using SES API with success test connection

And Success for Send Test Email

Here the Amazon SNS setting

And Amazon SES Notification Setting

And success for Channel Email > send example


But, I still have problem sending campaign from mautic.

Here is my cronjob

Here the log file

[2021-04-18 03:14:14] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /yyy/xxx/training.www.com/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 173 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:ap-southeast-1:358866101083:Mautic’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘training.www.com’.”},“type”:“AmazonSnsSubscriptionSucceeded”}
[2021-04-18 03:14:14] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload

And also,i have problem with maxmind GeolIteIP and i don’t have any access to use SSH

Hi,
those send mail errors can be different issue. Can you plz check if the email you are trying to send is still available OR the campaign action didn’t expire. What is the timing on that campaign action that you try to send? Immediate? Is it following another action?

Regarding maxmind - sorry I only install via SSH.

HI

I am still have failed notification
image

Here How the email handled

Here the contact segment (3 contacts)


Here the campaign






And here the spool folder

And here the log files

[2021-04-18 03:14:14] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /home/pusatjua/training.andonpokayoke.com/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 173 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:ap-southeast-1:358866101083:Mautic’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘training.andonpokayoke.com’.”},“type”:“AmazonSnsSubscriptionSucceeded”}
[2021-04-18 03:14:14] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload
[2021-04-18 03:14:14] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /home/pusatjua/training.andonpokayoke.com/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 173 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:ap-southeast-1:358866101083:Mautic’ to receive ‘Complaint’ notifications from Amazon SES for identity ‘training.andonpokayoke.com’.”},“type”:“AmazonSnsSubscriptionSucceeded”}
[2021-04-18 03:14:14] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload

Hi

Here the addition yesterday log information

[2021-04-17 06:01:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:01:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:06:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:06:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:11:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:11:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:16:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:16:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:21:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:21:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:26:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:26:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:31:05] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:31:05] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:36:06] mautic.NOTICE: Swift_TransportException: Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php line 269 while running console command mautic:emails:send
[2021-04-17 06:36:06] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 06:41:32] mautic.NOTICE: Swift_TransportException: Connection to tcp://training.andonpokayoke.com:465 Timed Out Log data: ++ Starting Swift_Transport_EsmtpTransport !! Connection to tcp://training.andonpokayoke.com:465 Timed Out (code: 0) (uncaught exception) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Plugins/LoggerPlugin.php line 124 while running console command mautic:emails:send
[2021-04-17 06:41:32] mautic.WARNING: Command mautic:emails:send exited with status code 1
[2021-04-17 18:52:08] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:13] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:15] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:17] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:21] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:26] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:28] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}
[2021-04-17 18:52:30] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: “An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason) SELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log WHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2” at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing ‘REPLACE INTO maumg_campaign_lead_event_failed_log( log_id, date_added, reason)\nSELECT id, :dateAdded as date_added, :message as reason from maumg_campaign_lead_event_log\nWHERE is_scheduled = 1 AND lead_id = :contactId AND campaign_id = :campaignId AND rotation = :rotation’:\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘:dateAdded as date_added, :message as reason from maumg_campaign_lead_event_l…’ at line 2 at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}

And here also from yesterday error log

[2021-04-17 06:01:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:06:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:11:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:16:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:21:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:26:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:31:05] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:36:06] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:269)",“command”:“mautic:emails:send”,“message”:“Connection could not be established with host email-smtp.ap-southeast-1.amazonaws.com :stream_socket_client(): unable to connect to tcp://email-smtp.ap-southeast-1.amazonaws.com:465 (Connection refused)”}
[2021-04-17 06:41:32] console.ERROR: Error thrown while running command “mautic:emails:send”. Message: “Connection to tcp://training.andonpokayoke.com:465 Timed Out Log data: ++ Starting Swift_Transport_EsmtpTransport !! Connection to tcp://training.andonpokayoke.com:465 Timed Out (code: 0)” {“exception”:"[object] (Swift_TransportException(code: 0): Connection to tcp://training.andonpokayoke.com:465 Timed Out\nLog data:\n++ Starting Swift_Transport_EsmtpTransport\n!! Connection to tcp://training.andonpokayoke.com:465 Timed Out (code: 0) at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Plugins/LoggerPlugin.php:124, Swift_IoException(code: 0): Connection to tcp://training.andonpokayoke.com:465 Timed Out at /home/pusatjua/training.andonpokayoke.com/mautic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:166)",“command”:“mautic:emails:send”,“message”:“Connection to tcp://training.andonpokayoke.com:465 Timed Out\nLog data:\n++ Starting Swift_Transport_EsmtpTransport\n!! Connection to tcp://training.andonpokayoke.com:465 Timed Out (code: 0)”}

Are you using SMTP or API?
Because 465 is the SMTP channel. And you prev settings showed API.

Hi @joeyk currently i am using API. I tried the smtp setting, but the connection test failed. I returned to the API settings.

And today’s notification
image

Current error log

If Mautic tells you, that email failed, it’s due to campaign setting usually, not a Configuration issue. There is something messed up in the campaign editor.