Re: SMTP hangs when MySQL is down

2011-12-09 Thread Wietse Venema
Viktor Dukhovni: > On Fri, Dec 09, 2011 at 07:47:08AM -0500, Wietse Venema wrote: > > > lst_ho...@kwsoft.de: > > > I don't know the Postfix internals but if it where easy *and* safe to > > > implement it would have been done already from someone feeling the > > > need to do so. > > > > A quic

Re: SMTP hangs when MySQL is down

2011-12-09 Thread Viktor Dukhovni
On Fri, Dec 09, 2011 at 07:47:08AM -0500, Wietse Venema wrote: > lst_ho...@kwsoft.de: > > I don't know the Postfix internals but if it where easy *and* safe to > > implement it would have been done already from someone feeling the > > need to do so. > > A quick search shows that trivial-rewri

Re: SMTP hangs when MySQL is down

2011-12-09 Thread Sebastian Wiesinger
* Wietse Venema [2011-12-09 13:47]: > A quick search shows that trivial-rewrite server has no "fatal" > errors - it reports all errors that it can detect to the client (in > this case smtpd(8)). > > However there is one low-level library module (match_ops) that > exits the program with a "fatal"

Re: SMTP hangs when MySQL is down

2011-12-09 Thread Wietse Venema
lst_ho...@kwsoft.de: > I don't know the Postfix internals but if it where easy *and* safe to > implement it would have been done already from someone feeling the > need to do so. A quick search shows that trivial-rewrite server has no "fatal" errors - it reports all errors that it can detect t

Re: SMTP hangs when MySQL is down

2011-12-09 Thread lst_hoe02
Zitat von Sebastian Wiesinger : * lst_ho...@kwsoft.de [2011-12-08 14:46]: >And I had hoped that perhaps this would be an improvement to postfix. >Sadly it seems it was some kind of blasphemy to question the way >postfix does handle this stuff. No, it means until now no one needs this so impor

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Sebastian Wiesinger
* Wietse Venema [2011-12-09 01:01]: > > And that is where I disagree. IMHO a mailsystem should respond with a > > temporary error if it is experiencing a temporary error (like a lookup > > table not being availabe) not simply hang there and do.. nothing. > > We know that. What are you going to do

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Wietse Venema
Sebastian Wiesinger: > * lst_ho...@kwsoft.de [2011-12-08 14:46]: > > >And I had hoped that perhaps this would be an improvement to postfix. > > >Sadly it seems it was some kind of blasphemy to question the way > > >postfix does handle this stuff. > > > > No, it means until now no one needs this s

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Sebastian Wiesinger
* lst_ho...@kwsoft.de [2011-12-08 14:46]: > >And I had hoped that perhaps this would be an improvement to postfix. > >Sadly it seems it was some kind of blasphemy to question the way > >postfix does handle this stuff. > > No, it means until now no one needs this so important to step up > with cod

RE: SMTP hangs when MySQL is down

2011-12-08 Thread Gary Smith
> Hi, > > I'm using Postfix with MySQL via proxy:mysql maps. The documentation > states that mails should get deferred if no mysql server is reachable. > > However when I shut down MySQL, SMTP transaction freeze after I enter > the "MAIL FROM:<...>" statement. > > Any ideas how I can change that

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Reindl Harald
Am 08.12.2011 15:15, schrieb lst_ho...@kwsoft.de: > Zitat von Reindl Harald : > >> Am 08.12.2011 14:45, schrieb lst_ho...@kwsoft.de: >> >>> Help is always welcome, simply demand how things could be better is useless >> >> you have a bad attitude! >> >> demand how things could be better is useful

Re: SMTP hangs when MySQL is down

2011-12-08 Thread lst_hoe02
Zitat von Reindl Harald : Am 08.12.2011 14:45, schrieb lst_ho...@kwsoft.de: Help is always welcome, simply demand how things could be better is useless you have a bad attitude! demand how things could be better is useful, everywhere because it is a hint what can be improved You have mis

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Reindl Harald
Am 08.12.2011 14:45, schrieb lst_ho...@kwsoft.de: > Help is always welcome, simply demand how things could be better is useless you have a bad attitude! demand how things could be better is useful, everywhere because it is a hint what can be improved you need not always to be able making thin

Re: SMTP hangs when MySQL is down

2011-12-08 Thread lst_hoe02
Zitat von Sebastian Wiesinger : * Wietse Venema [2011-12-08 13:09]: Sebastian Wiesinger: > I really would like to know if it is not possible to have a temporary > error when trivial-rewrite fails to access the MySQL database. I don't > see any apparent reason for it. If there is one I would li

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Sebastian Wiesinger
* Wietse Venema [2011-12-08 13:09]: > Sebastian Wiesinger: > > I really would like to know if it is not possible to have a temporary > > error when trivial-rewrite fails to access the MySQL database. I don't > > see any apparent reason for it. If there is one I would like to know. > > You have th

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Wietse Venema
Wietse Venema: > Sebastian Wiesinger: > > I really would like to know if it is not possible to have a temporary > > error when trivial-rewrite fails to access the MySQL database. I don't > > see any apparent reason for it. If there is one I would like to know. > > You have the right to ask these q

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Wietse Venema
Sebastian Wiesinger: > I really would like to know if it is not possible to have a temporary > error when trivial-rewrite fails to access the MySQL database. I don't > see any apparent reason for it. If there is one I would like to know. You have the right to ask these questions. I recommend that

