1 Topic by witek1811

  • witek1811
  • Member
  • Offline
  • Registered: 2016-08-14
  • Posts: 24

Topic: upgrade from 0.9.9 to 1.2.1

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.2.1 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer?  downloadable
- Linux/BSD distribution name and version: Debian 9.11
- 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.
====
Hi,
two days ago I performed update iredmail from version 0.9.9 to 1.2.1 after upgrade I'm able to send mails from my server but when I'm trying to recive something I got information in maillog like this one:

May 10 19:57:13 mail postfix/smtpd[8395]: NOQUEUE: reject: RCPT from mail-wr1-f68.google.com[209.85.221.68]: 450 4.7.1 <my_accout@domain.com>: Recipient address rej
ected: Internal error occurred. Refer to server log for more information.; from=<sender@gmail.com> to=<my_accout@domain.com> proto=ESMTP helo=<mail-wr
1-f68.google.com>

in file /var/log/dovecot/dovecot.log I don't have any information which is related to this.
in /var/log/iredapd/iredapd.log

May 10 19:57:13 mail iredapd [209.85.221.68] RCPT, sender@gmail.com -> my_accout@domain.com, DUNNO [sasl_username=, sender=sender@gmail.com, client_name=mail-wr1-f68.google.com, reverse_client_name=mail-wr1-f68.google.com, helo=mail-wr1-f68.google.com, encryption_protocol=TLSv1.2, encryption_cipher=ECDHE-RSA-AES128-GCM-SHA256, server_port=, process_time=0.0133s]

where I should try to find more information?

----

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: 30,793

Re: upgrade from 0.9.9 to 1.2.1

I expect some related error message in Dovecot log files under /var/log/dovecot/, please all of them (*.log).

3 Reply by witek1811

  • witek1811
  • Member
  • Offline
  • Registered: 2016-08-14
  • Posts: 24

Re: upgrade from 0.9.9 to 1.2.1

it is everything what  I find. 

root@mail:/var/log/dovecot# grep -r -i 'May 10 19:57' *
dovecot.log.1:May 10 19:57:13 mail dovecot: auth-worker(15675): Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablequota-status' in 'where clause'
dovecot.log.1:May 10 19:57:13 mail dovecot: auth-worker(15675): Error: sql(my_accout@domain.com): User query failed: Unknown column 'mailbox.enablequota-status' in 'where clause'
dovecot.log.1:May 10 19:57:13 mail dovecot: quota-status(my_accout@domain.com): Error: user my_accout@domain.com: Auth USER lookup failed
root@mail:/var/log/dovecot#

4 Reply by MuPp3t33r

  • MuPp3t33r
  • Member
  • Offline
  • Registered: 2017-01-17
  • Posts: 149

Re: upgrade from 0.9.9 to 1.2.1

witek1811 wrote:

Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablequota-status' in 'where clause'

Looks like you have not applied the SQL structure changes into your upgrade.
Check out the Release notes and upgrade tutorials