Re: Postfix queue in Mysql ?

2010-12-31 Thread Charles Marcus
On 2010-12-29 10:14 AM, Joan Moreau wrote: > But I have no " car to fix" . What is that story about ? In your first post, you vaguely described a 'problem': "the postfix queue manager (qmgr) is taking far too much resources when the number of email pending is growing." > Now, I did not rule out

Re: Postfix queue in Mysql ?

2010-12-29 Thread Noel Jones
On 12/29/2010 9:14 AM, Joan Moreau wrote: Can you just tell me how to put the mailing queue in a DB (mysql database in my case) ? Yes, rewrite postfix to use a DB as a backend rather than a file system. This will be a major redesign and not just a plugin. No one else is working on such a p

Re: Postfix queue in Mysql ?

2010-12-29 Thread Tomoyuki Murakami
On Wed, 29 Dec 2010 10:14:49 -0500, Joan Moreau wrote: > Can you just tell me how to put > the mailing queue in a DB (mysql database in my case) ? you may simply deploy MySQLfs (FUSE+MySQL) if you do not mind speeds, loads,...etc. http://sourceforge.net/projects/mysqlfs/ pgp7HNgIbhXrK.pgp Des

Re: Postfix queue in Mysql ?

2010-12-29 Thread Jeroen Geilman
On 12/29/10 4:14 PM, Joan Moreau wrote: But I have no " car to fix" . What is that story about ? Now, I did not rule out anything in any email. Can you just tell me how to put the mailing queue in a DB (mysql database in my case) ? Exactly which part of NO YOU CAN NOT PUT THE QUEUE IN A D

Re: Postfix queue in Mysql ?

2010-12-29 Thread Joan Moreau
But I have no " car to fix" . What is that story about ? Now, I did not rule out anything in any email. Can you just tell me how to put the mailing queue in a DB (mysql database in my case) ? On Wed, 29 Dec 2010 18:04:45 +1100, James Gray wrote: > On 29/12/2010, at 4:02 PM, Joan Moreau wr

Let's Kill This Thread (Was: Postfix queue in Mysql ?)

2010-12-29 Thread mouss
Le 29/12/2010 12:38, Ansgar Wiechers a écrit : > On 2010-12-29 Joan Moreau wrote: >> Well, I am surprised by the tone of those emails. > > I, on the other hand, am very surprised, how you're consistently avoid > giving this list any details about your configuration or your actual > problem. > >

Re: Postfix queue in Mysql ?

2010-12-29 Thread Ansgar Wiechers
On 2010-12-29 Joan Moreau wrote: > Well, I am surprised by the tone of those emails. I, on the other hand, am very surprised, how you're consistently avoid giving this list any details about your configuration or your actual problem. Please either supply the information you've been asked for (se

Re: Postfix queue in Mysql ?

2010-12-28 Thread James Gray
On 29/12/2010, at 4:02 PM, Joan Moreau wrote: > Well, I am surprised by the tone of those emails. Why? Do you tell you mechanic how to fix your car before he's even been informed what vehicle you drive? > I am just asking if it exists a back-end that would replace the storage and > management

Re: Postfix queue in Mysql ?

2010-12-28 Thread Joan Moreau
Well, I am surprised by the tone of those emails. I am just asking if it exists a back-end that would replace the storage and management of the queue into mysql (i.e. put /var/spool/postfix into mysql tables). (yes, a file system is made for storing files, but it is not at all made to execute

Re: Postfix queue in Mysql ?

2010-12-28 Thread Stan Hoeppner
Joan Moreau put forth on 12/28/2010 3:29 PM: > > > Well, no need to get angry. No one is angry. You're misreading "tone" as you're not a regular member of this list. Replace "angry" with "direct" and you've got the correct tone. > I am just looking for a MySQL bakcend to replace the hard-disk

Re: Postfix queue in Mysql ?

2010-12-28 Thread James Gray
> On Tue, 28 Dec 2010 12:28:57 -0500 (EST), Wietse Venema wrote: > >> Joan Moreau: >>> Well, more clearly, my question is : How can I plug Mysql as a backend >>> of postfix to handle the mailq ? >> >> Please state the PROBLEM instead of the SOLUTION. Wietse On 29/12/2010, at 8:29 AM, Joan Moreau

Re: Postfix queue in Mysql ?

2010-12-28 Thread Victor Duchovni
On Tue, Dec 28, 2010 at 04:29:34PM -0500, Joan Moreau wrote: > > I am just looking for a MySQL bakcend to replace the hard-disk storage of > the postfix mailqueue. This is not a problem, this is something I am > looking for. This is surely a "means" and not an "end". What real purpose would stori

Re: Postfix queue in Mysql ?

2010-12-28 Thread Magnus Bäck
On Tuesday, December 28, 2010 at 22:29 CET, Joan Moreau wrote: > I am just looking for a MySQL bakcend to replace the hard-disk storage > of the postfix mailqueue. This is not a problem, this is something I > am looking for. Judging by your initial message in this thread I'd say your proble

Re: Postfix queue in Mysql ?

2010-12-28 Thread Joan Moreau
Well, no need to get angry. I am just looking for a MySQL bakcend to replace the hard-disk storage of the postfix mailqueue. This is not a problem, this is something I am looking for. Best, Joan On Tue, 28 Dec 2010 12:28:57 -0500 (EST), Wietse Venema wrote: Joan Moreau: Well, more clearl

Re: Postfix queue in Mysql ?

2010-12-28 Thread Victor Duchovni
On Tue, Dec 28, 2010 at 12:19:23PM -0500, Joan Moreau wrote: > Well, more clearly, my question is : > > How can I plug Mysql as a > backend of postfix to handle the mailq ? It was clear enough before. The answer is that this is not possible. The queue is file-based by design. The queue design

Re: Postfix queue in Mysql ?

2010-12-28 Thread Wietse Venema
Joan Moreau: > Well, more clearly, my question is : > > How can I plug Mysql as a > backend of postfix to handle the mailq ? Please state the PROBLEM instead of the SOLUTION. Wietse > On Tue, 28 Dec 2010 12:00:04 > -0500 (EST), Wietse Venema wrote: > > > Joan Moreau: > >> Hi, the po

Re: Postfix queue in Mysql ?

2010-12-28 Thread Joan Moreau
Well, more clearly, my question is : How can I plug Mysql as a backend of postfix to handle the mailq ? On Tue, 28 Dec 2010 12:00:04 -0500 (EST), Wietse Venema wrote: > Joan Moreau: >> Hi, the postfix queue manager (qmgr) is taking far too much resources when the number of email pending is

Re: Postfix queue in Mysql ?

2010-12-28 Thread Wietse Venema
Joan Moreau: > Hi, > > the postfix queue manager (qmgr) is taking far too much > resources when the number of email pending is growing. Sorry, you are jumping to conclusions. There are many reasons why mail can pile up in the queue, and you have not given a shred of information that allows peo

Re: Postfix queue in Mysql ?

2010-12-28 Thread Victor Duchovni
On Tue, Dec 28, 2010 at 08:28:48AM -0500, Joan Moreau wrote: > the postfix queue manager (qmgr) is taking far too much > resources What does "too much resources" mean? CPU? disk I/O? RAM? > when the number of email pending is growing. Treat the disease not the symptoms, why is the deferred que

Postfix queue in Mysql ?

2010-12-28 Thread Joan Moreau
Hi, the postfix queue manager (qmgr) is taking far too much resources when the number of email pending is growing. Is there a wait to move "/var/spool/postfix" in a MySQL database ? (dont tell me "dbmail", I want to keep my dovecot imap/pop sever) Thanks Joan