Re: [Dbmail] DBMail 2.0 final

2004-10-27 Thread sumbry
> orphaned messageblks is exactly the sort of stuff dbmail-util is supposed to > look for. > > if dbmail-util -r doesn't clean out those blks, we have a bug. I pointed this out on dbmail-dev a little while ago as I had the same problem. dbmail-util doesn't yet fix these. select count(*) from dbm

[Dbmail] About permissions.

2004-10-27 Thread stef
Hello, I use dbmail for a while now, and I'm very happy with it. New in dbmail is ACL and the permissions a user has to a mailbox. When I look at the propertiesdialog of the inbox of some user, with the imapprotocol, I see that the user can have different rights. The useraccount used to login

[Dbmail] IMAPD consumes massive cputime and mysql-ressources

2004-10-27 Thread Simon Lange
Hi, i became aware that dbmail-imapd does consume pretty fast a lot of cpu time. e.g. i do connect via thunderbird to my account and all i do is quering a list of message in a folder it takes him up to 50% cputime (on a AMD AthlonXP2000+ 512MB). Also i came aware that imapd sporadic starts s

[Dbmail] Auto Replies

2004-10-27 Thread Simon Lange
Hi, i have insert an auto reply row into the dbmail_auto_replies table. dbmail-lmtpd does state that its working so far. BUT it pipe.c never finds a from or reply-to field so it stops in the middle saying it has not found any address. so the question is: where must that field be?! in the AUTO_

Re: [Dbmail] DBMail 2.0 final

2004-10-27 Thread [EMAIL PROTECTED]
Hey Sumbry and List: If you still have orphaned messages I offer a solution. DBMA will find and mark orphaned messages for deletion. (DBMA V2.1.2) http://library.mobrien.com/dbmailadministrator/ Untar it. Open in browser. Configure from the GUI. Select "Update Delete Status" checkbox and press "

[Dbmail] DbMailAdministrator (DBMA V2.1.2) Rats out Rogues

2004-10-27 Thread [EMAIL PROTECTED]
Hello List: If you have (rogue) orphaned messages DBMA will 'rat them out' and serve them up to the next crontab 'dbmail-util -d' firing squad. DBMA finds and marks orphaned messages for deletion. Get DbMail Administratior - DBMA V2.1.2 at http://library.mobrien.com/dbmailadministrator/ untar

Re: [Dbmail] IMAPD consumes massive cputime and mysql-ressources

2004-10-27 Thread Mikhail Ramendik
Simon Lange wrote: > i became aware that dbmail-imapd does consume pretty fast a lot of cpu > time. > e.g. i do connect via thunderbird to my account and all i do is quering > a list of message in a folder it takes him up to 50% cputime (on a AMD > AthlonXP2000+ 512MB). This is a known issue.

RE: [Dbmail] dbmail-smtp slow

2004-10-27 Thread Simon Gray
> I don't think that disabling quota checks will get you any real speed > improvement. The real speed issues here are in the starting of the > dbmail-smtp process, setting up database connection etc. > > As Paul indicated, we can get better performance if we enable > dbmail-smtp to receive several

[Dbmail] Async logging has fixed performance issues

2004-10-27 Thread Mikhail Ramendik
Hello, Thanks to Alessandro Magnolo for pointing out this solution. Switching to async logging for mail has resulted in even better performance than with hacked and redirected log-to-stderr. http://www.postfix.org/LINUX_README.html I'm a tech writer, and I'm quite willing to write a README.logg

RE: [Dbmail] dbmail-smtp slow

2004-10-27 Thread Mark Mackay - Orcon
We've disabled the quota checks in a 1.x version and it has produced a major speed gain in the database. Previously our database was spiking to high loads doing the SUM() calcs, so I wouldn't underestimate the cost of this when you get to large message stores. If possible - it would be great to ha

Re: [Dbmail] IMAPD consumes massive cputime and mysql-ressources

2004-10-27 Thread Mikhail Ramendik
Simon Lange wrote: > Also i came aware that imapd sporadic starts spamming the mysql database > with queries. this increases the load enormous and the system becomes > unusable. last time i metered imapd/mysql it took 262.000queries/sec Is this 262 queries/sec or 262 thousand queries/sec? 262 q

Re: [Dbmail] IMAPD consumes massive cputime and mysql-ressources

2004-10-27 Thread Simon Lange
Hi Mikhail Ramendik wrote: Simon Lange wrote: Also i came aware that imapd sporadic starts spamming the mysql database with queries. this increases the load enormous and the system becomes unusable. last time i metered imapd/mysql it took 262.000queries/sec Is this 262 queries/sec