[Dovecot] dovecot 1.2 quota with local users

[iti at promax.media.pl]

> On Wed, 2011-03-16 at 11:38 +0100, iti at promax.media.pl wrote:
>> I got problem with setting quota from mysql for local users. In database
>> are only information with quota. Password are store in passwd/shadow.
>
> You mean you only want quota limits to be listed in SQL, right? Then you
> don't need to use dict quota at all (or especially not sql dict).

Yes, only information in sql should be about quota.
E.g my table is:

Select * from quota;

+---------------------------+-------+----------+
| username                  | bytes | messages |
+---------------------------+-------+----------+
| user at test com              |  3000 |     1000 |
+---------------------------+-------+----------+

All other information are now sourced from PAM ( users info, passwords etc.).
Is that possible to deliver some information about user as it is now (PAM)
and only quota information in sql table?

>
> So what you need to use is passdb pam and userdb sql. In userdb sql you
> need to specify the user_query. You didn't give much information about
> your current setup that I'd assume is already working without working
> quota. http://wiki2.dovecot.org/AuthDatabase/SQL anyway has information
> about user_query (you can ignore the password_query).
>

You mean:

userdb sql {
  args = /etc/dovecot/dovecot-sql.conf
}


How should look like sql query in dovecot-sql.conf for table above ?

regards,