[Dovecot] Question howto wiki.dovecot.org about quotas using dict
Hi,
I am configuring a server with postfix and dovecot with virtual domains and using quota. To implement quota followed the documentation of the link http://wiki.dovecot.org/Quota/Dict, did not understand what you mean the field "where_field = path" would be the path on the filesystem of your mailbox? I would have to create the table that he says in the documentation or can I force a value with concat and using the AS (ie select '/var/vmail/domain/user' as path from table) ?
Regards.
Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Tue, 23 Mar 2010, Ricardo Barbosa wrote:
I am configuring a server with postfix and dovecot with virtual domains and using quota. To implement quota followed the documentation of the link http://wiki.dovecot.org/Quota/Dict, did not understand what you mean the field "where_field = path" would be the path on the filesystem of your mailbox?
"path" is a field in the table, see the table definition.
I would have to create the table that he says in the documentation or can I force a value with concat and using the AS (ie select '/var/vmail/domain/user' as path from table) ?
As far as I know the query is pre-compiled in the code.
Regards,
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)
iQEVAwUBS6oMn7+Vh58GPL/cAQJ4fQf/djBn1sAxPmIcTi2XaoIhDwOaI+sF9de8 sGluOeFvKWvJ/D9M8wopC+qZPZ4d578Kd7tLEpImb2TMMUkaRR43VqKSeZUUjl8Q 0aU3+o4o2u8qYhQpbphGgCIWy/oRY05+hUZX0ArBBH1s11SQdkHWsaqNLKUuyJva Zk/Rp5mlceueOMtxZE8PEH61KAyYC7/aYy6jtd5ckrFhWU2Qznwzn/gni9RbWKPk LcizUl8RqkEqiZklgCCynjFo0Ujl3vxSSjL+JQNh+E9sjnoWkvM1dPGyKVrHa9+J EB+Il69HsXS/v8RCg7z9AN2nTylxxdc2wc7Mhcp8iQz/7mT9+l6wjA== =JSam -----END PGP SIGNATURE-----
Hi Steffen,
where I find the defnicoes the table only displays the link
create table quota ( username varchar(255) not null, path varchar(100) not null, current integer, primary key (username, path) ); and I understand that the path field and a varchar so I asked if it would be the path of the file system where the mailbox is the users. If you have to create the table I can not take advantage of that exists. Correct?
Att.
--- Em qua, 24/3/10, Steffen Kaiser skdovecot@smail.inf.fh-brs.de escreveu:
De: Steffen Kaiser skdovecot@smail.inf.fh-brs.de Assunto: Re: [Dovecot] Question howto wiki.dovecot.org about quotas using dict Para: dovecot@dovecot.org Cc: dovecot@dovecot.org Data: Quarta-feira, 24 de Março de 2010, 12:59
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Tue, 23 Mar 2010, Ricardo Barbosa wrote:
I am configuring a server with postfix and dovecot with virtual domains and using quota. To implement quota followed the documentation of the link http://wiki.dovecot.org/Quota/Dict, did not understand what you mean the field "where_field = path" would be the path on the filesystem of your mailbox?
"path" is a field in the table, see the table definition.
I would have to create the table that he says in the documentation or can I force a value with concat and using the AS (ie select '/var/vmail/domain/user' as path from table) ?
As far as I know the query is pre-compiled in the code.
Regards,
- -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)
iQEVAwUBS6oMn7+Vh58GPL/cAQJ4fQf/djBn1sAxPmIcTi2XaoIhDwOaI+sF9de8 sGluOeFvKWvJ/D9M8wopC+qZPZ4d578Kd7tLEpImb2TMMUkaRR43VqKSeZUUjl8Q 0aU3+o4o2u8qYhQpbphGgCIWy/oRY05+hUZX0ArBBH1s11SQdkHWsaqNLKUuyJva Zk/Rp5mlceueOMtxZE8PEH61KAyYC7/aYy6jtd5ckrFhWU2Qznwzn/gni9RbWKPk LcizUl8RqkEqiZklgCCynjFo0Ujl3vxSSjL+JQNh+E9sjnoWkvM1dPGyKVrHa9+J EB+Il69HsXS/v8RCg7z9AN2nTylxxdc2wc7Mhcp8iQz/7mT9+l6wjA== =JSam -----END PGP SIGNATURE-----
____________________________________________________________________________________Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Wed, 24 Mar 2010, Ricardo Barbosa wrote:
asked if it would be the path of the file system where the mailbox is the users. If you have to create the table I can not take advantage of that exists. Correct?
Well, the table holds values internal to Dovecot, so you should not assume any semantic of the content. IMHO it's the mailbox name.
Regards,
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux)
iQEVAwUBS6oQyr+Vh58GPL/cAQKB3AgAyI4NKugOSsx2gbN7KnMGBw7Rz8go5dzg AU3w/abmyUDcU8iMO1r2HjWzRJZNdxSxLg+aEe8qdN4IeTV9Oq4Kt6fZfCOEmPWa 58iOf3rsS0ZpwY3E0OvAsULNpORuQBeF0LnFkqau9qXQLfeX2TbyGvK7iX4iFOZa 86m1CWrS6mb+ehsvL7AaAqlmYp2fCkUnTar2d2SAdsTIiHSSy1daOFS7/5uq3xZu Xrlt2eJl38T+PjONPAvk4/TirnmfT8HHzcfn2UpbyIzaIbrkuDp8+5j1i1s/uXFx WBsZ+RZCINLbeAGa2zkWD4tJJ7FmJ90yG0lCJdC3Nurjeh54RIh2qw== =n81R -----END PGP SIGNATURE-----
participants (2)
-
Ricardo Barbosa
-
Steffen Kaiser