Campaign mail & schedulers problems

[oxofi]

Hello,

I’m working on suitecrm 8.0.4 on a ubuntu-server docker image.

So, i’ve configured outbound email, inbound emails, personal email account, campaign emails (from my OVH smtp), i can send emails and read them, but i’m not able to create a campaign that really send emails.

I’ve tried to configure crontab for www-data user, to run the mass mailer and other schedulers, but the command is never executed.
Instead of www-data, i’ve tryed to run the schedulers on root user, and i have the same problem : Cron’s not automatically executed and the only moment when the scheduler is executed it’s when i do it myself manually.

So, that’s not really my biggest problem because when i’m tryin to send queued mails (or test mail, campaign…), no email was send / received.

Nothing in syslog and i don’t know what log file may help me in suitecrm directory.

Scheduler mass mail :

Please, help me !

Thanks.

[oxofi]

I’m back !

I have solved my cron issue, he wasn’t running, after using command “service cron start”, it’s done !

But the “Last Successful Run” field doesn’t move, he’s updated when mail are send ?

I’m working on the other issue, but still doesn’t work, no informations in logs.

I dont understand why no test email is send.

[pgr]

Have you seen this article?

Scheduler Jobs in SuiteCRM in Linux - the Definitive Guide

[oxofi]

Hello, thanks for reply.

i have read this article and cron job is not a problem anymore or maybe i don’t know it yet.

My main problem now is that no emails is send (for test mailing and the campaign mailing).

[pgr]

Some of the things in the article - about which user the job runs under - are probably relevant.

First you have to get to a point where you know the jobs execute, and you see a “last ran successfully” time that is recent, and in the correct timezone.

Then you can look into what is happening when the jobs execute. Maybe try a brand new campaign to see what happens. Sometimes the issues with campaigns are about repeated sends do the same addresses; until you really understand the logic used by the app (not always obvious) you might be testing things wrong.

[oxofi]

Thanks for the reply (again).

After some work, i’m now on the correct timezone, suitecrm configuration file is correctly set up with the user www-data, chmod & chown are correctly set, cron jobs is set to www-data and the command run correctly and i have a “Last ran successfully” that is recent and with the good timezone.

I’ve created another campaign, with test list, new target email for test and from another provider (laposte.net instead of gmail), and still nothing in inbox (or spam or wathever).

I’ve checked logs of php and suitecrm, nothing in.

I’m out of idea.

[pgr]

The relevant email account is the one defined in Admin / Outbound email / system account

Check that your system can send other emails, for example, record assignment emails.

[oxofi]

The outbound email is correctly setup and i receive assignment emails (just tested it).

[vijay1992]

Hi,
Please check out our video it may help you: Email Campaign

[oxofi]

I’ve seen this video before, i watched the video again and followed instructions once more and guess what ? Nothing in mailbox (i’m going crazy).

My shedulers run smoothly, that’s my day saver.

Here’s logs on today :

Tue Apr 12 06:17:51 2022 [11416][1][FATAL] Error: File [modules/SavedSearch/metadata/editviewdefs.php] is missing. Unable to create because no corresponding HTML file was found.
Tue Apr 12 06:17:57 2022 [11416][1][FATAL] Error: File [modules/SavedSearch/metadata/editviewdefs.php] is missing. Unable to create because no corresponding HTML file was found.
Tue Apr 12 06:18:06 2022 [2255][1][FATAL] Error: File [modules/SavedSearch/metadata/editviewdefs.php] is missing. Unable to create because no corresponding HTML file was found.

[pgr]

Problem with "Email" field in the email templates for WebToPerson forms

If you uncomment this line: https://github.com/salesagility/SuiteCRM/blob/master/include/SugarPHPMailer.php#L457 you will see more information in your logs (st them to DEBUG level in Admin/System settings). And also here https://github.com/salesagility/SuiteCRM/blob/master/include/SugarPHPMailer.php#L497-L502 if you un-comment that, you will get a full SMTP log in suitecrm.log. You can see what the email server is complaining about.

These instructions will get you a lot of extra logging. This should help determine…

• if the code is getting the point where it attempts to send the email

• if that attempt is failing, why it is failing

Also, keep an eye on a couple of database tables, they might shed some light on this issue: emailman and campaign_log

[oxofi]

There’s a lot of log, so i’m testing and found that :

Tue Apr 12 10:41:19 2022 [2290][-none-][DEBUG] Unable to find SugarController:: EmailManDelivery
Tue Apr 12 10:41:19 2022 [2290][1][WARN] Confirm Opt in is disabled in email settings
Tue Apr 12 10:41:19 2022 [2290][1][WARN] Email Address was sent due to not being confirm opt in REDACTED@laposte.net

I just tried to send a test mail.

I dont know what to search, i’m will come back and edit my message to add more logs.

Edit :

The mass mailer was executed and i found some logs with error / warnings that seem to be close to my problem :

Tue Apr 12 16:59:02 2022 [13904][1][INFO] ----->Scheduler fired job of type pollMonitoredInboxesAOP()
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Using system default ImapHandler. Hint: Use any ImapHandlerInterface as dependency of InboundEmail
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] ImapHandlerFactory will using a ImapHandler
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Query:SELECT id, name FROM inbound_email WHERE is_personal = 0 AND deleted=0 AND status='Active' AND mailbox_type != 'bounce'
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Query Execution Time:0.00049090385437012
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Just got Result from get all Inbounds of Inbound Emails
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] In while loop of Inbound Emails
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Using system default ImapHandler. Hint: Use any ImapHandlerInterface as dependency of InboundEmail
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] ImapHandlerFactory will using a ImapHandler
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Hook called: InboundEmail::before_retrieve
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Retrieve InboundEmail : SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '900357e0-2316-3abd-65b1-6224c69a4c9c' AND inbound_email.deleted=0
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Limit Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '900357e0-2316-3abd-65b1-6224c69a4c9c' AND inbound_email.deleted=0 Start: 0 count: 1
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '900357e0-2316-3abd-65b1-6224c69a4c9c' AND inbound_email.deleted=0 LIMIT 0,1
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Query Execution Time:0.0003359317779541
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Hook called: InboundEmail::after_retrieve
Tue Apr 12 16:59:02 2022 [13904][1][WARN] Request ssl value not found.
Tue Apr 12 16:59:02 2022 [13904][1][WARN] Requested folder is not defined
Tue Apr 12 16:59:02 2022 [13904][1][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Apr 12 16:59:02 2022 [13904][1][ERROR] ImapHandler trying to use a non valid resource stream.
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Connected to mail server id: 900357e0-2316-3abd-65b1-6224c69a4c9c
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Trying to connect to mailserver for [ OVH ]
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Connected to mailserver
Tue Apr 12 16:59:02 2022 [13904][1][WARN] An Imap error detected: "IMAP search error"
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] -----> getNewMessageIds() got 1 new Messages
Tue Apr 12 16:59:02 2022 [13904][1][INFO] Resolving job 3440daa2-6de9-1270-5155-6255931eaf30 as success: 
Tue Apr 12 16:59:02 2022 [13904][1][DEBUG] Hook called: SchedulersJobs::before_save