Upgrading to 4.5.1.e Pro gives IMAP connection logs for inbound email

[nlasse]

Hi!

After upgrading from 4.5.1d to 4.5.1e I get continous FATAL errors for inbound email:

# tail /var/www/spro/sugarcrm.log
Thu Sep 13 15:56:02 2007,040 [10350] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 203d9cc8-b8e1-abe2-daa9-4624b000ae5c ]. Skipping mailbox [ ... ].
Thu Sep 13 15:57:02 2007,072 [10350] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 24d6db39-f6b8-28b1-d9b5-46e7fa46d9a6 ]. Skipping mailbox [ ... ].
Thu Sep 13 15:58:02 2007,134 [10350] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4443f1d4-8d60-6d99-7757-46e7fc19f811 ]. Skipping mailbox [ ... ].
Thu Sep 13 15:59:02 2007,156 [10350] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 67ebfa44-8b8d-c9af-2983-46e7fe3574a5 ]. Skipping mailbox [ ... ].
Thu Sep 13 16:00:41 2007,450 [10376] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 203d9cc8-b8e1-abe2-daa9-4624b000ae5c ]. Skipping mailbox [ ... ].
Thu Sep 13 16:02:11 2007,483 [10376] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 24d6db39-f6b8-28b1-d9b5-46e7fa46d9a6 ]. Skipping mailbox [ ... ].
Thu Sep 13 16:02:51 2007,514 [10376] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 4443f1d4-8d60-6d99-7757-46e7fc19f811 ]. Skipping mailbox [ ... ].
Thu Sep 13 16:03:31 2007,535 [10376] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 67ebfa44-8b8d-c9af-2983-46e7fe3574a5 ]. Skipping mailbox [ ... ].
Thu Sep 13 16:06:22 2007,031 [10400] FATAL SugarCRM - SCHEDULERS: could not get an IMAP connection resource for ID [ 203d9cc8-b8e1-abe2-daa9-4624b000ae5c ]. Skipping mailbox [ ... ].

...etc

I have searched the forum and the wiki but not found anything which helps me. Before the upgrade, I had spurious logs like this but the inbound email did work. After the upgrade, no emails at all come in and the mail provider shuts us down after a while because it don't like what it gets from us.

Sugar edition is SugarPro.
OS is Ubuntu Linux 2.6.17-10-server #2 SMP i686 GNU/Linux
PHP 5.1.6 (cli) (built: Mar 7 2007 12:48:25)
mysql Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.1
Apache a.0.55-4ubuntu4

Any help would be greatly appreciated.


Best regards,
Lars

[nlasse]

It looks like the problem was due to mangled mail passwords. Deleteing all mailboxes and reinstalling them fixed the problem. We also changed to IMAP from POP3, because IMAP is the recommended way in SugarCRM. There is a function insode SugarCRM to repair mail passwords, but it doesn't seem to work.

[wivaku]

Seeing same issue.
Using SugarPro 4.5.1e.
Happens with both POP and IMAP.
Going to e-mail setup and using "test settings" works fine,
so does not seem to be a mangled password issue.
Tried repair -> Repair Inbound Email accounts, but no result.

[matthewboh]

I'm seeing the exact same issue - any help appreciated

[jamieb22]

Hi everyone

For those of you who are stuck on getting 4.5.1 to work with inbound email, perhaps this info will be of use to you:

I am not certain how anyone has been able to get this feature working with SugarCRM. I am equally not certain why the SugarCRM engineering team has found it so difficult to implement correctly functioning email support in their software product. Apologies, I had to dig at them about this, because it set me back three hours to fix this!

On my system, Sugarcrm seems to mangle the POP/IMAP passwords. I fixed this by editing the InboundEmail module source code. If you type:

(1) back up your SugarCRM source
(2) search for all php files containing the word "blowfish" i.e. grep -r blowfish
(3) edit each php file and delete the line containing blowfish
(4) recreate an inound email profile

Watch it work!

[johnsopaul]

I'm running 4.5.1.h community and have just upgrade to php 5. all worked well until I changed some mail settings and started getting this imap failure too. not all mailboxes were failing though and a check of the inboundemail table showed those mailboxes that were working had ::::::imap::::notls::, those not had ::::::imap::novalidate-cert::notls:: in the service field. changed them through phpmyadmin coz I couldn't see where this was being set. worked ok after but as soon as i change a profile, it get set back to the problem parm

[bingnet]

I am having this issue with v5.0.0d on Ubuntu Linux 8.04 server edition. It is a full new installation of Sugar. Everything else seems to work fine, after two days of tweaking, etc... Ajax email client has slow response time, not sure where the bottleneck is on that.

I posted here with more details: http://www.sugarcrm.com/forums/showthread.php?p=113163