1 Topic by citm

  • citm
  • Member
  • Offline
  • Registered: 2019-10-11
  • Posts: 7

Topic: iRedAdmin error - iredapd.smtp_sessions doesn't exist

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9
- Deployed with iRedMail Easy or the downloadable installer? Downloadable installer
- Linux/BSD distribution name and version: Linux version 3.10.0-327.el7.x86_64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- 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.
====
Hi all,

I can't login iRedAdmin website: after fill in username and password, I get 504 Bad gateway. I check service status and I get this: iredadmin (1146, "Table 'iredapd.smtp_sessions' doesn't exist") (/opt/www/iRedAdmin-Pro-LDAP-4.1/libs/iredapd/log.py, line 76

Nginx log: 2020/05/08 10:37:54 [error] 31707#0: *1172 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 123.45.67.89, server: _, request: "GET /iredadmin/dashboard?checknew HTTP/1.1", upstream: "uwsgi://127.0.0.1:7791", host: "mycompany.com", referrer: "https://mycompany.com/iredadmin"

Any help would be very much appreciated! Thank you

----

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
  • Online
  • Registered: 2009-05-06
  • Posts: 31,088

Re: iRedAdmin error - iredapd.smtp_sessions doesn't exist

Please upgrade iRedAPD to the latest release (3.6), it will add this missing sql table.

3 Reply by citm (edited by citm 2020-05-08 17:28:27)

  • citm
  • Member
  • Offline
  • Registered: 2019-10-11
  • Posts: 7

Re: iRedAdmin error - iredapd.smtp_sessions doesn't exist

I upgraded iRedAPD to 3.6. The iredadmin service started without the error I mentioned in the previous post. However, I still can not login iRedadmin web. Ngix log:

2020/05/08 16:23:01 [error] 19125#0: *2325 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 123.45.67.89, server: _, request: "GET /iredadmin/dashboard?checknew HTTP/1.1", upstream: "uwsgi://127.0.0.1:7791", host: "mail_server", referrer: "https://mycompany.com/iredadmin"

Do you have any suggestions for me? Thank you, ZhangHuangbin

4 Reply by ZhangHuangbin

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

Re: iRedAdmin error - iredapd.smtp_sessions doesn't exist

citm wrote:

upstream: "uwsgi://127.0.0.1:7791"

Port 7791 is iredadmin service. After restarted "iredadmin" service, did you ever check it's actually running? What's the output of command "systemctl status iredadmin"? Any error in /var/log/messages?