Re: [Dbmail] Upgrade

2006-05-17 Thread Humberto Valiente
Sorry Paul, The version im running is 2.0.4. The procedure to upgrade to the version 2.0.10 is the same? Regards, Humberto On 5/16/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: Humberto Valiente wrote: > We are actually running and "very" but "very old version" of dbmail > More specifically,

Re: [Dbmail] Which util switch does the OPTIMIZE?

2006-05-17 Thread M. J. [Mike] OBrien
dbmail-util -a -y every night at 11pm... locks up the DB until around 7 the next morning Matt: Do you mean the process is running that whole time? Yikes. Something sounds very wrong. DB schema? Slow hardware. (I see a lot of high-end stuff so maybe I don't know.) How many mailboxes is that? Ho

Re: [Dbmail] Which util switch does the OPTIMIZE?

2006-05-17 Thread Curtis Maurand
If your not careful and you don't run mysqloptimize -o -u -p against the innodb database on a regular basis, your database will grow to an unwieldy size. However, the database will be locked while you do this. At one point, I ran out of disk space. I ended up having to dump all of the databas

Re: [Dbmail] Upgrade

2006-05-17 Thread Paul J Stevens
Humberto Valiente wrote: > Sorry Paul, > > The version im running is 2.0.4. > The procedure to upgrade to the version 2.0.10 is the same? You should be able to upgrade without *any* problem then. If there have been any changes at all, they will have been tiny. # added ON UPDATE CASCADE to create

Re: [Dbmail] Backup and Restore

2006-05-17 Thread Paul J Stevens
Niblett, David A wrote: > Gee, and I was just working on extracting the relevant queries > from the 2.1 code so that I might just do that very thing. :) > > I'm looking at a php script right now to do this right now. So > since it's in your head I'll try some extraction. > > 1) When you mention t

Re: [Dbmail] Searching body returns nothing.

2006-05-17 Thread Paul J Stevens
Jack Liu wrote: > Just installed 2.1.6 and so far, everything is running well. > Performance is greatly improved over 2.0 but the only problem is that > searching the message body always returns no results. I can search > subjects and recipients successfully. Please include a level 5 log. > > I

[Dbmail] quota

2006-05-17 Thread Andrea Fino
Hi to all, I am begginning to play/test with dbamil (got the stable release for now) and I am wondering how could I let know users about their quota usage, and prevent errors for mailbox full. Regards, Andrea Fino -- Andrea Fino 8-) - "Sistemi su misura di qualita' industriale" "Handcra

RE: [Dbmail] quota

2006-05-17 Thread Niblett, David A
We run a script that looks through the database each night and if a user is >=95% of their quota we send them an Email letting them know. We also use it as a placeholder to see if they haven't read it in 30 days time, at which point we do nothing currently, just statistic gathering. Eventually we

Re: [Dbmail] Searching body returns nothing.

2006-05-17 Thread Jack Liu
Here you go: Searching "Entire Message" with Thunderbird 1.5.0.2: May 17 10:18:06 maildb dbmail/imap4d[27402]: COMMAND: [14 uid SEARCH UNDELETED BODY "report"] May 17 10:18:06 maildb dbmail/imap4d[27402]: arg[0]: 'SEARCH' May 17 10:18:06 maildb dbmail/imap4d[27402]: arg[1]: 'UNDELETED' May 17 10

Re: [Dbmail] Which util switch does the OPTIMIZE?

2006-05-17 Thread Ming-Wei Shih
I had the same problem, since then I switched to postgresql with the compression on the text table, it's actually speedier than mysql+innodb Ming-Wei Curtis Maurand wrote: > If your not careful and you don't run mysqloptimize -o -u > -p against the innodb database on a > regular basis, your dat