[Dbmail] Lists of aliases

2002-07-27 Thread Bruno Paz
Hello, I'm looking for a minimal implementation of a mailist... I've read the documentation (dbmail_manual.pdf), but i couldn't find anything about it.. On the aliases table we can put this alias_idnr alias deliver_to client_id 2893 [EMAIL

Re: [Dbmail] Lists of aliases

2002-07-27 Thread Cedric Veilleux
Hi, I think that if you have two or more entries in the aliases table with same "alias" field but different "deliver_to" field, the message will be delivered to each deliver_to entry. So you can have one entry for each subscribers in the aliases table and it should work.. Cedric O

Re: [Dbmail] SpamAssassin, dbmail, and postfix

2002-07-27 Thread eric
> Please let me know what you think. I'm not familiar with mysql or dbi, but I can point out a couple of things right off. I think you're going to need to be careful escaping the $recipient variable, trapping for sql comments and the like. Be paranoid, since this data comes from the network. T

[Dbmail] multiple copies of email problem

2002-07-27 Thread Micah Stevens
Alright, I can't seem to make heads or tails of this. I looked through all the Postfix documentation I could find, as well as dbmail, and no leads. Maybe one of you can help: I'm running a Redhat 7.2 system, with Postfix 1.1.10 compiled with MySQL support as my MTA. dbmail is providing pop3 ac

[Dbmail] Creating users/mailboxes by database queries

2002-07-27 Thread Mark Mackay
Hi all - I'm about to move on of our mailservers onto dbmail as part of our first production environment; and was wondering the best way to propogate the database, etc with information. 1) Porting mailboxes Obviously I'll use the existing utilities here to handle this; but was wondering if anyo

[Dbmail] Performance issue with large messages

2002-07-27 Thread Mark Mackay
I'm just testing some large mailboxes for performance handling, etc and noticed that checking for new mail seemed to pause for up to 5-10 seconds or so before continuing. When looking at the mysql query logs, the following seemed to be holding things up: > SELECT messageblk FROM messageblks WHERE

Re: [Dbmail] Performance issue with large messages

2002-07-27 Thread Cédric Veilleux
Check your my.cnf configuration file. MySQL has a configurable maximum answer size. I think the default value is about 1 MB, so this could be what is causing the poor database performance. Try cranking up this value. Check mysql documentation for more details.. There might as well be more perfo

[Dbmail] Several things- postfix's mailbox_transport, /etc/aliases, SpamAssasin

2002-07-27 Thread Eric Renfro
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm new to this mailing list, and to dbmail. I'm running dbmail, so far very successfully on a low-scale setup as-is, through pgsql. What my concerns is, setting up dbmail to use nothing /but/ the dbmail for dropboxes, completely removing the ne

[Dbmail] mbox2dbmail performance

2002-07-27 Thread Frido Ferdinand
Hi, In preperation of migrating our office setup to dbmail, I've decided to convert my personal mailsetup first. I have about 165Mb of mboxes I want to convert to dbmail with the mbox2dbmail tool. For convenience I edited mbox2dbmail so that I can give it a mailbox as second argument. However the

Re: [Dbmail] mbox2dbmail performance

2002-07-27 Thread
Hi Frido, You should take a look at the uni-one converter. It was especially written for a company called uni-hone here in the netherlands to convert 6,5 Gbyte of mboxes. All boxes were converted in 51 minutes. Best regards, eelco Frido Ferdinand heeft op zaterdag 27 juli 2002 om 19:41 het