Re: [vchkpw] --enable-mysql-limits question

2006-03-22 Thread Jeremy Kitchen
On Wednesday 22 March 2006 08:54, Juan Jose Miquel wrote:
> Thanks for your answered,
>
> I found that this option create an additional column in the vpopmail table,
> the column  use the Maildirsize notation, i.e. 20971520S for 20MB and
> NOQUOTA for unlimited size.
>
> The problem I have is that the info is generated in two places (the
> maildirsize file and in the mysql DB). So my new question is:
> ¿Is there any function that manipulates both registers or do I have to
> duplicate any change twice.

you can't store the maildirsize in mysql.  qmail-pop3d, courier-imapd, etc are 
not SQL aware (and shouldn't be) and therefore cannot update it.  If there is 
a maildirsize field being added to the mysql database, it's probably an 
ancient artifact of someone trying to implement the functionality in the 
past.

-Jeremy

-- 
Jeremy Kitchen ++ [EMAIL PROTECTED]

In the beginning was The Word and The Word was Content-type: text/plain
  -- The Word of Bob.


pgpnwVV6FzmKZ.pgp
Description: PGP signature


Re: [vchkpw] --enable-mysql-limits question

2006-03-22 Thread Juan Jose Miquel

Thanks for your answered,

I found that this option create an additional column in the vpopmail table, 
the column  use the Maildirsize notation, i.e. 20971520S for 20MB and 
NOQUOTA for unlimited size.


The problem I have is that the info is generated in two places (the 
maildirsize file and in the mysql DB). So my new question is:
¿Is there any function that manipulates both registers or do I have to 
duplicate any change twice.


Best Regards
Juan

- Original Message - 
From: "Shane Chrisp" <[EMAIL PROTECTED]>

To: 
Sent: Wednesday, March 22, 2006 12:36 PM
Subject: Re: [vchkpw] --enable-mysql-limits question



On Wed, 2006-03-22 at 12:21 -0400, Juan Jose Miquel wrote:

Hello everybody,
I changed my configuration to use --enable-mysql-limits, but I don't find 
any info inside the DB.

the files maildirsize where generated again.

¿How should be working this configuration option?

Thanks,
Juan


This option is for the number of email accounts, account quota's etc,
not thr maildirsize file.

(not sure if it was you that asked about the maildirsize file
yesterday?)
There is a Maildir++ patch from memory in the contrib dir of vpopmail to
fix something like what you describe. Most of the toasters out there i
think have already included this patch, but maybe you havnt?






Re: [vchkpw] --enable-mysql-limits question

2006-03-22 Thread Shane Chrisp
On Wed, 2006-03-22 at 12:21 -0400, Juan Jose Miquel wrote:
> Hello everybody,
> I changed my configuration to use --enable-mysql-limits, but I don't find any 
> info inside the DB.
> the files maildirsize where generated again.
>  
> ¿How should be working this configuration option?
>  
> Thanks,
> Juan

This option is for the number of email accounts, account quota's etc,
not thr maildirsize file.

(not sure if it was you that asked about the maildirsize file
yesterday?)
There is a Maildir++ patch from memory in the contrib dir of vpopmail to
fix something like what you describe. Most of the toasters out there i
think have already included this patch, but maybe you havnt?