External e-mail fails after upgrading 2.0->2.2

[trym@…]

After migrating from 2.0 to 2.2 external e-mail fetching does not work.

The "usercorner/External e-mail retreival"-page (for any user) gives this error message: "An internal error has occurred. This is most probably a bug, relevant information can be found in the logs. Please look for the details in the /var/log/zentyal/zentyal.log file and take a minute to submit a bug report so we can fix the issue as soon as possible."

In /var/log/zentyal-usercorner/zentyal log there's this message:

ERROR> ExternalAccounts.pm:259 EBox::Mail::Model::ExternalAccounts::row - Unknown mail protocol: xxxxxxxx

"xxxxxxxx" in this case was the actual password of one of the user's POP-accounts.

Attaching all 4 logs from a newly migrated machine where usercorner has been installed and one user has logged into usercorner and tried to access "External E-mail Retreival."

[trym@…]

Zentyal 2.2 usercorner-log

[trym@…]

Zentyal 2.2 usercorner-log

[trym@…]

Zentyal 2.2 usercorner-log

[trym@…]

The ticket system claims I'm spamming when trying to upload access.log. Will try later.

[trym@…]

By comparing configuration-backups from a non-working (migrated) and a working (fresh install) 2.2, you can find the error in users.bak/master-data.ldif. (The configuration backup from the faulty server cannot be restored either btw., but that's a another bug <sigh>.)

The working version specifies

fetchmailAccount: <account_name>:pop3:<mail-server>:<port>:<password>

while the migrated version still has

fetchmailAccount: <account_name>:<password>:pop3:<mail-server>:<port>:1

[jamor@…]

Hello Trym,

I attach a migration script. It has been tested only with synthetic data make a backup before running it.

Please run it and tell us whether it has worked for you.

[trym@…]

Thanks. Seems to work on a copy of a small server (~10 external accounts). Have not tested on a production server, so have not tested if fetching actually works (cannot risk messing up any real mail), but at least the usercorner does.

[jamor@…]

You are welcome, Trym.

If you have any issue with the script, please reopen the ticket.