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

Hi,
while managing a domain i got this error today.
This happens as i'm trying to get a specific email user details. (
From the domains lists i choose a domain ->
From the emails/users list a click on one)

Error: ConnectionError(MaxRetryError("HTTPConnectionPool(host='127.0.0.1', port=7790): Max retries exceeded with url: /api/subscriber/email@domain.dom/subscribed?query_all_lists=no&email_only=yes (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x80b1c5890>: Failed to establish a new connection: [Errno 61] Connection refused',))",),)

The problem is likely connected to they fact that (being on a FreeBSD jail) i do not use 127.0.0.1 for anything, jails don't have 127.0.0.1, the parent system does. Consequently it looks to me that there might be a place where 127.0.0.1 is hardcoded instead than getting it form the settings file.

A quick check at the "/usr/local/www/iRedAdmin-Pro-SQL-4.2" gets me a list of files that have '127.0.0.1' in it:

# grep -e '127.0.0.1' -r ./
./settings.py.mysql.sample:#   3. lmtp:inet:127.0.0.1:24: LMTP (TCP listener). Supported by iRedMail-0.8.6
./settings.py.mysql.sample:iredadmin_db_host = '127.0.0.1'
./settings.py.mysql.sample:vmail_db_host = '127.0.0.1'
./settings.py.mysql.sample:amavisd_db_host = '127.0.0.1'
./settings.py.mysql.sample:# Default is '127.0.0.1'. Sample setting:
./settings.py.mysql.sample:iredapd_db_host = '127.0.0.1'
./rc_scripts/uwsgi/rhel.ini:uwsgi-socket = 127.0.0.1:7791
./rc_scripts/uwsgi/openbsd.ini:uwsgi-socket = 127.0.0.1:7791
./rc_scripts/uwsgi/debian.ini:uwsgi-socket = 127.0.0.1:7791
./rc_scripts/uwsgi/freebsd.ini:uwsgi-socket = 127.0.0.1:7791
./tools/ira_tool_lib.py:                    ip='127.0.0.1',
./tools/upgrade_iredadmin.sh:host=127.0.0.1
./tools/upgrade_iredadmin.sh:            perl -pi -e 's#uwsgi_pass unix:.*iredadmin.socket;#uwsgi_pass 127.0.0.1:7791;#g' ${f}
./tools/upgrade_iredadmin.sh:        add_missing_parameter 'iredapd_db_host' '127.0.0.1'
./libs/default_settings.py:    "lmtp:inet:127.0.0.1:24",
./libs/default_settings.py:# Base url of mlmmjadmin API. For example: 'http://127.0.0.1:7790/api'
./libs/default_settings.py:MLMMJADMIN_API_BASE_URL = "http://127.0.0.1:7790/api"
./libs/default_settings.py:fail2ban_db_host = '127.0.0.1'
./libs/ipaddress.py:            >>> ipaddress.ip_address("127.0.0.1").reverse_pointer
./settings.py.pgsql.sample:#   3. lmtp:inet:127.0.0.1:24: LMTP (TCP listener). Supported by iRedMail-0.8.6
./settings.py.pgsql.sample:iredadmin_db_host = '127.0.0.1'
./settings.py.pgsql.sample:vmail_db_host = '127.0.0.1'
./settings.py.pgsql.sample:amavisd_db_host = '127.0.0.1'
./settings.py.pgsql.sample:# Default is '127.0.0.1'. Sample setting:
./settings.py.pgsql.sample:iredapd_db_host = '127.0.0.1'

But none of these seems to be the culpit....

Any suggestion?
Thanks,
Marco