Hello,
Can someone tell me if it’s possible to configure dovecot to answer quota information about real mailbox when I query a postfix alias mailbox (this information is actually in a mysql database) ?
Example :
doveadm quota get - u alias@domain.com doveadm(alias@domain.com): Fatal: User doesn't exist
doveadm quota get - u realmailbox@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
I’d like to have this result : doveadm quota get - u alias@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
doveadm quota get - u realmailbox@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
Thanks for your help.
Alexandre.
it is the job of postfix to do this, aliases are just that, aliases of the real mail account, they do not exist in real storage, else, they would not be aliaes.
On 6/29/14, Alexandre Ellert <aellert@numeezy.com> wrote:
Hello,
Can someone tell me if it's possible to configure dovecot to answer quota information about real mailbox when I query a postfix alias mailbox (this information is actually in a mysql database) ?
Example :
doveadm quota get - u alias@domain.com doveadm(alias@domain.com): Fatal: User doesn't exist
doveadm quota get - u realmailbox@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
I'd like to have this result : doveadm quota get - u alias@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
doveadm quota get - u realmailbox@domain.com Quota name Type Value Limit % user STORAGE 2048853 2048000 100 user MESSAGE 6783 - 0
Thanks for your help.
Alexandre.
Le 29 juin 2014 à 06:24, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
it is the job of postfix to do this, aliases are just that, aliases of
the real mail account, they do not exist in real storage, else, they would not be alias.
The problem i’m trying to solve is about dovecot capability to serve quota status via Postfix policy server protocol. It works fine when the destination address is a real mailbox, but if it’s a Postfix alias, then the email is not rejected because dovecot doesn’t know this user. Maybe it’s a wrong idea to try to make Postfix alias visible to dovecot.
Do you have another suggestion ?
On 6/29/14, Alexandre Ellert <aellert@numeezy.com> wrote:
Le 29 juin 2014 à 06:24, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
it is the job of postfix to do this, aliases are just that, aliases of
the real mail account, they do not exist in real storage, else, they would not be alias.
The problem i'm trying to solve is about dovecot capability to serve quota status via Postfix policy server protocol. It works fine when the destination address is a real mailbox, but if it's a Postfix alias, then the email is not rejected because dovecot doesn't know this user. Maybe it's a wrong idea to try to make Postfix alias visible to dovecot.
Do you have another suggestion ?
of course its wrong mail aliases are for MTA's *only* its not for dovecot (or any pop3/imap server), if postfix is not saying oh ok alias foo really goes to user bar, do we;ll check out bar's quota, status etc,, then ur postfix is foobarred somehow.
On 30.6.2014 12:33, Nick Edwards wrote:
On 6/29/14, Alexandre Ellert <aellert@numeezy.com> wrote:
Le 29 juin 2014 à 06:24, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
it is the job of postfix to do this, aliases are just that, aliases of
the real mail account, they do not exist in real storage, else, they would not be alias.
The problem i'm trying to solve is about dovecot capability to serve quota status via Postfix policy server protocol. It works fine when the destination address is a real mailbox, but if it's a Postfix alias, then the email is not rejected because dovecot doesn't know this user. Maybe it's a wrong idea to try to make Postfix alias visible to dovecot.
Do you have another suggestion ?
of course its wrong mail aliases are for MTA's *only* its not for dovecot (or any pop3/imap server), if postfix is not saying oh ok alias foo really goes to user bar, do we;ll check out bar's quota, status etc,, then ur postfix is foobarred somehow.
I'm not completely sure about that. If you want to use Dovecot's quota-status to reject message during SMTP session, Postfix' smtpd process needs to do that and - to my knowledge - it's only able to pass recipient address, not the aliases involved.
I was looking for a solution to this few months ago as well. In the end I created sort of policy service proxy between Postfix and Dovecot. The proxy looks up aliases in database, converts them into real users and asks Dovecot about those. Final result is then reported back to postfix/smtpd.
I've the same problem.
Dovecot can reply REJECT when Postfix ask for know the quota of the real user. But if the email it's alias, Dovecot does not know the email and reply DUNNO, but when the mail must be delivred by the LDA, Dovecot reject because the user it's over quota.
I search since several weeks how to fix that and for postfix ask the quota-service with the real user email and not the alias. Because Postfix know the real user email because it's search it on the first time before ask Dovecot...
I don't understand that postfix can't have a feature for check the quota-service with the real user email and not the alias...
It's possible that I was wrong and not really understand the Postfix doku (that's really possible).
If anobody have one idea that would be great, because I'm really lost, and I think i'm not alone :)
Bests Regards, Nathan
----- Mail original ----- De: "Jiri Bourek" <bourek@thinline.cz> À: dovecot@dovecot.org Envoyé: Lundi 30 Juin 2014 13:37:26 Objet: Re: postfix alias and dovecot quota
On 30.6.2014 12:33, Nick Edwards wrote:
On 6/29/14, Alexandre Ellert <aellert@numeezy.com> wrote:
Le 29 juin 2014 à 06:24, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
it is the job of postfix to do this, aliases are just that, aliases of
the real mail account, they do not exist in real storage, else, they would not be alias.
The problem i'm trying to solve is about dovecot capability to serve quota status via Postfix policy server protocol. It works fine when the destination address is a real mailbox, but if it's a Postfix alias, then the email is not rejected because dovecot doesn't know this user. Maybe it's a wrong idea to try to make Postfix alias visible to dovecot.
Do you have another suggestion ?
of course its wrong mail aliases are for MTA's *only* its not for dovecot (or any pop3/imap server), if postfix is not saying oh ok alias foo really goes to user bar, do we;ll check out bar's quota, status etc,, then ur postfix is foobarred somehow.
I'm not completely sure about that. If you want to use Dovecot's quota-status to reject message during SMTP session, Postfix' smtpd process needs to do that and - to my knowledge - it's only able to pass recipient address, not the aliases involved.
I was looking for a solution to this few months ago as well. In the end I created sort of policy service proxy between Postfix and Dovecot. The proxy looks up aliases in database, converts them into real users and asks Dovecot about those. Final result is then reported back to postfix/smtpd.
On 30 Jun 2014, at 15:01, Nathan Schultheiss <nathan@schultheiss.fr> wrote:
...
I search since several weeks how to fix that and for postfix ask the quota-service with the real user email and not the alias. Because Postfix know the real user email because it's search it on the first time before ask Dovecot...
I don't understand that postfix can't have a feature for check the quota-service with the real user email and not the alias...
It's possible that I was wrong and not really understand the Postfix doku (that's really possible).
You’re not: http://www.postfix.org/SMTPD_POLICY_README.html#protocol
If anobody have one idea that would be great, because I'm really lost, and I think i'm not alone :)
One idea is to use the same data source for the userdb of postfix and dovecot. Mail alias data that postfix uses would then also become available for dovecot. Dovecot would then be able to correctly resolve mail aliases to users and provide useful quota information about the mailbox.
On 6/30/14, Jiri Bourek <bourek@thinline.cz> wrote:
On 30.6.2014 12:33, Nick Edwards wrote:
On 6/29/14, Alexandre Ellert <aellert@numeezy.com> wrote:
Le 29 juin 2014 à 06:24, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
it is the job of postfix to do this, aliases are just that, aliases of
the real mail account, they do not exist in real storage, else, they would not be alias.
The problem i'm trying to solve is about dovecot capability to serve quota status via Postfix policy server protocol. It works fine when the destination address is a real mailbox, but if it's a Postfix alias, then the email is not rejected because dovecot doesn't know this user. Maybe it's a wrong idea to try to make Postfix alias visible to dovecot.
Do you have another suggestion ?
of course its wrong mail aliases are for MTA's *only* its not for dovecot (or any pop3/imap server), if postfix is not saying oh ok alias foo really goes to user bar, do we;ll check out bar's quota, status etc,, then ur postfix is foobarred somehow.
I'm not completely sure about that. If you want to use Dovecot's quota-status to reject message during SMTP session, Postfix' smtpd process needs to do that and - to my knowledge - it's only able to pass recipient address, not the aliases involved.
I was looking for a solution to this few months ago as well. In the end I created sort of policy service proxy between Postfix and Dovecot. The proxy looks up aliases in database, converts them into real users and asks Dovecot about those. Final result is then reported back to postfix/smtpd.
http://dovecot.2317879.n4.nabble.com/Postfix-aliases-with-quota-status-servi... search for post from Ulrich Zehl
Le 1 juil. 2014 à 04:57, Nick Edwards <nick.z.edwards@gmail.com> a écrit :
http://dovecot.2317879.n4.nabble.com/Postfix-aliases-with-quota-status-servi... search for post from Ulrich Zehl
Thanks for the link, I use a SQL backend containing user and alias data. So I've changed the user_query to include alias and it's actually working fine on my test environnement.
Even though it's an older thread, I wanted to shed some light why Dovecot refuses the alias address from Postfix when querying for quotas.
Dovecot's "quota-status" service is supported only in Postfix's smtpd_recipient_restrictions phase. If you'd try to use it later, in the "smtpd_data_restrictions" phase, the service returned with a permissive DUNNO and warned that:
Received policy query from MTA in unexpected state DATA (service can only be used for recipient restrictions).
However, Postfix evaluates aliases only _after_ the recipient_restrictions phase completed. Even technically, Dovecot couldn't receive the resolved e-mail address.
But even in the unsupported DATA state, Postfix doesn't send the resolved alias. During the communication between the two services, Postfix sends the original e-mail address in the "recipient" attribute to Dovecot, and not the resolved alias, although it's now aware of it.
The solution is to do the same alias lookup on Dovecot side, too (as you mentioned you did it). An example userdb SQL that handles it:
userdb sql {
driver = sql
query = SELECT concat("/var/spool/mail/", maildir) AS home,
(5000 + id) AS uid,
(5000 + id) AS gid,
concat(quota, 'B') AS quota_storage_size
FROM mailbox
WHERE active = '1'
AND (username = '%{user}'
OR id IN
(SELECT m2.id
FROM alias
JOIN mailbox m2 ON alias.goto = m2.username
AND alias.active = 1
WHERE alias.address = '%{user}'))
iterate_query = SELECT username FROM mailbox WHERE active = '1'}
Ákos
participants (6)
-
Alexandre Ellert
-
Jiri Bourek
-
Matthijs de Groot
-
Nathan Schultheiss
-
Nick Edwards
-
Ákos Szőts