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 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

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. Please

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

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

Re: Postfix queue in Mysql ?

2010-12-29 Thread Tomoyuki Murakami
On Wed, 29 Dec 2010 10:14:49 -0500, Joan Moreau j...@grosjo.net 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/

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

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

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 queue

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 people

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: 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 postfix

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 is

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

Re: Postfix queue in Mysql ?

2010-12-28 Thread Magnus Bäck
On Tuesday, December 28, 2010 at 22:29 CET, Joan Moreau j...@grosjo.net 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

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 storing the

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 wrote: I

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 storage

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

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