1 Topic by cypromis

  • cypromis
  • Member
  • Offline
  • Registered: 2020-05-10
  • Posts: 4

Topic: after upgrade to ee, no stats in dashboard and postfix cant auth users

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

2 issues. first the default setup seems to want to make the dovecot/postifx auth sockets owned by vmail, but they have o be owned by postfix:postfix ?

second issue, no statistics and the daemon.log has the following error:

2026-05-01 09:43:22 ERROR Failed in getting top senders: Error 1146 (42S02): Table 'milter.sessions' doesn't exist
2026-05-01 09:43:22 ERROR Failed in getting top recipients: Error 1146 (42S02): Table 'milter.rcpts' doesn't exist
2026-05-01 09:43:52 ERROR Failed in getting top senders: Error 1146 (42S02): Table 'milter.sessions' doesn't exist
2026-05-01 09:43:52 ERROR Failed in getting top recipients: Error 1146 (42S02): Table 'milter.rcpts' doesn't exist
2026-05-01 09:43:53 ERROR Failed in getting top senders: Error 1146 (42S02): Table 'milter.sessions' doesn't exist
2026-05-01 09:43:53 ERROR Failed in getting top recipients: Error 1146 (42S02): Table 'milter.rcpts' doesn't exist
2026-05-01 09:50:09 ERROR Failed in getting top senders: Error 1146 (42S02): Table 'milter.sessions' doesn't exist
2026-05-01 09:50:09 ERROR Failed in getting top recipients: Error 1146 (42S02): Table 'milter.rcpts' doesn't exist
2026-05-01 09:55:03 ERROR Failed in getting top senders: Error 1146 (42S02): Table 'milter.sessions' doesn't exist
2026-05-01 09:55:03 ERROR Failed in getting top recipients: Error 1146 (42S02): Table 'milter.rcpts' doesn't exist

Also the BIND seting is kind of shaky it seems ... 2026-05-01 15:42:40 ERROR Failed in fetching license info: dial tcp: lookup l.iredmail.org on 127.0.0.1:53: server misbehaving

----

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

Re: after upgrade to ee, no stats in dashboard and postfix cant auth users

please restart milter service and check whether it creates required sql tables in database "milter", also check mail flow in postfix log file.

3 Reply by cypromis

  • cypromis
  • Member
  • Offline
  • Registered: 2020-05-10
  • Posts: 4

Re: after upgrade to ee, no stats in dashboard and postfix cant auth users

ZhangHuangbin wrote:

please restart milter service and check whether it creates required sql tables in database "milter", also check mail flow in postfix log file.

I had to redeploy milter twice than the tables were created.

The dovecot/postfix problem I dont know how to fix, the dovecot.conf says the permissions should be 0666, the files get created with permissions 0600 and on every restart they go back to that. for now I put in custom.sh to chmod them but that is weird.

Also on moving from pro to ee the main database changed from iredadmin to vmail but the shared mailboxes weere not copied. had to do that by hand.

And now, when I want to share a mailbox via sogo .. it adds it to the tables in both databases, the sogo on and the dovecot one, adds the dovecot-acl file, but dovecot does not seem to care. old shared mailboxes are still shared, new permissions are not.  Very weird.

This is all a bit less painless than I expected, but than .. this server has been running iredmail since   aeons ..