1 Topic by balvinder-sayvee

  • balvinder-sayvee
  • balvinder-sayvee
  • Member
  • Offline
  • Registered: 2022-12-30
  • Posts: 2

Topic: iRedAdmin-Pro-SQL break after upgrade v5.2 -> v5.3

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

Dec 30 06:11:43 mail iredadmin[27558]: SyntaxError: invalid syntax
Dec 30 06:11:43 mail iredadmin[27558]: unable to load app 0 (mountpoint='') (callable not found or import error)
Dec 30 06:11:43 mail iredadmin[27558]: *** no app loaded. going in full dynamic mode ***
Dec 30 06:11:43 mail iredadmin[27558]: *** uWSGI is running in multiple interpreter mode ***

----

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: iRedAdmin-Pro-SQL break after upgrade v5.2 -> v5.3

balvinder-sayvee wrote:

- Linux/BSD distribution name and version: Ubuntu 16.04.7 LTS

Ubuntu 16.04 is too old, please consider upgrade to at least 18.04, better 20.04 or even 22.04.

Pasted log lines is not clear for troubleshooting, but please try commands below to fix it:

pip3 install -U web.py
service iredadmin restart

3 Reply by balvinder-sayvee

  • balvinder-sayvee
  • balvinder-sayvee
  • Member
  • Offline
  • Registered: 2022-12-30
  • Posts: 2

Re: iRedAdmin-Pro-SQL break after upgrade v5.2 -> v5.3

I am still not able to fix it.

Here are more logs.

● iredadmin.service - iRedAdmin daemon service
   Loaded: loaded (/lib/systemd/system/iredadmin.service; enabled; vendor preset: enabled)
   Active: active (running) since Fri 2023-01-13 06:48:55 UTC; 4min 0s ago
  Process: 13880 ExecStopPost=/bin/rm -rf /var/run/iredadmin (code=exited, status=0/SUCCESS)
  Process: 13876 ExecStop=/usr/bin/uwsgi --stop /var/run/iredadmin/iredadmin.pid (code=exited, status=0/SUCCESS)
  Process: 13894 ExecStartPre=/bin/chmod 0755 /var/run/iredadmin (code=exited, status=0/SUCCESS)
  Process: 13890 ExecStartPre=/bin/chown iredadmin:iredadmin /var/run/iredadmin (code=exited, status=0/SUCCESS)
  Process: 13885 ExecStartPre=/bin/mkdir -p /var/run/iredadmin (code=exited, status=0/SUCCESS)
Main PID: 13898 (uwsgi)
   Memory: 25.0M
      CPU: 231ms
   CGroup: /system.slice/iredadmin.service
           ├─13898 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid
           ├─13900 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid
           ├─13901 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid
           ├─13902 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid
           ├─13903 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid
           └─13904 /usr/bin/uwsgi --ini /opt/www/iredadmin/rc_scripts/uwsgi/debian.ini --pidfile /var/run/iredadmin/iredadmin.pid

Jan 13 06:52:06 mail iredadmin[13898]:     import web
Jan 13 06:52:06 mail iredadmin[13898]:   File "/opt/www/iRedAdmin-Pro-SQL-5.3/web/__init__.py", line 4, in <module>
Jan 13 06:52:06 mail iredadmin[13898]:     from . import (  # noqa: F401
Jan 13 06:52:06 mail iredadmin[13898]:   File "/opt/www/iRedAdmin-Pro-SQL-5.3/web/db.py", line 757
Jan 13 06:52:06 mail iredadmin[13898]:     f"{round(b - a, 2)} ({self.ctx.dbq_count}): {str(sql_query)}",
Jan 13 06:52:06 mail iredadmin[13898]:                                                                 ^
Jan 13 06:52:06 mail iredadmin[13898]: SyntaxError: invalid syntax
Jan 13 06:52:06 mail iredadmin[13898]: unable to load app 0 (mountpoint='') (callable not found or import er
Jan 13 06:52:06 mail iredadmin[13898]: --- no python application found, check your startup logs for errors ---
Jan 13 06:52:06 mail iredadmin[13898]: [172.105.110.228] GET /iredadmin/login?msg=LOGIN_REQUIRED 500 104 "-"

4 Reply by ZhangHuangbin

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

Re: iRedAdmin-Pro-SQL break after upgrade v5.2 -> v5.3

I guess the Python version (3.5.1) on Ubuntu 16.04 is too old and doesn't support the syntax.

- As a temporary solution, you can downgrade to previous iRedAdmin-Pro release.
- As final solution, please upgrade Ubuntu to at least 18.04.