1 Topic by i.sizganov

  • i.sizganov
  • Member
  • Offline
  • Registered: 2018-02-22
  • Posts: 11

Topic: After migrating to a new iRedmail server, roundcube doesn’t working

======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: CentOS 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

mail dovecot: auth-worker(25354): Warning: mysql: Query failed, retrying: Unknown column 'allow_nets' in 'field list'
mail dovecot: auth-worker(25354): Error: sql(postmaster@czics.ru,127.0.0.1,<xxxx>): Password query failed: Unknown column 'allow_nets' in 'field list'

----

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,163

Re: After migrating to a new iRedmail server, roundcube doesn’t working

SQL column "mailbox.allow_nets" first introduced in iRedMail-0.9.1:
https://docs.iredmail.org/upgrade.iredm … l-database

3 Reply by i.sizganov

  • i.sizganov
  • Member
  • Offline
  • Registered: 2018-02-22
  • Posts: 11

Re: After migrating to a new iRedmail server, roundcube doesn’t working

Thank you for you answer, so, if i add this column to my vmail-old.sql and export it to the new server error will be solved?

4 Reply by i.sizganov

  • i.sizganov
  • Member
  • Offline
  • Registered: 2018-02-22
  • Posts: 11

Re: After migrating to a new iRedmail server, roundcube doesn’t working

Hello,

I added column on my new installation, and now i can log into Roundcube, but i cannot see users mail. What is wrong?
I can see mail in Postmaster mailbox, but cannot see mail in usual user mailbox.

Best Regards,
Ilya Sizganov

5 Reply by ZhangHuangbin

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

Re: After migrating to a new iRedmail server, roundcube doesn’t working

- Did you migrate mail accounts?
- Did you migrate mailboxes?
- Is the maildir path stored in SQL db same as the one on file system?