gmail imap trouble

[ppsm]

I have done the following:

- installed SugarCRM Version 5.5.0 (Build 6653) on my server - everything works fine sofar

- gone to my gmail account > Settings > IMAP Access: Enable IMAP. "Save changes" > logout of gmail

- back to sugarCRM, Activities > Email > Settings > Mail Accounts
I have done the following settings:

Name: test
From Name: Administrator
From Address: test@gmail.com
User Name: test@gmail.com
Password: my_gmail_password

Mail Server Address: imap.gmail.com
Mail Server Protocol: IMAP
Mail Server Port: 993
Use SSL: checked

Outgoing Mail Server: I used "Set Gmail Defaults"
Name: test
SMTP Server: smtp.gmail.com
SMTP port: 465
Enable SMTP over SSL or TLS: -- SSL --
Use SMTP Authentication?  Checked
SMTP Username: test@gmail.com
Password: my_gmail_password

Pressing "Test settings", I get the error:

Test Settings

Unable to create selectable TCP socket (4458 >= 1024)

Please check your settings and try again.

For your information, phpinfo() on my server returns this information:

PHP Version 5.2.6-1
System Linux [...]

imap
IMAP c-Client Version 2004
SSL Support enabled
Kerberos Support enabled

Is there some kind of problem in the imap module?

Should I change any setting to get this to work?

Anyone experience the same problem?

[kuske]

This bug was handled here some time ago, I think at the beginning of 2008.
As I remember it was a php5-imap issue, perhaps that one here:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=478193

[ppsm]

Hello kuske,


Thanks for your quick answer. I had seen you link in an other thread. Although I am computer literate, I am not at all familiar with the ins and outs of debian and apache.

I use a free hosting service on top of which I installed SugarCRM. I have no control what so ever over the settings of apache or over the version number of installed modules.

In practical terms, what does your link mean? Do I need to ask my hosting provider to update some module somewhere? To upgrade php? Which version of php has this problem, which one is safe? How can I solve this? Please help! SugarCRM does not make much sense for me without the IMAP email function.

[kuske]

The problem, which was present a year ago, was that some php-imap installations had a compilation bug becuase thea set the port limit to 1024.

This problem was solved by newer php-imap installation.

But, to exchange only php-imap is a real tricky thing in a hosted environment, only for real unix freaks *ups* sorry, gurus...

Perhaps you can speak with your provider, and he knows what to do.

A second possibility for that problem can be that this provider has a firewall which blocks all ports greater than 1024. A small chance for a simple solution. Here again you should speak with your provider.

[ppsm]

So, if I read you well, there could be 2 causes:

- 1/ php-imap is too old and there is a problem in it.
or
- 2/ firewall problem at provider side

Well, I found that someone else reported the same problem in September 09 on the forum of my hosting company. The debian bug does not apply as the forum owner says that his version is newer and he does not use uw-imap but courier-imap. Still the problem seems unresolved for the owner.

I will ask him about the firewall possibility.

Any other idea if the firewall thing does not lead anywhere?

[ppsm]

Reply from my hosting company:

- it is not the firewall

- this bug http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=478193
is not relevant to this problem. The administrator says that his version is newer and he uses courier-imap and not uw-imap.

- he says that it is a bug in debian that has not been yet corrected.

Could you help me? I am the only one with this problem? What can I do?

[vronp]

Same problem here.

A php script I run can see the email at Google without trouble (via IMAP).

I have the latest versions of everything php related.

[ppsm]

This is annoying.

Although the reason might be external to SugarCRM (probably the server of some module?), could someone from the SugarCRM team dig into this, please?

[Edit] I am now convinced that the problem comes from the server, not SugarCRM. In my case, the server runs debian and there seems to be a bug in debian. I use other servers that run CentOS or FreeBSD and the imap feature works perfectly.

You may test this script on your server to test if imap works correctly (change variables to your gmail login):

 <?php
 
$google_username = 'test@gmail.com';
$google_password = 'password'';
 
$res = imap_open('{imap.gmail.com:993/ssl/novalidate-cert}INBOX, $google_username, $google_password);
 
if($res) {
   echo "Connecting to mail server ... DONE";
   imap_close($res);
} else {
   echo "Connecting to mail server ... FAILED<BR>";
   echo "Cause: ". imap_last_error();
}
 
?>  

[vronp]

Well, I am running CentOS and I just can't get IMAP to work.

It works great with Angel's test script but not Sugar.

Getting these in the logs:

I-E testing string: {imap.gmail.com:993/service=imap/notls/novalidate-cert/srt/secure}INBOX
Wed Jan 13 11:08:28 2010 [1714][d2a3d738-3d7d-7780-f5c3-4b49bf8200ee][DEBUG] 1: I-E failed using [{imap.gmail.com:993/service=imap/notls/novalidate-cert/sec/secure}INBOX] - error: Connection failed to gmail-imap.l.google.com,993: Connnnection timed out
Wed Jan 13 11:08:28

Also, and I find this interesting, I can select the Monitored Folders Select button and it pops up a window with my Gmail choices. So, I am connecting to Gmail and authenticating !!!

So, why is it timing out?

[sandaramu]

Hello

I´m facing similar issues trying to set up a gmail account.

After switching to Debug mode and running Diagnostic tool , this is what sugarcrm.log shows:

Wed Mar 10 12:27:45 2010 [21947][1][DEBUG] 7: I-E failed using [{imap.gmail.com:993/service=imap/ssl/notls/novalidate-cert/secure}INBOX] - error: Can't connect to gmail-imap.l.google.com,993: Connection refused.

I´ve previosly tried using POP3 settings for gmail, as well as the default configuration for smtp for gmail, properly selected SSL for both incoming and outgoing servers. But, similar message Connection refused.


My SugarCRM instance is hosted in a hosting provider server.
Versión de Apache 2.2.14
Versión de MySQL 5.1.30
Versión de PHP 5.2.9
Versión de Perl 5.8.8
Versión del Kernel 2.6.28.9
SugarCE 5.2.0k

Could these gmail connection problems be related to some phm_mailer config or installation problems?

Does any body know a work around for this issue?