Inbound E-mail WAS working before 4.0.1

[dwten]

I'm running SugarCRM open source 4.0 under XAMPP and Windows XP. I had Inbound e-mail working like a charm. After upgrading to 4.0.1 the cron schedule task that runs the bat file doesn't output anything to the console anymore and e-mails are not being poll.

Now nobody in the office believe in Open source solutions anymore.....

DT

[sugarchris]

Just like how close sourced items like Windows XP are 100% out of the box, right? A little perspective goes a long way.

If you take a look at the Check Inbound job, is there anything in the Job Log?

[dwten]

Yes, there are jobs there and all of them have completed status and up to date. I was monitnoring the cron process and it runs everytime, the only thing is that when the command windows pops up it doesn't show anything after executing the cron.php script (it use to list a long output on 4.0.0).

I rebooted the machine and it just pull in 100 messages, but again, after that is not pulling messages anymore
And then it started working again.....who knows???

Windows XP fault? Xampp??.... whatever, thanks for your response....

DT

[sugarchris]

Hi DT,

Which version of XAMPP? I'd like to replicate your problem. We did have a weird issue with 1.5.1, where the code I put in to deal with potential DDoS type attacks was failing with no reason (failing and never running a job). Once disabled, everything worked as intended.

If you are on that version of XAMPP and using PHP 5.1.1 (I think that's the version that comes with it), I would recommend commenting out some code, from /cron.php:

 ///////////////////////////////////////////////////////////////////////////////
////    EXECUTE IF VALID TIME (NOT DDOS)
 
 
 
if($timestamp[0] < strtotime(date('H:i'))) {
    write_array_to_file('timestamp', array(strtotime(date('H:i'))) , $cachePath.'/'.$pid);
    require('modules/Schedulers/Scheduler.php');
    $s = new Scheduler();
    $s->checkPendingJobs();
} else {
 
 
 
}
sugar_cleanup(true); 
  

to:

 ///////////////////////////////////////////////////////////////////////////////
////    EXECUTE IF VALID TIME (NOT DDOS)
 
 
 
//if($timestamp[0] < strtotime(date('H:i'))) {
    write_array_to_file('timestamp', array(strtotime(date('H:i'))) , $cachePath.'/'.$pid);
    require('modules/Schedulers/Scheduler.php');
    $s = new Scheduler();
    $s->checkPendingJobs();
//} else {
 
 
 
//}
sugar_cleanup(true); 
  

Hope this resolves any linger issue!

[dwten]

Haven't tried that yet. But this is what I found so far:

I left the system up since the Friday reboot, everything worked fine during the weekend. All e-mails where pulled in. But this morning when I came in to the office it stopped again. This is what I noticed: on the scheduled jobs for the inbound e-mail the last completed scheduled job was at 7:09 EST, but right now is 10:16 EST time. The scheduler is supposed to run every minute, what happened to all the jobs after 7:09? They were not created.... I tried running the Refresh Jobs but nothing gets generated.

Any hint?

DT

[sugarchris]

Hi DT,

What other jobs are active? There seems to be a failure happening in one or more jobs that is preventing the I-E check to run. Could you disable everything except Check-Inbound and start testing like this:

1. Send a test email, confirm it gets imported.
2. Enable 1 more job, and send another test email.
3. If you don't get the import, please let us know here so that we can further debug the issue.

Thanks!

[dwten]

Active are:

1. Refresh Jobs.
2. Check Inbound Mailboxes.
3. Run Nightly Process Bounced Campaign Emails
4. Run Nightly Process MassEmail Campaings.

I disabled 1, 3 and 4 but nothing happens.
What I noticed is that on the job log, there are no new records generated, but a record is deleted everytime I click on the Check Inbound schedule to see the log. Not even when I change the frequency from As Often as possible (1 min) to 3 min. job logs are generated (I guess is the scheduler_times table in MySQL). Will like to debug the PHP code but don't know where to look.

If I change the frequency on Refresh Jobs, a record in the Job Log is always generated......

Update.....I went out for lunch and came back. It created 1 record only at 12:00pm and pulled in 23 messages. after that is dead again, don't know when will the schedule work again.

DT

[dwten]

I think I have it, but don't know how to fix it.
The Date and Time Start / Date and Time End changes everytime cron.php is run.
I edited the schedule and set the start time to 00:00 and end time to 23:59 of 2021 and after cron is ran the start time changes to a random time and the end time to that time minus 1 minute.
Everytime I set it to 00:00 it runs, but then it is set back again to a crazy time.

DT

[sugarchris]

Ok, verified bug.

You can track it as bug 4436 on bugs.sugarcrm.com.

I'll get this fixed and issue an informal patch - if we do setup a letter patch (4.0.1a, it will be rolled into that).

Mea culpa.

I'll be posting updates and files to install in this thread: http://www.sugarcrm.com/forums/showthread.php?p=27509

[sugarchris]

Fix is now in the thread I listed above.