Import of e-mail fail...🙀

Those are not giving 500 errors, are they? Do you have any FATALs? Either in php_errors.log or suitecrm.log

Hi @pstevens, @pgr, @ankitmodi89
That is the php_errors.log (The screenshot).

Here is the sugarcrm.log:

I can see in that log entries mentioning issues with both connecting to SMTP and Imap. Never had these issues before or prior to this update 7.12.4. Everything worked flawlessly. :sob:

This update has really destroyed my system. Its the update from hell. I no longer can email from the production system:
image

This is also confirmed when you attempt so send a test email:
image

And we have done nothing of changes on this CRM instance.
We only ran the upgrade 7.12.4. and then hell broke lose.

Your email errors are telling me you cannot connect to your IMAP server. Check your credentials and see if you can do a connection test.

Also there’s this:

Also I’ve found the “ssl” dropdown, while does save, does not repopulate when you re-save. So you have to make sure it’s entered every time before you re-save.

Hi.
Already done that the outcome is this when sending test email which does confirm your theory about email accounts:

250-AUTH LOGIN
250-SIZE 40960000
250-HELP
250-AUTH=LOGIN
250 CLIENTID

1: CLIENT -> SERVER: AUTH LOGIN

2: SERVER -> CLIENT: 334 VXNlcm5hbWU6

1: CLIENT -> SERVER: ---obfuscated---
2: SERVER -> CLIENT: 334 UGFzc3dvcmQ6

1: CLIENT -> SERVER: ---obfuscated---
2: SERVER -> CLIENT: 535 Invalid Username or Password

1: SMTP ERROR: Password command failed: 535 Invalid Username or Password

3: SMTP Error: Could not authenticate.
1: CLIENT -> SERVER: QUIT

2: SERVER -> CLIENT: 221 Service closing transmission channel

However all email accounts where working before the update/upgrade to 7.12.4.
It doesn’t make any sense at all the ALL email account’s passwords has been automatically changed or wiped out of the database.

I changed the password / added it back on one account so far, and it did work it seems.

Still the email bulk import function is failing and I looked in every server log so far I could find (Apache, php, Plesk etc.), not to no avail.

Yes, that was reset to none too by the upgrade process to 7.12.4.
Really weird. :thinking:

It’s not actually set to none. In the DB it actually is “ssl” but if you look on the front end, it always says “none”. If you happen to re-save without changing to “ssl” it will in fact change it back to none. It’s a bug, you just have to remember to change it to SSL each time you save.

Hy stevens, SuiteCRM still have no Connection to the IMAP Server for Inbound E-Mails.
I changed the SSL and saved again but i got no connection after the update. It only says loading after i have clicked “Test connection”

It happens after the Update - i does not change anything else.

Du you have any solution for that?

Gif video below is from our test CRM system instance. Same issue is replicated in live production environment too.
video_01
Well the issue still exists. Reviewing the server and PHP logs etc. has not really helped in finding the culprit of this issue. Everything worked fine until this update/upgrade to 7.12.4. where this issue stems from.

Any idea/suggestion that might lead to fixing this issue is very appreciated.

Kind regards

You can find further info on the SSL issue here;

I can assure you it does work in 7.13.3 here’s a screen shot.

One tip: ensure you can connect by using the “select” buttons to check for the folders. If this is successful, you are connected and don’t have to “test connection”.

You might want to try selecting the SSL option, saving, then going back in.

This will confirm your connection is working…

However, I’ve tested importing records while I was at it , and you are correct it does not work.

SOLUTION:

Switch back to PHP 7.4 and it works.

I think this is the actual PHP error:

[21-Aug-2023 14:54:57 UTC] PHP Warning: Undefined array key “Emails2_EMAIL_offset” in /home/pablostevens71/public_html/suitecrm7.igosalesandmarketing.com/modules/Emails/include/ListView/ListViewDataEmailsSearchOnIMap.php on line 125

1 Like

Hi @pstevens
Thanks for the feedback. I appreciate that. :+1:

Ok, I can confirm that reverting back to PHP version 7.x.x does “solve” the issue.
video_01


But that of course leaves the CRM system more vulnerable to attacks from hackers, script kiddies etc. So it not the best option either in regards to security.
Also SuiteCRM does state that PHP version 7 is now unsupported.
So its really “pick your poison” here.

There still seem to be a lot of things like this everywhere with PHP 8. I try and stay on PHP 7.4, it’s way more stable.

1 Like

Thanks you very much for your invaluable help @pstevens with resolving and finding the culprit of this issue.

It is very appreciated! :facepunch:

Kind regards

Dear Stevens, i am on 7.4.33 but i do not get any connection to my IMAP Folder. Do you have any tipps for me?

What is the error message that you receive when you do the connect test on the email account? :thinking:

It only says “Loading” … the Connection to the SMTP Server is ok. But the connection to IMAP does not work

After a few minutes it says Ca not autheticate to IMAP: Wrong startup greeting
2023-08-25 16_04_51

Do you have IMAP php extension enabled on your server?

ye


s i do