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