1

Topic: iredadmin/activities/fail2ban/banned internal server error

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.2.1 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? installer
- Linux/BSD distribution name and version: Debian 10
- 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.
====
Cannot unban ip addresses from iredadmin pro, the page return 500 internal server error. This is the log I get:

mail iredadmin: Traceback (most recent call last):#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 290, in process#012    return self.handle()#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 281, in handle#012    return self._delegate(fn, self.fvars, args)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 531, in _delegate#012    return handle_class(cls)#012  File "/usr/lib/python2.7/dist-packages/web/application.py", line 509, in handle_class#012    return tocall(*args)#012  File "/opt/www/iRedAdmin-Pro-SQL-4.4/controllers/decorators.py", line 75, in proxyfunc#012    return func(self, *args, **kw)#012  File "/opt/www/iRedAdmin-Pro-SQL-4.4/controllers/f2b/log.py", line 15, in GET#012    order='ip',#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 898, in select#012    return self.query(qout, processed=True)#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 845, in query#012    self._db_execute(db_cursor, sql_query)#012  File "/usr/lib/python2.7/dist-packages/web/db.py", line 771, in _db_execute#012    out = cur.execute(query, params)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute#012    self.errorhandler(self, exc, value)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler#012    raise errorvalue#012OperationalError: (1054, "Unknown column 'rdns' in 'field list'")

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: iredadmin/activities/fail2ban/banned internal server error

Upgrade your iRedMail to latest 1.3.1 will fix the issue. You missed one SQL column.