1 Topic by rossi256

  • rossi256
  • Member
  • Offline
  • Registered: 2015-01-18
  • Posts: 30

Topic: upgrade or migration to new server

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Deployed with iRedMail Easy or the downloadable installer? downloadable
- Linux/BSD distribution name and version: ubuntu 14.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,
I have my mail server at
iRedMail     v0.9.8
iRedAdmin-Pro     v2.8.0 (MySQL)
ubuntu 1404

Now i want to go to the latest version, is it better to upgrade it on the same server, or migrate to a new ubuntu 1804 with latest iredmail and iredadmin?

thanks

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: upgrade or migration to new server

Either is ok, it's up to you.

If you want to upgrade in place, upgrade tutorials are available here: https://docs.iredmail.org/iredmail.releases.html

- Better upgrade iRedMail to 0.9.9 first, then 1.0.
- Running the server for few days to make sure it's working well.
- Upgrade Ubuntu to 16.04.
- Upgrade Ubuntu to 18.04.

If you want to migrate to a new Ubuntu 18.04 server, you still need to upgrade iRedMail to 0.9.9 then 1.0 first, then follow this tutorial to migrate to new server:
https://docs.iredmail.org/migrate.to.ne … erver.html

It's better to migrate with a testing machine first to make sure no mistake and no mess.

3 Reply by rossi256

  • rossi256
  • Member
  • Offline
  • Registered: 2015-01-18
  • Posts: 30

Re: upgrade or migration to new server

Thanks!
We attempted with a test server to upgrade database structure and then migrate db and mails folders - they show up in the statistics on new server but in domains, users and so on all is still empty.
any idea why that happens?

thanks!

4 Reply by rossi256

  • rossi256
  • Member
  • Offline
  • Registered: 2015-01-18
  • Posts: 30

Re: upgrade or migration to new server

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

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

any idea?

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: upgrade or migration to new server

SQL column "domain.maillists" was introduced in iRedMail-0.9.8, obviously you missed it.
https://docs.iredmail.org/upgrade.iredm … l-database