# Need Help Mautic Installation On AWS- SES

**URL:** <https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949>\
**Category:** Product Support\
**Tags:** discussion, mautic-3\
**Created:** [April 11, 2021, 1:24am UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949 "2021-04-11T01:24:13Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 11, 2021, 1:24am UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/1 "2021-04-11T01:24:13Z")

</div>

**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](http://mautic.training.andonpokayoke.com)\r\nReferer: [http://13.213.7.72:80/console/\r\nUser-Agent:](http://13.213.7.72:80/console/%5Cr%5CnUser-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](http://mautic.training.andonpokayoke.com)\r\nReferer: [http://18.139.199.194:80/console/\r\nUser-Agent:](http://18.139.199.194:80/console/%5Cr%5CnUser-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](http://mautic.training.andonpokayoke.com)\r\nReferer: [http://18.138.27.229:80/console/\r\nUser-Agent:](http://18.138.27.229:80/console/%5Cr%5CnUser-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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue \>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue \>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue \>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com) \<\< [250-email-smtp.amazonaws.com](http://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](mailto: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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n\>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n\>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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](http://email-smtp.amazonaws.com) ESMTP SimpleEmailService-d-XS92JBFP9 B9XNUOuitZ7MxU1Q6Mue\r\n\n\>\> EHLO [mautic.training.andonpokayoke.com](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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](http://mautic.training.andonpokayoke.com)\r\n\n\<\< [250-email-smtp.amazonaws.com](http://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:

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 12, 2021, 8:51am UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/2 "2021-04-12T08:51:31Z")

</div>

> [@led.dhany](#):
>
> [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: "

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.

---

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 18, 2021, 8:25am UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/3 "2021-04-18T08:25:05Z")

</div>

Thank you @joeyk

I’ve succeed move out from sandbox.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c488e50ebc29ae2ca2624eac0bb4d764e4ddaa48.png)

I am using SES API with success test connection

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/d/d4c36994efb401826dc71cdbe6c1d7d391ae4c08.png)

And Success for Send Test Email

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/7/77dc9380d3076972cad71cf24e3ba904110649d7.png)

Here the Amazon SNS setting

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/3625b92ee7d0d21f96be15970df7c57b5dbdf60d.png)

And Amazon SES Notification Setting

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c0de9cc654a70fd2936b16880b80d576be4526f2.png)

And success for Channel Email \> send example

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/cc9d316f3f9816605360a81af4abee4f544bc228.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/393dc19d633a71c2d42d14654ae9a5c03f7e16db.png)

But, I still have problem sending campaign from mautic.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/2f272faea8f9f346aa04261bb493692b49c260b9.png)

Here is my cronjob

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/28d3145f8d13466c79cb7146be8b24f34c658d64.png)

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](http://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

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/7/7ae35770976029e07105f3944773fb834b513ea8.png)

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 18, 2021, 3:29pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/4 "2021-04-18T15:29:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 18, 2021, 8:21pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/5 "2021-04-18T20:21:05Z")

</div>

HI

I am still have failed notification  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/a/a24ef8d87b262a4b85a5c2a94d7cd744c4acb946.png)

Here How the email handled

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/5524ee52ba5c892f6dd25795cc5848404dd9577e.png)

Here the contact segment (3 contacts)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/eaa7b614b0644849f971813e5ee83dfb22389940.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/8/8248da62928f1bc4580ace9c68105b40d5535c13.png)

Here the campaign

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/b/b42efa99b368afed0ad6bf7f68a04d8de99e8529.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/3f511fdb1e9f2476a983201dd9db3058a2637e7c.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/4151aa8b067c140264022be370a601a155922167.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/61835fa295272697186f3b21595acb4f761d2e97.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/3f1a3842b65a2b69629caa2d9cdf62d9e19575a3.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/a/abc4a3f91f7dd4785ec960007db57c99d4d3badb.png)

And here the spool folder

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/48d539801dee7531fc2f1dcbdb77a10a29b8a389.png)

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](http://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](http://training.andonpokayoke.com)’.”},“type”:“AmazonSnsSubscriptionSucceeded”}   
[2021-04-18 03:14:14] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload

---

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 18, 2021, 10:24pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/6 "2021-04-18T22:24:38Z")

</div>

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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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)"}

---

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 18, 2021, 10:25pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/7 "2021-04-18T22:25:25Z")

</div>

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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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](http://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)”}

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 19, 2021, 1:54pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/8 "2021-04-19T13:54:49Z")

</div>

> [@led.dhany](#):
>
> 465

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

---

<div class="post-metadata">

**Author:** ![led.dhany](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/led.dhany/32/486_2.png) [@led.dhany](https://forum.mautic.org/u/led.dhany)\
**Post date:** [April 19, 2021, 8:16pm UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/9 "2021-04-19T20:16:37Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/7/76031f52b43823553308d99704c934a1d236b190.png)

Current error log

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/7/762d48650ecfd50fc555d054b469c4e3385443d4.png)

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 20, 2021, 6:44am UTC](https://forum.mautic.org/t/need-help-mautic-installation-on-aws-ses/18949/10 "2021-04-20T06:44:31Z")

</div>

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.