Fix for the 1and1 SMTP email problem

[igmartin]

I, along with many others had been struggling to get SugarCRM CE working with 1and1 hosting and its SMTP settings.
After much chin scratching, I decide to ask 1and1 technical support if they could sort out the problem.
As I had the benefit of a clean installation on a new domain, I decided to give 1and1 full admin access to Sugar and a temporary FTP access to the domain and let them do their worst!

Anyway a big thank you to 1and1 Limited’s Technical Support as they have managed to fix the problem.

So here’s the fix:

The techies at 1and1 have commented out a line in the Email.php file and added one.
(The Email.php file can be found in: /modules/Emails/)

In Version 6.1.6 it’s line 357 and in Version 6.2.1 its line 360 which becomes:

// $mail->Mailer = strtolower($mail_sendtype);

The following line is added underneath:

$mail->Mailer = 'sendmail';


They also adjusted the SMTP server settings, to what I believe are slightly different to what I have seen documented anywhere else.
I’m based in the UK, and I believe the servers are in Germany, so some of the information below maybe country specific.


SMTP Mail Server: mrvnet.kundenserver.de
SMTP Port: 25
Use SMTP Authentication: checked
Enable SMTP over SSL or TLS?: TLS
Username: xxx@xxx.com
Password: xxxxxxxx


This set up is working for SugarCRM CE Versions 6.1.6 & 6.2.1, for me anyway. I have no idea if the added code to Email.php is detrimental to it or not, perhaps someone with the skillset can comment. I have checked the logs and found no errors being generated.

This post is written as is, in good faith and I have a working installation now that sends email, if you apply these changes and it breaks your systems I can accept no responsibility.


Regards IGM

[igmartin]

It seems I was a little quick in thinking all my 1and1 email problems were sorted. The test email work fine, but on trying to setup user email, i'm back to the old problem of 'no SMTP server found'

My take on this is the 1and1 techies fixed the Email.php file which is probably used in the test proceedure, but there is another .php file that needs the fix code added.

Anybody out there who knows which other file needs this code line added and where and how to do it ?

I eagerly await your comments


Cheers IGM

[simonmtaylor]

Did you ever find the second place you needed to edit ??

[igmartin]

Sorry Simon, No I had no feedback from anyone.

Funny I am just in the process of trying a new hosting company based here in the UK that has the option to load SugarCRM 6.2.1 as an installed option, and is extremly reasonable in price.

I will post my findings.


Regards IGM

[outwestlondon]

EUREKA!

You need to add the following code:

// $mail->Mailer = strtolower($mail_sendtype);
$mail->Mailer = 'sendmail';
if($mail->Mailer == 'smtp')

At lines 1964 and 2153, it now works fine (a big woohoo went out as the email plopped into my inbox in the office)

[igmartin]

Well done Outwestlondon,

I will file that info for later, should I wish to try 1and1 again.

I gave up in the end after finding that I couldnt get the Module Loader and the Module builder to work, it was probably all down to permissions but by then I had wasted so much time trying to get things to work correctly I passed.

Good news is that I now have a install working fine on a UK based hosting company Cloudnext which offer a 1-click install of SugarCRM CE 6.2.1, but you can upload whichever version you want, i'm using 6.2.3 for testing but will go to 6.3 once it's GA.
Anyone going this way, do a 1-click install first, and copy the cloudnext altered files into any new install of SugarCRM.

You still need to tweak some permissions and create a php.ini with date.timezone = Europe/London, but if you have been sorting a 1and1 install out this is a walk in the park. I found if you follow the installation guidlines re. permissions it works great. Something to be aware of though is, if you customise labels and rename tabs, you need to reset permissions or main tabs and drop downs go a bit flaky.

IGM

[roblaus]

Would be interesting to see how all this works out once you try to set up the scheduler. I have one hosting company here where everything works out of the box but the scheduler breaks the whole thing because there is no way to get cron.php to execute properly.

[igmartin]

I have no need for the scheduler in my install, but will try it out in the next few days and report.

IGM

[outwestlondon]

After solving the email problems and have now been able to get the email configured and sending, I am now having trouble with meeting invites, and getting error messages when sending emails (despite them sending).

Am looking into the problem and will report back on anything I find.

[Big Ali P]

EUREKA!

You need to add the following code:

// $mail->Mailer = strtolower($mail_sendtype);
$mail->Mailer = 'sendmail';
if($mail->Mailer == 'smtp')

At lines 1964 and 2153, it now works fine (a big woohoo went out as the email plopped into my inbox in the office)

Was this in addition ot the original replacement of $mail->Mailer = strtolower($mail_sendtype);
with $mail->Mailer = 'sendmail'; ?

As the line numbers you don't look right ?

I did a search for $mail->Mailer = strtolower($mail_sendtype); and found no other occurrences ?

I can send an test email from admin but when I run a test from a campaign all of the test emails just sit in the email queue?

Any thoughts?

Thanks
Alex