Cannot schedule a campaign through Amazon (certificate not recognized)

agentlink

Beginner
Jan 10, 2020
8
1
1
Hi.

I try to schedule a campaign, but it fails with server's 500 error (see attached screenshot).
There is an error in the log saying:
PHP Fatal Error: Uncaught ErrorException: Unknown: SECURITY PROBLEM: insecure server advertised AUTH=PLAIN (errflg=1) in Unknown:0

We used to have this issue before and changed openssl.cafile in PHP.ini. We even installed certificates from Amazon https://www.amazontrust.com/repository/
However, this time it didn't work. When we set to the bundle created after running update-ca-trust extract command on server, it even shows the following error, when running test email feature for the sending node:
Error executing "SendRawEmail" on "https://email.us-east-1.amazonaws.com"; AWS HTTP error: cURL error 60: Peer's Certificate issuer is not recognized. (see https://curl.haxx.se/libcurl/c/libcurl-errors.html)

Please advise here.
 

Attachments

  • Mumara error.png
    Mumara error.png
    213.1 KB · Views: 4

marfan

Beginner
Staff member
Jul 18, 2019
28
9
3
Hi @agentlink
Which server are you using? This might be issue with your certificate installation.
If you are using centos try this
  • Export company trusted root certificate with .cer extension. Somthing naming external root certificate
  • Convert the ca file to .pem file using openssl x509 -in xxx.cer -inform der -outform pem -out xxx.pem
Then on the centos:
  • Install the ca-certificates package: yum install ca-certificates
  • Enable the dynamic CA configuration feature: update-ca-trust force-enable
  • Add the exported pem files to /etc/pki/ca-trust/source/anchors/
  • Use command: update-ca-trust extract

Hope this work thanks.
 

agentlink

Beginner
Jan 10, 2020
8
1
1
Hi.
This approach did not help.
In fact, the issue is probably in another place. I see these errors in the Mumara debug log:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unsubscribe_header' in 'field list' (SQL: insert into `campaign_schedules` (`name`, `list_ids`, `campaign_ids`, `smtp_ids`, `current_smtp`, `smtp_sequence`, `sending_pattern`, `masked_domain`, `send_datetime`, `start_datetime`, `campaign_type`, `type`, `send_campaign`, `notification_email`, `hourly_speed`, `threads`, `unsub_show`, `track_opens`, `track_clicks`, `track_duplicate`, `unsubscribe_header`, `user_id`, `sender_option`, `thread_settings`, `from_attributes`, `updated_at`, `created_at`) values (Test, 1, 22, 2, 2, batch, sequential, ?, 2020-07-10 08:51:03, 2020-07-10 08:51:03, regular, subscriber, now, ?, ?, 1, 1, 1, 1, 1, 0, 2, smtp, 1, , 2020-07-10 08:51:03, 2020-07-10 08:51:03)) {"userId":2,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unsubscribe_header' in 'field list' (SQL: insert into `campaign_schedules` (`name`, `list_ids`, `campaign_ids`, `smtp_ids`, `current_smtp`, `smtp_sequence`, `sending_pattern`, `masked_domain`, `send_datetime`, `start_datetime`, `campaign_type`, `type`, `send_campaign`, `notification_email`, `hourly_speed`, `threads`, `unsub_show`, `track_opens`, `track_clicks`, `track_duplicate`, `unsubscribe_header`, `user_id`, `sender_option`, `thread_settings`, `from_attributes`, `updated_at`, `created_at`) values (Test, 1, 22, 2, 2, batch, sequential, ?, 2020-07-10 08:51:03, 2020-07-10 08:51:03, regular, subscriber, now, ?, ?, 1, 1, 1, 1, 1, 0, 2, smtp, 1, {\"unsubscribe_email\":null,\"unsubscribe_link\":null,\"unsubscribe_by_email\":null,\"from_name_list\":\"Y\",\"from_name_smtp\":\"Y\",\"from_name\":null,\"from_email\":\"\",\"bounce_email\":\"\",\"reply_email\":\"\"}, 2020-07-10 08:51:03, 2020-07-10 08:51:03)) at /home/sendy/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)

That error os logged again every time I try to schedule a campaign.
Please advise here.
 

Attachments

  • Debug Logs - Sendy 2020-07-10 17-00-00.png
    Debug Logs - Sendy 2020-07-10 17-00-00.png
    301.1 KB · Views: 2

marfan

Beginner
Staff member
Jul 18, 2019
28
9
3
Hi @agentlink
1: can you schedule camapgin?
2: Are you on latest version of mumara?
After updating to latest version if you still have this issue you can create a ticket.

Thanks
 

agentlink

Beginner
Jan 10, 2020
8
1
1
Hi
1. No. It goes through all steps and produces 500 Server Error on hitting Submit button
2. Yes
I have opened a support ticket.
 

wasif

Administrator
Staff member
Apr 9, 2019
576
112
43
@agentlink can you please advise if you were able to get the issue resolved over the support ticket?
 

agentlink

Beginner
Jan 10, 2020
8
1
1
Hi.

Yes, the issue was solved through the support ticket. The guys did some updates and it worked.

Thank you!
 
  • Like
Reactions: wasif