[GH-ISSUE #711] SQL prepare failed: near "(": Error with generated sql-aliases.cf file #659

New issue

Closed

opened 2026-02-27 11:12:53 +03:00 by kerem · 6 comments

kerem commented 2026-02-27 11:12:53 +03:00

Owner

Copy link

Originally created by @iyobo on GitHub (Apr 13, 2015).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/711

When I try to use webmail I get the error:
Error: command: LOGIN => socket error: EOF

Looking at my logs, I see this continously:
Apr 13 17:42:28 mail postfix/pickup[2261]: ECB5F2166E: uid=0 from=
Apr 13 17:42:28 mail postfix/cleanup[2619]: fatal: dict_sqlite_lookup: /servers/mail/mapfiles/sql-aliases.cf: SQL prepare failed: near "(": syntax error?
Apr 13 17:42:29 mail postfix/pickup[2261]: warning: maildrop/85FD22146D: error writing ECB5F2166E: queue file write error
Apr 13 17:42:29 mail postfix/master[2256]: warning: process /usr/lib/postfix/cleanup pid 2619 exit status 1
Apr 13 17:42:29 mail postfix/master[2256]: warning: /usr/lib/postfix/cleanup: bad command startup -- throttling

I've never been quite able to get this to work. Any tips?

Originally created by @iyobo on GitHub (Apr 13, 2015). Original GitHub issue: https://github.com/modoboa/modoboa/issues/711 When I try to use webmail I get the error: Error: command: LOGIN => socket error: EOF Looking at my logs, I see this continously: Apr 13 17:42:28 mail postfix/pickup[2261]: ECB5F2166E: uid=0 from=<root> Apr 13 17:42:28 mail postfix/cleanup[2619]: fatal: dict_sqlite_lookup: /servers/mail/mapfiles/sql-aliases.cf: SQL prepare failed: near "(": syntax error? Apr 13 17:42:29 mail postfix/pickup[2261]: warning: maildrop/85FD22146D: error writing ECB5F2166E: queue file write error Apr 13 17:42:29 mail postfix/master[2256]: warning: process /usr/lib/postfix/cleanup pid 2619 exit status 1 Apr 13 17:42:29 mail postfix/master[2256]: warning: /usr/lib/postfix/cleanup: bad command startup -- throttling I've never been quite able to get this to work. Any tips?

kerem closed this issue 2026-02-27 11:12:53 +03:00

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@iyobo commented on GitHub (Apr 13, 2015):

This is the query given to the query field in that generated file by modoboa-django.py postfix_maps ...

Nothing changed. Spaced out for more legibility.

(
SELECT (mb.address || '@' || dom.name)
FROM admin_mailbox mb
INNER JOIN admin_domain dom ON mb.domain_id=dom.id
WHERE mb.id IN (
SELECT al_mb.mailbox_id
FROM admin_alias_mboxes al_mb
INNER JOIN admin_alias al ON al_mb.alias_id=al.id
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d'
AND dom.enabled=1
AND al.address='%u'
AND al.enabled=1
)
)

UNION (
SELECT (al.address || '@' || dom.name)
FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE al.id IN (
SELECT al_al.to_alias_id
FROM admin_alias_aliases al_al
INNER JOIN admin_alias al ON al_al.from_alias_id=al.id
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1
)
)

UNION (
SELECT al.extmboxes
FROM admin_alias al
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 AND al.extmboxes<>''
)

<!-- gh-comment-id:92445172 --> @iyobo commented on GitHub (Apr 13, 2015): This is the query given to the query field in that generated file by modoboa-django.py postfix_maps ... ## Nothing changed. Spaced out for more legibility. ( SELECT (mb.address || '@' || dom.name) FROM admin_mailbox mb INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.id IN ( SELECT al_mb.mailbox_id FROM admin_alias_mboxes al_mb INNER JOIN admin_alias al ON al_mb.alias_id=al.id INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 ) ) UNION ( SELECT (al.address || '@' || dom.name) FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE al.id IN ( SELECT al_al.to_alias_id FROM admin_alias_aliases al_al INNER JOIN admin_alias al ON al_al.from_alias_id=al.id INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 ) ) UNION ( SELECT al.extmboxes FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 AND al.extmboxes<>'' )

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@iyobo commented on GitHub (Apr 13, 2015):

While we're at it, would it be a terrible thing to just use that VM provided for 1.2.1 as a production mail server?

I was thinking how easy it would be to just use it as an ISO.

This is my first time setting up a linux mail server manually and I never knew it was so detailed!

<!-- gh-comment-id:92445473 --> @iyobo commented on GitHub (Apr 13, 2015): While we're at it, would it be a terrible thing to just use that VM provided for 1.2.1 as a production mail server? I was thinking how easy it would be to just use it as an ISO. This is my first time setting up a linux mail server manually and I never knew it was so detailed!

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@vingeni commented on GitHub (Apr 14, 2015):

Hello,

try this request, without the start/end parenthesis :

query = SELECT (mb.address || '@' || dom.name) FROM admin_mailbox mb
INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.id IN
(SELECT al_mb.mailbox_id FROM admin_alias_mboxes al_mb INNER JOIN
admin_alias al ON al_mb.alias_id=al.id INNER JOIN admin_domain dom ON
al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND
al.address='%u' AND al.enabled=1) UNION SELECT (al.address || '@' ||
dom.name) FROM admin_alias al INNER JOIN admin_domain dom ON
al.domain_id=dom.id WHERE al.id IN (SELECT al_al.to_alias_id FROM
admin_alias_aliases al_al INNER JOIN admin_alias al ON
al_al.from_alias_id=al.id INNER JOIN admin_domain dom ON
al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND
al.address='%u' AND al.enabled=1) UNION SELECT al.extmboxes FROM
admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE
dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 AND
al.extmboxes<>'';

vincent.

Le 13/04/2015 19:55, Iyobo Eki a écrit :

This is the query given to the query field in that generated file by
modoboa-django.py postfix_maps ...
Nothing changed. Spaced out for more legibility.
`
(
SELECT (mb.address || '@' || dom.name)
FROM admin_mailbox mb
INNER JOIN admin_domain dom ON mb.domain_id=dom.id
WHERE mb.id IN (
SELECT al_mb.mailbox_id
FROM admin_alias_mboxes al_mb
INNER JOIN admin_alias al ON al_mb.alias_id=al.id
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d'
AND dom.enabled=1
AND al.address='%u'
AND al.enabled=1
)
)

UNION (
SELECT (al.address || '@' || dom.name)
FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE al.id IN (
SELECT al_al.to_alias_id
FROM admin_alias_aliases al_al
INNER JOIN admin_alias al ON al_al.from_alias_id=al.id
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1
)
)

UNION (
SELECT al.extmboxes
FROM admin_alias al
INNER JOIN admin_domain dom ON al.domain_id=dom.id
WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND
al.enabled=1 AND al.extmboxes<>''
)
`

—
Reply to this email directly or view it on GitHub
https://github.com/tonioo/modoboa/issues/711#issuecomment-92445172.

<!-- gh-comment-id:92978514 --> @vingeni commented on GitHub (Apr 14, 2015): Hello, try this request, without the start/end parenthesis : query = SELECT (mb.address || '@' || dom.name) FROM admin_mailbox mb INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.id IN (SELECT al_mb.mailbox_id FROM admin_alias_mboxes al_mb INNER JOIN admin_alias al ON al_mb.alias_id=al.id INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1) UNION SELECT (al.address || '@' || dom.name) FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE al.id IN (SELECT al_al.to_alias_id FROM admin_alias_aliases al_al INNER JOIN admin_alias al ON al_al.from_alias_id=al.id INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1) UNION SELECT al.extmboxes FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 AND al.extmboxes<>''; ## vincent. Le 13/04/2015 19:55, Iyobo Eki a écrit : > This is the query given to the query field in that generated file by > modoboa-django.py postfix_maps ... > Nothing changed. Spaced out for more legibility. > ` > ( > SELECT (mb.address || '@' || dom.name) > FROM admin_mailbox mb > INNER JOIN admin_domain dom ON mb.domain_id=dom.id > WHERE mb.id IN ( > SELECT al_mb.mailbox_id > FROM admin_alias_mboxes al_mb > INNER JOIN admin_alias al ON al_mb.alias_id=al.id > INNER JOIN admin_domain dom ON al.domain_id=dom.id > WHERE dom.name='%d' > AND dom.enabled=1 > AND al.address='%u' > AND al.enabled=1 > ) > ) > > UNION ( > SELECT (al.address || '@' || dom.name) > FROM admin_alias al INNER JOIN admin_domain dom ON al.domain_id=dom.id > WHERE al.id IN ( > SELECT al_al.to_alias_id > FROM admin_alias_aliases al_al > INNER JOIN admin_alias al ON al_al.from_alias_id=al.id > INNER JOIN admin_domain dom ON al.domain_id=dom.id > WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND al.enabled=1 > ) > ) > > UNION ( > SELECT al.extmboxes > FROM admin_alias al > INNER JOIN admin_domain dom ON al.domain_id=dom.id > WHERE dom.name='%d' AND dom.enabled=1 AND al.address='%u' AND > al.enabled=1 AND al.extmboxes<>'' > ) > ` > > — > Reply to this email directly or view it on GitHub > https://github.com/tonioo/modoboa/issues/711#issuecomment-92445172.

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@tonioo commented on GitHub (Apr 30, 2015):

@buffonomics Hi, have you tried the proposed solution ?

<!-- gh-comment-id:97709679 --> @tonioo commented on GitHub (Apr 30, 2015): @buffonomics Hi, have you tried the proposed solution ?

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@tonioo commented on GitHub (Jun 11, 2015):

This issue was moved to modoboa/modoboa-admin#24

<!-- gh-comment-id:111059529 --> @tonioo commented on GitHub (Jun 11, 2015): This issue was moved to modoboa/modoboa-admin#24

kerem commented 2026-02-27 11:12:54 +03:00

Author

Owner

Copy link

@bernd-wechner commented on GitHub (Dec 30, 2022):

Hmmm, am getting this on webmail too, but see no clue in logs and wondering where "modoboa/modoboa-admin#24" is?

<!-- gh-comment-id:1367818273 --> @bernd-wechner commented on GitHub (Dec 30, 2022): Hmmm, am getting this on webmail too, but see no clue in logs and wondering where "modoboa/modoboa-admin#24" is?

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

Subscribe

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#659

No description provided.