Re: SMTP hangs when MySQL is down

2011-12-08 Thread Sebastian Wiesinger
* Wietse Venema [2011-12-07 17:20]: > Yes it was. I point the attention to the RIGHT problem, which is > fixing the suboptimal configuration that does domain queries from > SQL. Hi, with all due respect but for me the important thing at the moment would be to understand why it works the way it w

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Reindl Harald
Am 07.12.2011 17:42, schrieb /dev/rob0: > Nonsense. Recognition of new domains need not be instant. Email is > itself not instant messaging. Domain owners should expect reasonable > delays in changes of domain hosting, and are responsible to plan > accordingly. Your expectations are absurd. >

Re: SMTP hangs when MySQL is down

2011-12-07 Thread /dev/rob0
On Wednesday 07 December 2011 10:21:03 Reindl Harald wrote: > Am 07.12.2011 17:17, schrieb Wietse Venema: > > Reindl Harald: > >> Am 07.12.2011 16:59, schrieb Wietse Venema: > >>> Sebastian Wiesinger: > I read these but it's not clear to me. So the transport lookup > doesn't work, but why

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Reindl Harald
Am 07.12.2011 17:17, schrieb Wietse Venema: > Reindl Harald: >> Am 07.12.2011 16:59, schrieb Wietse Venema: >>> Sebastian Wiesinger: I read these but it's not clear to me. So the transport lookup doesn't work, but why does that prevent postfix from doing a 4xx error code? >>> >>> You sh

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Wietse Venema
Reindl Harald: > Am 07.12.2011 16:59, schrieb Wietse Venema: > > Sebastian Wiesinger: > >> I read these but it's not clear to me. So the transport lookup doesn't > >> work, but why does that prevent postfix from doing a 4xx error code? > > > > You should remove the domains from SQL (or LDAP or oth

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Reindl Harald
Am 07.12.2011 16:59, schrieb Wietse Venema: > Sebastian Wiesinger: >> I read these but it's not clear to me. So the transport lookup doesn't >> work, but why does that prevent postfix from doing a 4xx error code? > > You should remove the domains from SQL (or LDAP or other slow tables). > > Onc

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Wietse Venema
Sebastian Wiesinger: > I read these but it's not clear to me. So the transport lookup doesn't > work, but why does that prevent postfix from doing a 4xx error code? You should remove the domains from SQL (or LDAP or other slow tables). Once you do that, smtpd will reply 4xx after email address lo

Re: SMTP hangs when MySQL is down

2011-12-07 Thread Sebastian Wiesinger
* Sahil Tandon [2011-12-06 01:54]: > > that's not really an option for me, I need these lists in MySQL. It > > seems I have to live with it and make MySQL as stable as possible. > > Is your list of virtual mailbox domains that large or dynamic that it > must be only in SQL? Note that you can sti

Re: SMTP hangs when MySQL is down

2011-12-05 Thread Sahil Tandon
On Mon, 2011-12-05 at 10:59:35 +0100, Reindl Harald wrote: > Am 05.12.2011 10:42, schrieb Sebastian Wiesinger: > >> Do not use SQL in virtual_mailbox_domains[1]; instead, set the > >> latter to a regular list. Then, even when MySQL is down, Postfix > >> will defer mail with 4.3.0 instead of appea

Re: SMTP hangs when MySQL is down

2011-12-05 Thread Sahil Tandon
On Mon, 2011-12-05 at 10:42:30 +0100, Sebastian Wiesinger wrote: > * Sahil Tandon [2011-12-05 03:24]: > > > I'm using Postfix with MySQL via proxy:mysql maps. The documentation > > > states that mails should get deferred if no mysql server is reachable. > > > > > > However when I shut down MySQL

Re: SMTP hangs when MySQL is down

2011-12-05 Thread Reindl Harald
Am 05.12.2011 10:42, schrieb Sebastian Wiesinger: >> Do not use SQL in virtual_mailbox_domains[1]; instead, set the latter to >> a regular list. Then, even when MySQL is down, Postfix will defer mail >> with 4.3.0 instead of appearing to freeze. > > Hi Sahil, > > that's not really an option for

Re: SMTP hangs when MySQL is down

2011-12-05 Thread Sebastian Wiesinger
* Sahil Tandon [2011-12-05 03:24]: > > I'm using Postfix with MySQL via proxy:mysql maps. The documentation > > states that mails should get deferred if no mysql server is reachable. > > > > However when I shut down MySQL, SMTP transaction freeze after I enter > > the "MAIL FROM:<...>" statement.

Re: SMTP hangs when MySQL is down

2011-12-04 Thread Sahil Tandon
On Mon, 2011-12-05 at 01:34:17 +0100, Sebastian Wiesinger wrote: > I'm using Postfix with MySQL via proxy:mysql maps. The documentation > states that mails should get deferred if no mysql server is reachable. > > However when I shut down MySQL, SMTP transaction freeze after I enter > the "MAIL FR

Re: SMTP hangs when MySQL is down

2011-12-04 Thread Reindl Harald
Am 05.12.2011 01:34, schrieb Sebastian Wiesinger: > I'm using Postfix with MySQL via proxy:mysql maps. The documentation > states that mails should get deferred if no mysql server is reachable yes, on the delivering server if your configuration is mysql-based and mysqld is down your server must