1 Topic by sgroom

  • sgroom
  • Member
  • Offline
  • Registered: 2014-04-12
  • Posts: 28

Topic: Blacklists Missing after upgrade to 2.2

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 2.2.0
- Linux/BSD distribution name and version: FreeBSD
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache24
- Manage mail accounts with iRedAdmin-Pro? yes
- Related log if you're reporting an issue:
====

Just upgraded to 2.2 via upgrade_iredadmin.sh
global blacklists missing.
Did I miss something?

----

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: 30,788

Re: Blacklists Missing after upgrade to 2.2

Dear sgroom,

Sorry about this trouble.

*) Did you upgrade iRedMail to iRedMail-0.9.3?

*) White/blacklists are implemented with Amavisd (after-queue) + iRedAPD (before-queue), so you need to upgrade iRedAPD to the latest iRedAPD-1.7.0. http://www.iredmail.org/docs/upgrade.ir … latest-170

*) In iRedMail-0.9.3, Cluebringer has been removed and replaced by iRedAPD. Cluebringer is not under active development and no new release since 2013 (the latest stable release doesn't support IPv6). iRedAPD offers greylisting and throttling supports, please follow tutorial below to migrate greylisting and throttling settings from Cluebringer to iRedAPD:

http://www.iredmail.org/docs/upgrade.ir … to-iredapd

Note: We also plan to completely remove code of Policyd/Cluebringer support in next iRedAdmin-Pro release.

3 Reply by sgroom (edited by sgroom 2015-12-15 00:00:36)

  • sgroom
  • Member
  • Offline
  • Registered: 2014-04-12
  • Posts: 28

Re: Blacklists Missing after upgrade to 2.2

I followed the normal upgrade routine...  tools/upgrade_iredadmin.sh

iRedAPD instaleld properly...
Getting an error trying to migrate cluebringer...

Traceback (most recent call last):
  File "migrate_cluebringer_greylisting.py", line 27, in <module>
    import settings
ImportError: No module named settings

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: Blacklists Missing after upgrade to 2.2

*) Do you have file /opt/iredapd/settings.py? And what's the owner and permission? [Looks like i'm a idiot, but just want to make sure.]
*) Did you run the script under /opt/iredapd/tools/? like this:

# cd /opt/iredapd/tools/
# python migrate_cluebringer_greylisting.py

5 Reply by sgroom

  • sgroom
  • Member
  • Offline
  • Registered: 2014-04-12
  • Posts: 28

Re: Blacklists Missing after upgrade to 2.2

-r--------  1 root  wheel  2103 Dec 14 10:40 /opt/iredapd/settings.py

ok... greylisting migration worked

Error when I try throttle..

11:32:41][root@mail:/opt/iredapd/tools]$ python migrate_cluebringer_throttle.py
* Backend: mysql
Traceback (most recent call last):
  File "migrate_cluebringer_throttle.py", line 135, in <module>
    where='quotasid IN $quotas_ids')
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 682, in select
    return self.query(qout, processed=True)
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 644, in query
    self._db_execute(db_cursor, sql_query)
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 587, in _db_execute
    out = cur.execute(query, params)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")

6 Reply by fsantiago06111979

  • fsantiago06111979
  • Member
  • Offline
  • Registered: 2014-05-04
  • Posts: 229

Re: Blacklists Missing after upgrade to 2.2

ditto, same migration error for me.....

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,788

Re: Blacklists Missing after upgrade to 2.2

Dear all,

Please check this post, we have a patch to fix this:
http://www.iredmail.org/forum/post44684.html#p44684

By the way, this error means you don't have any throttle setting in Cluebrinber database, so it's ok to not run this script again.