1

Topic: after migration by updating tables to iredadmin pro getting error

Hi,

I have migrated my data from old iredadmin 0.9.8 to 0.9.9 and done below steps mentioned on link:

1.copy all mailboxes (in Maildir format) to new iRedMail server with tools like rsync.
2.Set correct file owner and permission of mailboxes. Default owner is vmail, group is vmail, permission is 0700.

With SQL backends, you can get full maildir path of user with below SQL command:

mysql> USE vmail;
mysql> SELECT CONCAT(storagebasedirectory, '/', storagenode, '/', maildir) FROM mailbox WHERE username='user@domain.com';


after that I have updated mysql structure suggested here :

https://docs.iredmail.org/iredmail.releases.html

Version    Release Date    Upgrade tutorial    Comment
0.9.9    Dec 17, 2018    Upgrade from iRedMail-0.9.8    Contains SQL/LDAP structure change

https://docs.iredmail.org/upgrade.iredm … 0.9.9.html


https://docs.iredmail.org/upgrade.iredm … db-special

but I am  getting below error once I move vmail db to new iredadmin pro version and domains and migrated email ids not showing in domains and accounts option


Error: OperationalError(1054, "Unknown column 'maillists' in 'field list'")

Thanks

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: after migration by updating tables to iredadmin pro getting error

You missed SQL structure change introduced in iRedMail-0.9.8:
https://docs.iredmail.org/upgrade.iredm … l-database