starred/modoboa-modoboa
1
0
Fork 0
mirror of https://github.com/modoboa/modoboa.git synced 2026-04-25 17:06:01 +03:00
Code Issues 60 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #840] Invalid postfix_maps for postgresql #750

New issue
Closed
opened 2026-02-27 11:13:21 +03:00 by kerem · 2 comments
kerem commented 2026-02-27 11:13:21 +03:00
Owner
Copy link

Originally created by @neutrinus on GitHub (Mar 3, 2016).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/840

Originally assigned to: @tonioo on GitHub.

The auto-created postfix maps have a typo. There is admin_aliasrecipient instead of modoboa_admin_aliasrecipient.

Log:
Mar 03 12:37:54 Debian-jessie-amd64-netboot postfix/smtpd[11121]: warning: pgsql query failed: fatal error from host localhost: ERROR: relation "admin_aliasrecipient" does not exist?LINE 1: ... '@' || dom.name FROM admin_mailbox mb INNER JOIN admin_alia...? ^?

/etc/postfix/sql-sender-login-aliases.cf:
query = SELECT mb.address || '@' || dom.name FROM admin_mailbox mb INNER JOIN admin_aliasrecipient alr ON alr.r_mailbox_id=mb.id INNER JOIN admin_domain dom ON dom.id=mb.domain_id INNER JOIN admin_alias al ON alr.alias_id=al.id WHERE al.enabled AND al.address='%s'

Relations in DB:

                  List of relations

Schema | Name | Type | Owner
--------+-----------------------------------+-------+---------
public | admin_alias | table | modoboa
public | admin_domain | table | modoboa
public | admin_domainalias | table | modoboa
public | admin_mailbox | table | modoboa
public | admin_mailboxoperation | table | modoboa
public | admin_objectdates | table | modoboa
public | admin_quota | table | modoboa
public | auth_group | table | modoboa
public | auth_group_permissions | table | modoboa
public | auth_permission | table | modoboa
public | authtoken_token | table | modoboa
public | core_log | table | modoboa
public | core_objectaccess | table | modoboa
public | core_user | table | modoboa
public | core_user_groups | table | modoboa
public | core_user_user_permissions | table | modoboa
public | django_content_type | table | modoboa
public | django_migrations | table | modoboa
public | django_session | table | modoboa
public | django_site | table | modoboa
public | lib_parameter | table | modoboa
public | lib_userparameter | table | modoboa
public | limits_limit | table | modoboa
public | limits_limitspool | table | modoboa
public | modoboa_admin_aliasrecipient | table | modoboa
public | postfix_relay_domains_relaydomain | table | modoboa
public | postfix_relay_domains_service | table | modoboa
public | reversion_revision | table | modoboa
public | reversion_version | table | modoboa
(29 rows)

Modoboa installed from pip==1.4.4

This way it has been deployed:
/home/modoboa/virtualenv/bin/modoboa-admin.py deploy mailadmin --dburl default:postgres://modoboa:modoboa@localhost:5432/maildb --domain localhost
/home/modoboa/virtualenv/bin/modoboa-admin.py postfix_maps --dburl postgres://modoboa:modoboa@localhost:5432/maildb /etc/postfix

Originally created by @neutrinus on GitHub (Mar 3, 2016). Original GitHub issue: https://github.com/modoboa/modoboa/issues/840 Originally assigned to: @tonioo on GitHub. The auto-created postfix maps have a typo. There is `admin_aliasrecipient` instead of `modoboa_admin_aliasrecipient`. Log: `Mar 03 12:37:54 Debian-jessie-amd64-netboot postfix/smtpd[11121]: warning: pgsql query failed: fatal error from host localhost: ERROR: relation "admin_aliasrecipient" does not exist?LINE 1: ... '@' || dom.name FROM admin_mailbox mb INNER JOIN admin_alia...? ^? ` /etc/postfix/sql-sender-login-aliases.cf: `query = SELECT mb.address || '@' || dom.name FROM admin_mailbox mb INNER JOIN admin_aliasrecipient alr ON alr.r_mailbox_id=mb.id INNER JOIN admin_domain dom ON dom.id=mb.domain_id INNER JOIN admin_alias al ON alr.alias_id=al.id WHERE al.enabled AND al.address='%s'` Relations in DB: > ``` > List of relations > ``` > > Schema | Name | Type | Owner > --------+-----------------------------------+-------+--------- > public | admin_alias | table | modoboa > public | admin_domain | table | modoboa > public | admin_domainalias | table | modoboa > public | admin_mailbox | table | modoboa > public | admin_mailboxoperation | table | modoboa > public | admin_objectdates | table | modoboa > public | admin_quota | table | modoboa > public | auth_group | table | modoboa > public | auth_group_permissions | table | modoboa > public | auth_permission | table | modoboa > public | authtoken_token | table | modoboa > public | core_log | table | modoboa > public | core_objectaccess | table | modoboa > public | core_user | table | modoboa > public | core_user_groups | table | modoboa > public | core_user_user_permissions | table | modoboa > public | django_content_type | table | modoboa > public | django_migrations | table | modoboa > public | django_session | table | modoboa > public | django_site | table | modoboa > public | lib_parameter | table | modoboa > public | lib_userparameter | table | modoboa > public | limits_limit | table | modoboa > public | limits_limitspool | table | modoboa > public | modoboa_admin_aliasrecipient | table | modoboa > public | postfix_relay_domains_relaydomain | table | modoboa > public | postfix_relay_domains_service | table | modoboa > public | reversion_revision | table | modoboa > public | reversion_version | table | modoboa > (29 rows) Modoboa installed from pip==1.4.4 This way it has been deployed: `/home/modoboa/virtualenv/bin/modoboa-admin.py deploy mailadmin --dburl default:postgres://modoboa:modoboa@localhost:5432/maildb --domain localhost` `/home/modoboa/virtualenv/bin/modoboa-admin.py postfix_maps --dburl postgres://modoboa:modoboa@localhost:5432/maildb /etc/postfix`
kerem 2026-02-27 11:13:21 +03:00
  • closed this issue
  • added the
    bug
         label
