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 restartRemove 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)----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.