1 Topic by timcons (edited by timcons 2017-12-19 14:52:18)

  • timcons
  • Member
  • Offline
  • Registered: 2017-12-19
  • Posts: 9

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.

2 Reply by ZhangHuangbin

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

Re: Error when Managing whitelist using SQL command

Please use this tutorial instead:
https://docs.iredmail.org/manage.iredapd.html

3 Reply by timcons

  • timcons
  • Member
  • Offline
  • Registered: 2017-12-19
  • Posts: 9

Re: Error when Managing whitelist using SQL command

ZhangHuangbin wrote:

Please use this tutorial instead:
https://docs.iredmail.org/manage.iredapd.html

Thank you
I can get it working with this guide

But I still get this error when issuing the command :
sudo python /opt/iredapd/tools/wblist_admin.py --list --whitelist
Output :
/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

Will this be fixed in a new release ?

4 Reply by ZhangHuangbin

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

Re: Error when Managing whitelist using SQL command

timcons wrote:

Output :
/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

This is safe to ignore, and it's issue with Python module/package 'pymysql', not iRedAPD.

5 Reply by timcons

  • timcons
  • Member
  • Offline
  • Registered: 2017-12-19
  • Posts: 9

Re: Error when Managing whitelist using SQL command

Appreciate it doesn't affect functionality but it does affect the readability of the output

6 Reply by ZhangHuangbin

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

Re: Error when Managing whitelist using SQL command

timcons wrote:

Appreciate it doesn't affect functionality but it does affect the readability of the output

It's controlled by the third-party python module "pymysql", we cannot control it.