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

- 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'")


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.


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

buy me a cup of coffee