> On Wed, 2011-03-16 at 11:38 +0100, i...@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@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,
