[Dbmail] Ugly, ugly load averages

2003-04-05 Thread Chris Nolan
Hi, I've set up DBMail with Postfix and the load averages are damned ugly, as in 6.00 - 11.00 on an Athlon XP 1900+ with 256MB memory. The load average drops to 0.34 when I stop Postfix though. I've noticed that there are heaps of instances of dbmail-smtp running all the time and thus think t

Re: [Dbmail] Ugly, ugly load averages

2003-04-05 Thread Cedric Veilleux
dbmail-smtp is the part inserting incoming messages in the database if Im not mistaken. If you have a lot of dbmail-smtp instances running, you must be receiving a lot of mail. You might want to find out what is all this incoming mail.. normal traffic? spam? outlook viruses? Le 4 Avril 2003

Re: [Dbmail] Ugly, ugly load averages

2003-04-05 Thread Chris Nolan
Cedric Veilleux wrote: Seemingly not! There have only been 13 messages added to the database in over 3 hours! Additionally, netstat shows no connections on port 25! Chris dbmail-smtp is the part inserting incoming messages in the database if Im not mistaken. If you have a lot of dbmail-smtp i

[Dbmail] Load problems solved

2003-04-05 Thread Chris Nolan
Hi all, My load is now less than 0.1 . Uninstalling Postfix and letting the RPM script take care of it's directory permissions solved the problem. I guess the only thing my fumbling can teach anyone is that Postfix+chroot (Mandrake 9.0 does this by default) requires a bit more thought. Chris

Re: [Dbmail] migrations issues and table contraints

2003-04-05 Thread Michael Kummer
> alter table mailboxes add foreign key (owner_idnr) references > users(user_idnr) on delete cascade; > alter table messages add foreign key (mailbox_idnr) references > mailboxes(mailbox_idnr) on delete cascade; > alter table messageblks add foreign key (message_idnr) references > messages(message_

Re: [Dbmail] Ugly, ugly load averages

2003-04-05 Thread Aaron Stone
Perhaps you've got a bounce that cannot be delivered and is constantly retrying... take a look at the live mail log and see if there's a consistent failure to deliver. Aaron On Sat, 5 Apr 2003, Chris Nolan wrote: > Cedric Veilleux wrote: > Seemingly not! There have only been 13 messages added t

[Dbmail] migration from RC3 myisam to latest cvs innodb

2003-04-05 Thread Michael Kummer
hi! is it possible without loosing user data/mails? and how should it be accomplished. i guess there exists no converter script for my old myisam tables to the latest db layout using innodb. any ideas? Mit freundlichen Grüßen / yours sincerly Michael Kummer (GF) -- [M]ichael.[K]ummer.[I]ncor

Re: [Dbmail] redundancy patch

2003-04-05 Thread Michael Kummer
hi again! because I can't find any hint in the mysql docs about using master-master replication I'd be very happy if you could explain it how you managed it. Mit freundlichen Grüßen / yours sincerly Michael Kummer (GF) -- [M]ichael.[K]ummer.[I]ncorporated Lieferinger-Hauptstrasse 47 - A 5020 S

Re: [Dbmail] migrations issues and table contraints

2003-04-05 Thread Chris Nolan
Hi everyone, The indexes and foreign key statements below are great - just make sure you run dbmail-maintanence -f first! You'll probably get plenty of complaints about unconnected messages otherwise. Chris Richard Houston wrote: All, First off I love what the developers are doing with db

[Dbmail] Dbmail + horde + imp + turba

2003-04-05 Thread Jacques Beaudoin
Im experimenting with horde+imp+turba webmail.. I find imp webmail interface great. Im trying to have turba read dbmail aliases table with no succes Can someone post a working turba sources.php for dbmail. Thanks Jacques/Montreal/Canada

[Dbmail] Interesting alias problem

2003-04-05 Thread Chris Nolan
Hi all, My DBMail alias table has just recently gotten into a mess, with some aliases appearing 3 times, all pointing to different users (for instance, the username that I use has been removed and added three times, explaining that). Has anyone else encountered this? If so, I might build a to

Re: [Dbmail] migrations issues and table contraints

2003-04-05 Thread Eelco van Beek
hi Richard, Thanks for the kind remarks! I plan on making dbmail the center piece of a scalable mail hub that will include other feature and am wondering what kind of large scale, both number of users and message throughput per day, people have set up and in production. The largest mailsite

Re: [Dbmail] migrations issues and table contraints

2003-04-05 Thread Paul Stevens
Michael Kummer wrote: alter table mailboxes add foreign key (owner_idnr) references users(user_idnr) on delete cascade; alter table messages add foreign key (mailbox_idnr) references mailboxes(mailbox_idnr) on delete cascade; alter table messageblks add foreign key (message_idnr) references messa

Re: [Dbmail] migration from RC3 myisam to latest cvs innodb

2003-04-05 Thread Paul Stevens
Michael Kummer wrote: hi! is it possible without loosing user data/mails? and how should it be accomplished. i guess there exists no converter script for my old myisam tables to the latest db layout using innodb. Converting from rc3 to 1.0+ can be done with the statements in the attachment.

Re: [Dbmail] redundancy patch

2003-04-05 Thread Aaron Stone
This has been discussed at length on the mailing list; see the archives for pertinent arguments on both sides. In a nutshell: don't do it. Aaron On Sat, 5 Apr 2003, Michael Kummer wrote: > hi again! > > because I can't find any hint in the mysql docs about using master-master > replication I'd

[Dbmail] Road map

2003-04-05 Thread Richard Houston
Hi all, I was wondering if there is a road map of where dbmail is and will be going? Also is there a wish list out there and if so where do we send our suggestions to? Thanks and keep up the good work. Thanks Rich

[Dbmail] mysql redundant indexes

2003-04-05 Thread Blake Mitchell
I've noticed that in several places, there are redundant indexes created on the same column. For example, in sql/mysql/create_tables_innoDB.mysql you have this: CREATE TABLE tmpmessage ( PRIMARY KEY (message_idnr), KEY message_idnr (message_idnr), UNIQUE message_idnr_2 (mess

Re: [Dbmail] Re: Dbmail digest, Vol 1 #558 - 5 msgs

2003-04-05 Thread Richard Houston
Hi all, Where might I find this patch? Does it address the deletion of folders in Squirrelmail as well? Thanks in advance. Rich On Tue, 2003-04-01 at 14:06, Robert L. Tom wrote: > Tim, > > I posted the fix for squirrelmail > not creating folders etc etc. > I am using SM with dbmail + qmail. >

[Dbmail] Re: redundancy patch

2003-04-05 Thread Lou Kamenov
Aaron Stone writes: This has been discussed at length on the mailing list; see the archives for pertinent arguments on both sides. In a nutshell: don't do it. Aaron most of the arguments were not sufficient to drive me away from the whole idea, assuming will not bring a solution nor will i