1 Topic by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Topic: I spoke too soon ... Error again

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer?  downloadable
- Linux/BSD distribution name and version: CentOS8
- 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.
====

Good morning.  I previously had an error that was resolved by a patch.  I was able to create a new email account after which was fully usable.  Just a couple days later, I've tried to create a couple addresses and each result in the following error:

Error: InternalError(1364, "Field 'allowedsenders' doesn't have a default value")

Please help, and thank you again.

----

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: I spoke too soon ... Error again

It seems caused by an old MySQL/MariaDB version, or missing some configuration in my.cnf. Not sure right now.

3 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: I spoke too soon ... Error again

ZhangHuangbin wrote:

It seems caused by an old MySQL/MariaDB version, or missing some configuration in my.cnf. Not sure right now.

Thank you. I’ll stand by for information.

I’m happy to migrate servers once again if needed. Just let me know.

4 Reply by ZhangHuangbin

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

Re: I spoke too soon ... Error again

Could you please show us the mysql/mariadb version info? Did you migrate from an old MySQL database?

5 Reply by usafitz (edited by usafitz 2020-11-26 03:46:20)

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: I spoke too soon ... Error again

sure.

$ mysql -V
mysql  Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1

I migrated the databases, but did a fresh install of iredmail on this server.  I only migrated the databases:  amavisd, iredadmin, iredapd, roundcubemail, sogo, and vmail.

6 Reply by usafitz

  • usafitz
  • Member
  • Offline
  • Registered: 2013-02-02
  • Posts: 71

Re: I spoke too soon ... Error again

okay, I went ahead and migrated back to a CentOS7 server.  I figured since you listed CentOS8 as supported, I would upgrade the OS, but apparently that was the problem. 

The new migration worked like a charm, and I was able to email with a new test account to gmail, yahoo, mac, and outlook.

The migrations were done exactly the same, so if you're going to look into this, I suggest looking at the OS as the culprit.

thanks again for all of your help this week and last.