Re: [Dovecot] Quota plugin and SQL

2010-03-16 Thread Timo Sirainen
On Sun, 2010-03-07 at 14:49 +0100, Pascal Volk wrote: > On 03/07/2010 01:53 PM Pascal Volk wrote: > > map { > > pattern = priv/quota/storage > > table = quota > > username_field = uid > > username_var = %{uid} > > value_field = bytes > > } > > BTW: This also w

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread Pascal Volk
On 03/07/2010 01:53 PM Pascal Volk wrote: > map { > pattern = priv/quota/storage > table = quota > username_field = uid > username_var = %{uid} > value_field = bytes > } BTW: This also would make it possible to have 'domain quota' (only), when th

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread Pascal Volk
On 03/07/2010 11:02 AM David wrote: > On 07/03/2010 09:58, Timo Sirainen wrote: >> On Sat, 2010-03-06 at 22:12 +, David wrote: >> Not currently. If you're using PostgreSQL, you could create a view and >> update-rule though. I don't know if that's possible with MySQL. >> > Thanks Timo. Is t

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread Leonardo Rodrigues
Em 06/03/2010 19:12, David escreveu: Is there any way to modify the queries used to split out username into localpart and domain? This would enable me to put the current quota information in my main mailbox table and display it to users in my admin interface. i'm successfully using a

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread David
On 07/03/2010 09:58, Timo Sirainen wrote: On Sat, 2010-03-06 at 22:12 +, David wrote: I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a database schema for using quota. For 1.2, this includes a username, bytes and messages. Is there any way to modify the queries

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread Timo Sirainen
On Sat, 2010-03-06 at 22:12 +, David wrote: > I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a > database schema for using quota. For 1.2, this includes a username, > bytes and messages. > > Is there any way to modify the queries used to split out username into > lo

Re: [Dovecot] Quota plugin and SQL

2010-03-07 Thread David
On 07/03/2010 03:17, Leeman Strout wrote: On 3/6/2010 5:12 PM, David wrote: I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a database schema for using quota. For 1.2, this includes a username, bytes and messages. Is there any way to modify the queries used to split out u

Re: [Dovecot] Quota plugin and SQL

2010-03-06 Thread Leeman Strout
On 3/6/2010 5:12 PM, David wrote: I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a database schema for using quota. For 1.2, this includes a username, bytes and messages. Is there any way to modify the queries used to split out username into localpart and domain? This wou

Re: [Dovecot] Quota plugin and SQL

2010-03-06 Thread Bradley Giesbrecht
On Mar 6, 2010, at 2:12 PM, David wrote: I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a database schema for using quota. For 1.2, this includes a username, bytes and messages. Is there any way to modify the queries used to split out username into localpart and

[Dovecot] Quota plugin and SQL

2010-03-06 Thread David
I have read through http://wiki.dovecot.org/Quota/Dict, which suggests a database schema for using quota. For 1.2, this includes a username, bytes and messages. Is there any way to modify the queries used to split out username into localpart and domain? This would enable me to put the curren