Email Not Fetching New Mail

[Mike The KID]

Hi

I am running the opensource version of SugarCRM on a LAMP platform. I've ran into some curious bugs that I can't figure out and I'm hoping someone out there will have an idea what is going on.

From what I can tell, SugarCRM is not fetching any new mail. In my account I can setup and test my mail settings. Sugar will go through my folders and retrieve any mail in the folders. I can send mail. My email test settings and select folder buttons work and communicate with my email. But new mail will never appear in SugarCRM. I've tried the Check for New Mail Now button. I've tried setting the automatically check for mail every 5min and waited. The only way to get new mail into Sugar is to change a mail setting then SugarCRM will refresh the headers and the new mail will appear. Any clues what is going on?

Another problem that I think is associated to the fetching of new mail is I want a new Case to be created to any email sent to my support email not they're not being created. Do I need to load the teams module for new cases to automatically be created off of new mail or is this also tied to problem of sugar not fetching new mail??

My email host is Google.

Thanks!

Mike

[Mike The KID]

Problem Update

I've discovered that if I right-click on my inbox folder and do a synchronize then sugar will properly sync with my google mail. Check mail still will not work. Doing a sync every time unfortunately isn't a feasible; sync-ing when there's only 10 emails in the folder isn't bad, just a couple of seconds. Sync-ing to 10,000 message takes about an hour.

Does anyone know why sugar using the IMAP protocol wont fetch new mail from google???

[Mike The KID]

Another update

I'm wondering if my email troubles are related to the scheduler? When I was in the scheduler I noticed a warning complaining about not having the cURL libraries. So i installed those and then sugar was telling me to add the following line to my crontab:

Add this line to your crontab:
* * * * * cd /var/www/sugarcrm; php -f cron.php > /dev/null 2>&1

I did that and I noticed that my check email job now had a job log and a status of in progress. But it's had that status for over 15min now. It shouldn't take that long to check emails should it? Any ways when I check my personal email Sugar still isn't picking up any new mail. The only way still remains in Sugar to get new mail is to do a sync.

Is there anyone even out there reading my posts???

[skuliaxe]

I´m reading your post

Having a similar problem, but with a group email. For a month now the group email has been working. But all of a sudden yesterday, no new mail is gathering in the mailbox. I am the only system admin and there have not been any changes to the Sugar code.

I removed the group mail and re-added it. The the mail synchronized with the missing mails, and I can send emails, but still no new mail is being fetched to the mailbox.

[Mike The KID]

Hi

There were many issues that I had to resolve in order for mailboxes and the scheduler to work correctly.

1. I had to install the cURL libraries
2. I had to use a full path to the cron.php in order for the scheduler to work
3. My machine time wasn't correct. This one gave me the hardest time trying to figure out. But once i realized that my machine was 8 hours ahead of real time, it made sense that i could fetch new mail from yesterday but i wouldn't get new mail from today.
4. I can't confirm this but I'm pretty sure that individual emails run on their own and not through the scheduler. But group emails run through the scheduler.

I think those were all of the real issues that I had. Once I figured out that those were my issues things have been running fine. So most of my issues were linux in nature not purely sugar. Were there any system changes recently? Does the scheduler log show any attempts to run your jobs? Does your system have the correct date and/or timezone?

[skuliaxe]

No windows updates, have been turned off since the Windows setup a year ago (if it ain't broke, don´t fix it).

1) I had to install the cURL libraries
-- Is this a linux related issue? In my php.ini the the CURL is enabled. Also, the scheduler has been working.

2) I had to use a full path to the cron.php in order for the scheduler to work
-- Where did you need to do that?

3) My machine time wasn't correct. This one gave me the hardest time trying to figure out. But once i realized that my machine was 8 hours ahead of real time, it made sense that i could fetch new mail from yesterday but i wouldn't get new mail from today.
-- My server time is correct

4) I can't confirm this but I'm pretty sure that individual emails run on their own and not through the scheduler. But group emails run through the scheduler.
-- That would be correct. All my personal mails are working.

I did find this in my LOG from around the time the issue started, could it be related.:
03/03/10 09:43:25 [8116][1][FATAL] IP Address mismatch: SESSION IP: xxxxxxx CLIENT IP: xxxxx
03/03/10 14:24:54 [8116][...][FATAL] Error: Query limit of 1000 reached for Emails module.
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT
03/04/10 14:14:03 [8116][-none-][FATAL] TIMEZONE:NOT DEFINED-GMT

I have checked, but all users, admin have a Time Zone set and the Server time is correct.

[Mike The KID]

1. Yes, I am on a Linux platform so the cURL libraries were probably just a linux issue
2. I had to reference the full path to the cron.php in my linux crontab configuration. If you're windows I don't know if it's the same for you.

I've only been using sugar for about a month now, so I'm not really an expert and I'm at a loss as to what your probably could be. The first entry of you log does seem a little curious. Did the IP of your mail server change at all? Or the mail protocols? I know in the latest version of sugar they're only supporting IMAP and no longer support POP3.

[skuliaxe]

1. Yes, I am on a Linux platform so the cURL libraries were probably just a linux issue
2. I had to reference the full path to the cron.php in my linux crontab configuration. If you're windows I don't know if it's the same for you.

I've only been using sugar for about a month now, so I'm not really an expert and I'm at a loss as to what your probably could be. The first entry of you log does seem a little curious. Did the IP of your mail server change at all? Or the mail protocols? I know in the latest version of sugar they're only supporting IMAP and no longer support POP3.

Thanks for your reply,

I have included a scheduled job in windows to run the cron.php. That didn´t change anything.

I have also contacted me mail server host and they confirm that nothing has changes and that I do have full access from the SugarCRM server.