Topic: Error when Managing whitelist using SQL command
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Trying to manage whitelist using instructions from https://docs.iredmail.org/amavisd.wblis … l-commands
But the script seems to be in need of upgrade. I get this message when just listing, and similar when trying to add an entry
ubuntu@mail:~$ sudo python /opt/iredapd/tools/wblist_admin.py --list --whitelist
* Establishing SQL connection.
* List all inbound whitelist for account: @.
/usr/lib/python2.7/dist-packages/pymysql/cursors.py:158: Warning: '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
result = self._query(query)
* No whitelist/blacklist.
How can I resolve this ? (without random hacks which would complicate integrity and upgrade of iRedMail deployment)
Thank you
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.