kerem commented 2026-02-27 11:13:22 +03:00
Author
Owner
Copy link

@tonioo commented on GitHub (Mar 9, 2016):

Hi, thanks for reporting but this issue is already fixed and will be released soon. (see github.com/tonioo/modoboa@0a62b0f9a4)

<!-- gh-comment-id:194216916 --> @tonioo commented on GitHub (Mar 9, 2016): Hi, thanks for reporting but this issue is already fixed and will be released soon. (see https://github.com/tonioo/modoboa/commit/0a62b0f9a4cc202da33cd1a6141741585e5f9baf)
kerem commented 2026-02-27 11:13:22 +03:00
Author
Owner
Copy link

@neutrinus commented on GitHub (Mar 9, 2016):

Great, thank you!

<!-- gh-comment-id:194246642 --> @neutrinus commented on GitHub (Mar 9, 2016): Great, thank you!
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
fix/sievefilters-allow-email-in-rule-name
dependabot/npm_and_yarn/frontend/axios-1.15.0
translations_04c0b653215cb5fa48ab101eae1a1917_ja_JP
translations_5d93982e9fd6dab991db4faf93ce9ded_ja_JP
fix/login-issue-3995
fix/sievefilters-issues
add-vitepress-openapi
2974-dmarc-empty-email
2.3.x
updated-doc-2.3.0
feature/OIDC
delete-all-alarms
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_af_ZA
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ar
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_ca
1.x
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_sk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_tr
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_es_ES
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_uk
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_zh_CN
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_de_DE
translations_modoboa-admin-locale-en-lc-messages-djangojs-po--master_da_DK
1.8.x
1.7.x
1.6.x
1.4.x
1.3.x
1.2.x
2.8.2
2.8.1
2.8.0
2.7.2
2.7.1
2.7.0
2.6.5
2.6.4
2.6.3
2.6.2
2.6.1
2.6.0
2.5.1
2.5.0
2.4.11
2.4.10
2.4.9
2.4.8
2.4.7
2.4.6
2.4.5
2.4.4
2.4.3
2.4.2
2.4.1
2.4.0
2.3.6
2.3.5
2.3.4
2.3.3
2.3.2
2.3.1
2.3.0
2.3.0-beta.4
2.3.0-beta.3
2.3.0-beta.2
2.3.0-beta.1
2.2.4
2.2.3
2.2.2
2.2.1
2.2.0
2.1.2
2.1.1
2.1.0
2.0.5
2.0.4
2.0.3
2.0.2
2.0.1
2.0.0
2.0.0-beta.3
2.0.0-beta.2
2.0.0-beta.1
1.17.0
1.16.1
1.16.0
1.15.0
1.14.0
1.13.1
1.13.0
1.12.2
1.12.1
1.12.0
1.11.1
1.11.0
1.10.7
1.10.6
1.10.5
1.10.4
1.10.3
1.10.2
1.10.1
1.10.0
1.9.1
1.9.0
1.8.3
1.8.2
1.8.1
1.8.0
1.7.4
1.7.3
1.7.2
1.7.1
1.7.0
1.6.3
1.6.2
1.6.1
1.6.0
1.5.3
1.5.2
1.5.1
1.5.0
1.4.5
1.4.4
1.4.3
1.4.2
1.4.1
1.4.0
1.3.5
1.3.4
1.2.2
1.3.3
1.3.2
1.3.1
1.3.0
1.2.1
1.2.0
1.2.0-rc2
1.2.0-rc1
1.1.7
1.1.6
1.1.5
1.1.4
1.1.3
1.1.2
1.1.1
1.1.0
1.0.1
1.0.0
0.9.5
0.9.4
0.9.3
0.9.2
0.9.1
0.9
0.8.8
0.8.7
0.8.6.1
0.8.6
0.8.5
0.8.4
0.8.3
0.8.3-rc1
0.8.2
0.8.1
0.8
0.8-rc2
0.8-rc1
0.7.2
0.7.1
0.7
0.6.1
0.6
0.5
0.3
0.2
0.1
Labels
Clear labels   
bug

   
bug

   
dependencies

   
design

   
documentation

   
duplicate

   
enhancement

   
enhancement

   
enhancement

   
feedback-needed

   
help-needed

   
help-needed

   
installer

   
invalid

   
looking-for-sponsors

   
modoboa-contacts

   
new-ui

   
new-ui

   
pr

   
pull-request

Mirrored from GitHub Pull Request

  
pyconfr

   
python

   
question

   
security

   
stale

   
webmail

   
wontfix
No labels
bug
bug
dependencies
design
documentation
duplicate
enhancement
enhancement
enhancement
feedback-needed
help-needed
help-needed
installer
invalid
looking-for-sponsors
modoboa-contacts
new-ui
new-ui
pr
pull-request
pyconfr
python
question
security
stale
webmail
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/modoboa-modoboa#750
No description provided.