1

Topic: Internal server error for log filter

===

  • iRedMail version: 0.9.9

  • iRedAdmin version: 0.9.8

  • Download Installer

  • Ubuntu 18.04.3 LTS

  • PGSQL

  • Nginx

  • Manage mail accounts with iRedAdmin-Pro? NO

====
Hi.
I was getting an error: Internal server error when selecting any value in the log filter.
My syslog says error:

Dec  3 11:43:38 mail uwsgi: Traceback (most recent call last):#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 257, in process#012    return self.handle()#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 248, in handle#012    return self._delegate(fn, self.fvars, args)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 488, in _delegate#012    return handle_class(cls)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 466, in handle_class#012    return tocall(*args)#012  File "/opt/www/iRedAdmin-0.9.8/controllers/decorators.py", line 11, in proxyfunc#012    return func(self, *args, **kw)#012  File "/opt/www/iRedAdmin-0.9.8/controllers/panel/log.py", line 31, in GET#012    cur_page=self.cur_page,#012  File "/opt/www/iRedAdmin-0.9.8/controllers/decorators.py", line 11, in proxyfunc#012    return func(self, *args, **kw)#012  File "/opt/www/iRedAdmin-0.9.8/libs/panel/log.py", line 39, in listLogs#012    qr = db.select('log', what='COUNT(timestamp) AS total', where=web.db.sqlwhere(queryDict),)#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 403, in sqlwhere#012    return SQLQuery.join([k + ' = ' + sqlparam(v) for k, v in data], grouping)#012ValueError: too many values to unpack
Dec  3 11:43:38 mail uwsgi:
Dec  3 11:43:38 mail uwsgi: mail.site-name.ru [pid: 1260|app: 1|req: 1/2] 1.1.1.1 () {54 vars in 1035 bytes} [Tue Dec  3 11:43:37 2019] GET /iredadmin/system/log?event=login => generated 21 bytes in 148 msecs (HTTP/1.1 500) 2 headers in 155 bytes (2 switches on core 0)

I found this post, and run command:

apt remove python-webpy
apt clean all
apt install python-setuptools
python /usr/lib/python2.7/dist-packages/easy_install.py web.py==0.40
service iredadmin restart

Remove cookie and login iRedAdmin.
But I still see a mistake: Internal server error when selecting any value in the log filter.
My syslog says error:

Dec  3 12:57:58 mail uwsgi: Traceback (most recent call last):#012  File "/usr/local/lib/python2.7/dist-packages/web.py-0.40-py2.7.egg/web/application.py", line 289, in process#012    return self.handle()#012  File "/usr/local/lib/python2.7/dist-packages/web.py-0.40-py2.7.egg/web/application.py", line 280, in handle#012    return self._delegate(fn, self.fvars, args)#012  File "/usr/local/lib/python2.7/dist-packages/web.py-0.40-py2.7.egg/web/application.py", line 530, in _delegate#012    return handle_class(cls)#012  File "/usr/local/lib/python2.7/dist-packages/web.py-0.40-py2.7.egg/web/application.py", line 508, in handle_class#012    return tocall(*args)#012  File "/opt/www/iRedAdmin-0.9.8/controllers/decorators.py", line 11, in proxyfunc#012    return func(self, *args, **kw)#012  File "/opt/www/iRedAdmin-0.9.8/controllers/panel/log.py", line 31, in GET#012    cur_page=self.cur_page,#012  File "/opt/www/iRedAdmin-0.9.8/controllers/decorators.py", line 11, in proxyfunc#012    return func(self, *args, **kw)#012  File "/opt/www/iRedAdmin-0.9.8/libs/panel/log.py", line 39, in listLogs#012    qr = db.select('log', what='COUNT(timestamp) AS total', where=web.db.sqlwhere(queryDict),)#012  File "/usr/local/lib/python2.7/dist-packages/web.py-0.40-py2.7.egg/web/db.py", line 460, in sqlwhere#012    return SQLQuery.join([k + " = " + sqlparam(v) for k, v in data], grouping)#012ValueError: too many values to unpack
Dec  3 12:57:58 mail uwsgi:
Dec  3 12:57:58 mail uwsgi: mail.site-name.ru [pid: 2822|app: 1|req: 3/7] 1.1.1.1 () {54 vars in 1035 bytes} [Tue Dec  3 12:57:58 2019] GET /iredadmin/system/log?event=login => generated 21 bytes in 26 msecs (HTTP/1.1 500) 2 headers in 194 bytes (2 switches on core 0)

2

Re: Internal server error for log filter

Dear @pirat77,

Please upgrade your iRedAdmin open source edition to the latest 0.9.9, it fixes this issue.

- Download directly: https://dl.iredmail.org/yum/misc/iRedAd … .9.tar.bz2
- Then follow our tutorial below to upgrade it: https://docs.iredmail.org/migrate.or.up … rade-steps

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee