1 Topic by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Topic: Will there be an issue with postfix/dovecot if I add a column to mysql

- iRedMail version (check /etc/iredmail-release): 1.6.2
- Deployed with iRedMail Easy or the downloadable installer? Downloadable
- Linux/BSD distribution name and version: Ubuntu 22.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.

Will there be an issue if I add a column to the mailbox table?

----

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

Re: Will there be an issue with postfix/dovecot if I add a column to mysql

jdnielsendevelopment wrote:

Will there be an issue if I add a column to the mailbox table?

Should be fine. Don't forget to set a default value for this new column, otherwise creating new record in this table may fail due to no default value.

3 Reply by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Re: Will there be an issue with postfix/dovecot if I add a column to mysql

ZhangHuangbin wrote:
jdnielsendevelopment wrote:

Will there be an issue if I add a column to the mailbox table?

Should be fine. Don't forget to set a default value for this new column, otherwise creating new record in this table may fail due to no default value.

Will do. Thank you!