Webtop migration to NS8 and failure to access mailboxes in some cases

[lucagasparini]

If manual changes have been made to the IMAP server configuration on some accounts in WebTop on NS7, after migration these accounts do not access the mailbox returning an access error after login.

This is a change that is made via the admin panel by following these steps:

• admin panel > Domains > NethServer > Users
• right click on a user > Settings > Mail > Accounts
• change the "Server" field

For example, an attempt may have been made to connect the user to a different IMAP server and then set the initial value back to localhost.
From this moment on, this configuration becomes custom and has priority over the default settings.

In the db you can find something like this:

webtop5=# select * from core.user_settings where service_id='com.sonicle.webtop.mail' and key='host';
 domain_id  |      user_id       |       service_id        | key  |   value
------------+--------------------+-------------------------+------+-----------
 NethServer | user1  | com.sonicle.webtop.mail | host | localhost
 NethServer | user2  | com.sonicle.webtop.mail | host | localhost
 NethServer | user3  | com.sonicle.webtop.mail | host | localhost

To solve the problem, just delete all these custom configurations with this query:

delete from core.user_settings where service_id='com.sonicle.webtop.mail' and key='host' and value ='localhost';

If the change is made on migrated webtop, the module must then be restarted.

It is suggested to find a way to clean up these custom configurations before migrating if possible

[gsanchietti]

Test case 1

• Create a NS8 cluster on a Rocky Linux:

  curl https://raw.githubusercontent.com/NethServer/ns8-core/ns8-stable/core/install.sh | bash
  create-cluster rl1.leader.cluster0.gs.nethserver.net:55820 10.5.4.0/24 Nethesis,1234
  

• Install a NethServer with internal OpenLDAP and WebTop5

• Create at least one user inside the OpenLDAP, eg user1

• Access WebTop with user1, then logout and follow the steps documented inside the issue description

• Install the migration application: yum --enablerepo=nethserver-testing install nethserver-ns8-migration

• Connect the NS7 to NS8 cluster (make sure to disable TLS verification)

• Migration the mail module

• Access NS8 and execute:

  runagent -m webtop1
  podman exec -ti -u postgres postgres psql webtop5  -c "select * from core.user_settings where service_id='com.sonicle.webtop.mail' and key='host';"
  

  The output must be:

   domain_id | user_id | service_id | key | value 
  -----------+---------+------------+-----+-------
  (0 rows)
  

[nethbot]

in 7.9.2009/testing:

• nethserver-ns8-migration-1.2.0-1.1.gf482538.ns7.x86_64.rpm x86_64