Check Inbound Mail scheduler item fails

[stephen.bass]

O/S - Ubuntu Server 7.04
Sugar Suite Version 5.0.0a
Webserver - Apache/2.2.4 (Ubuntu)
PHP version - 5.2.3
MySQL server version - 5.0.45

I migrated our Sugar 4.51d installation from one of our webservers (Red Hat EL3, MySQL4.1.20, PHP 4.3.9) to a local webserver for testing the upgrade to 5. I created a dump of the database (mysqldump --opt <database> <filename>), and transferred the entire directory over to the new server, creating a new local database from the dump and then changing config.php to reflect the new local database. I was then able to login to sugar, repair the existing database and then work normally. The local server is accessed via a dyndns alias, and web requests to the test server are sent through the router via port forwarding on a non standard port - ie http://testbox.dyndns.com:#####/sugarcrm/

After using the upgrade wizard to upgrade to 5, and then running all repairs. I had to recreate all of the inbound email accounts due to a certificate error. We are using POP to pull the mail from our mail servers. The problem that I'm now having is that the Schedulers: Check Inbound Mailboxes job, which is set to run the function:ollMonitoredInboxes every couple of minutes. It seems to work fine for a while, but then eventually fails with the following written to the error log:

Thu Feb 7 09:51:59 2008,405 [5172] FATAL SugarCRM - MySQL error 1048:
Thu Feb 7 10:00:07 2008,467 [5195] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 10:00:49 2008,679 [5190] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 10:12:12 2008,582 [6104] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ supports5 ].
Thu Feb 7 10:18:12 2008,884 [6125] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ supports5 ].
Thu Feb 7 10:20:17 2008,595 [6131] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ Support ].
Thu Feb 7 10:26:03 2008,698 [5178] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:08:47 2008,429 [5179] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:10:50 2008,700 [5182] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:33:34 2008,278 [5211] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:49:18 2008,605 [5189] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:49:28 2008,565 [5189] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 11:49:28 2008,567 [5189] FATAL SugarCRM - Error fetching relationship from cache schedulers_modified_user_id
Thu Feb 7 11:49:29 2008,254 [5189] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by
Thu Feb 7 12:14:59 2008,284 [5217] FATAL SugarCRM - MySQL error 1048:
Thu Feb 7 12:29:17 2008,396 [6572] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ Support ].
Thu Feb 7 12:29:33 2008,146 [6572] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 1c18695c-7c3d-c249-431f-47ab2621e661 ]. Skipping mailbox [ Web Leads ].
Thu Feb 7 12:30:53 2008,756 [6575] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 1c18695c-7c3d-c249-431f-47ab2621e661 ]. Skipping mailbox [ Web Leads ].
Thu Feb 7 12:33:17 2008,452 [6584] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ Support ].
Thu Feb 7 12:38:17 2008,855 [6599] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ Support ].
Thu Feb 7 12:43:24 2008,865 [6624] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4d47df58-ac88-7eb8-9046-47aa13d4bbfb ]. Skipping mailbox [ Support ].
Thu Feb 7 15:45:48 2008,818 [5194] FATAL SugarCRM - Error fetching relationship from cache schedulers_created_by

The following line was added to /etc/crontab

* * * * * root cd /var/www/sugarcrm; php -f cron.php > /dev/null 2>&1

Now none of these accounts are set to use IMAP, or ever were for that matter - we've always used POP and had no issues with it on 4.5.

Any advice on how to fix this would be appreciated.

[vdhyani]

Did you try Rebuild Relationship from Admin yet ?
* Log into application as Administrator
* Go to Admin panel
* Run Repair -> Rebuild Relationships

[bingnet]

I too have this problem. I have the usual "I've tried everything syndrome" and would really like to know how to make this issue louder, more visible, etc... How can we get some attention on this issue, it's such a show stopper!

Edit: Upgraded to Version 5.0.0e (Build 3276), this is still an issue.

When I run:
root$exec -a www-data /usr/bin/php /var/www/sugarcrm/cron.php

./sugarcrm.log reports:
Mon May 19 13:45:54 2008,441 [5067] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 7fe75ec2-59e2-160e-88d2-482d5555145d ]. Skipping mailbox [ Support ].

LAMP stack running:

$cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=8.04
DISTRIB_CODENAME=hardy
DISTRIB_DESCRIPTION="Ubuntu 8.04"

$uname -a
Linux veiorcrm04 2.6.24-16-server #1 SMP Thu Apr 10 13:58:00 UTC 2008 i686 GNU/Linux

$apache2 -v
Server version: Apache/2.2.8 (Ubuntu)
Server built: Feb 2 2008 04:03:01

$mysql -V
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

$php -v
PHP 5.2.4-2ubuntu5 with Suhosin-Patch 0.9.6.2 (cli) (built: Feb 27 2008 20:43:54)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

[webnom]

Agree, this issue IS a real show stopper and makes so much of Sugar unusable for us.
I'm hoping there's a fix somewhere.
Kenneth.Thorman has posted a fix here for 5.0.0e but it has not solved my cron.bat not running schedulers issue. (http://www.sugarcrm.com/forums/showt...7&page=3&pp=10)

Someone, Anyone?