1

Topic: Issues with whitelist / blacklist

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.0
- Deployed with iRedMail Easy or the downloadable installer? Downloadable
- Linux/BSD distribution name and version: Ubuntu / Focal
- 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.
====
Hello,

I tried to add some domains to the whitelist, but the command shows that there is nothing in the white (or black) lists after running the command

root@muninn:/opt/iredapd/tools# python3 wblist_admin.py --add --whitelist @.mil
* Establishing SQL connection.
* Add inbound whitelist for account: @.
* Add senders: @.mil
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
  result = self._query(query)
root@muninn:/opt/iredapd/tools# python3 wblist_admin.py --list --whitelist
* Establishing SQL connection.
* List all inbound whitelist for account: @.
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
  result = self._query(query)
* No whitelist/blacklist.

----

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

2

Re: Issues with whitelist / blacklist

It works fine for me on local Ubuntu 20.04 box:

# cd /opt/iredapd/tools/
# python3 wblist_admin.py --add --whitelist @.mil
* Establishing SQL connection.
* Add inbound whitelist for account: @.
* Add senders: @.mil

# python3 wblist_admin.py --list --whitelist
* Establishing SQL connection.
* List all inbound whitelist for account: @.
@.mil

Which iRedAPD are you running? Please show us output of command below:

ls -dl /opt/iredapd/
ls -dl /opt/iRedAPD*

3

Re: Issues with whitelist / blacklist

root@muninn:~# ls -dl /opt/iredapd
lrwxrwxrwx 1 root root 11 Oct  3  2020 /opt/iredapd -> iRedAPD-4.4
root@muninn:~# ls -dl /opt/iRedAPD*
dr-x------  9 root root 4096 Jan 18  2020 /opt/iRedAPD-2.1
dr-x------  9 root root 4096 May 29  2020 /opt/iRedAPD-3.3
dr-x------  9 root root 4096 Sep 12  2020 /opt/iRedAPD-3.6
dr-x------ 10 root root 4096 Jun  7 00:26 /opt/iRedAPD-4.4

4

Re: Issues with whitelist / blacklist

With iRedMail-1.4.0, you should run the latest iRedAPD release, it's now iRedAPD-5.0.2, please upgrade and try again:
https://docs.iredmail.org/upgrade.iredapd.html

5

Re: Issues with whitelist / blacklist

That worked, thank you.

root@muninn:/opt/iRedAPD-5.0.2/tools# python3 wblist_admin.py --add --whitelist @.mil
* Establishing SQL connection.
* Add inbound whitelist for account: @.
* Add senders: @.mil
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
  result = self._query(query)
root@muninn:/opt/iRedAPD-5.0.2/tools# python3 wblist_admin.py --list --whitelist
* Establishing SQL connection.
* List all inbound whitelist for account: @.
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
  result = self._query(query)
@.mil