[GH-ISSUE #2608] generate_postfix_map doesn't take the database port into account #1651

New issue

Closed

opened 2026-02-27 11:18:23 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:18:23 +03:00

Owner

Originally created by @eburghar on GitHub (Sep 22, 2022).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/2608

Impacted versions

OS Type: alpine
OS Version: 3.16
Database Type: PostgreSQL
Database version: 14.5
Modoboa: 2.0.1
installer used: No
Webserver: unit

Steps to reproduce

use port in database settings

DATABASES = {
        'default': {
                'ENGINE': 'django.db.backends.postgresql_psycopg2',
                'NAME': 'modoboa',
                'USER': 'v-kubernet-mail_mod-x',
                'PASSWORD': 'y',
                'HOST': 'pgbouncer.db',
                'PORT': '6432',
                'ATOMIC_REQUESTS': True,
        }
}

then call python admin.py generate_posfix_maps

Current behavior

port is not appended to host (see mysql_table and pgsql_table)

# This file was generated on Sept. 22, 2022, 12:38 p.m. by running:
# manage.py generate_postfix_maps --settings itsufficient.settings_local --force-overwrite --destdir /etc/postfix
# DO NOT EDIT!
user = v-kubernet-mail_mod-x
password = y
dbname = modoboa
hosts = pgbouncer.db
query = SELECT service || ':' || next_hop FROM transport_transport WHERE pattern='%s'

Expected behavior

port appended to host

# This file was generated on Sept. 22, 2022, 12:38 p.m. by running:
# manage.py generate_postfix_maps --settings itsufficient.settings_local --force-overwrite --destdir /etc/postfix
# DO NOT EDIT!
user = v-kubernet-mail_mod-x
password = y
dbname = modoboa
hosts = pgbouncer.db:6432
query = SELECT service || ':' || next_hop FROM transport_transport WHERE pattern='%s'

Video/Screenshot link (optional)

Originally created by @eburghar on GitHub (Sep 22, 2022). Original GitHub issue: https://github.com/modoboa/modoboa/issues/2608 # Impacted versions * OS Type: alpine * OS Version: 3.16 * Database Type: PostgreSQL * Database version: 14.5 * Modoboa: 2.0.1 * installer used: No * Webserver: unit # Steps to reproduce use port in database settings ``` DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'modoboa', 'USER': 'v-kubernet-mail_mod-x', 'PASSWORD': 'y', 'HOST': 'pgbouncer.db', 'PORT': '6432', 'ATOMIC_REQUESTS': True, } } ``` then call `python admin.py generate_posfix_maps` # Current behavior port is not appended to host (see [mysql_table](http://www.postfix.org/mysql_table.5.html) and [pgsql_table](https://www.postfix.org/pgsql_table.5.html)) ``` # This file was generated on Sept. 22, 2022, 12:38 p.m. by running: # manage.py generate_postfix_maps --settings itsufficient.settings_local --force-overwrite --destdir /etc/postfix # DO NOT EDIT! user = v-kubernet-mail_mod-x password = y dbname = modoboa hosts = pgbouncer.db query = SELECT service || ':' || next_hop FROM transport_transport WHERE pattern='%s' ``` # Expected behavior port appended to host ``` # This file was generated on Sept. 22, 2022, 12:38 p.m. by running: # manage.py generate_postfix_maps --settings itsufficient.settings_local --force-overwrite --destdir /etc/postfix # DO NOT EDIT! user = v-kubernet-mail_mod-x password = y dbname = modoboa hosts = pgbouncer.db:6432 query = SELECT service || ':' || next_hop FROM transport_transport WHERE pattern='%s' ``` # Video/Screenshot link (optional)