Re: storing mydestination in mysql

2008-09-17 Thread mouss
rihad wrote: Correction: /usr/local/etc/postfix/main.cf: mydestination = mysql:/usr/local/etc/postfix/mysql-mydestination.conf /user/local/etc/postfix/mysql-mydestination.conf: host = localhost username = postfix password = none dbname = mail expansion_limit = 1 query = SELECT v FROM mydestina

Re: storing mydestination in mysql

2008-09-17 Thread rihad
mouss wrote: rihad wrote: query = SELECT v FROM mydestination WHERE k='%s' - do not return NULL. since the result is unused, simply use query = SELECT 'blah' mydestination WHERE k='%s' Sorry, but your suggested fix doesn't solve the problem: the query still doesn't happen when I restar

Re: odd error sent to postmaster

2008-09-17 Thread Jan P. Kessler
Robert Cohen schrieb: > smtpd_client_restrictions = ignore_policy_error,check_policy_service > inet:localhost:4466 > ignore_policy_error? What is that? I can't find a 'smtpd_restriction_classes' in your 'postconf -n'

Re: odd error sent to postmaster

2008-09-17 Thread Robert Cohen
Hmm, your right about ignore_policy_error. Its something that was in the default main.cf that ships with Puremessage, and it doesn't cause any obvious problems, so there was no reason to change it. But it doesn't appear in the postfix documentation. You'd think postfix would complain about random

Re: Message appear only in cleanup

2008-09-17 Thread Victor Duchovni
On Wed, Sep 17, 2008 at 08:07:08AM +0200, [EMAIL PROTECTED] wrote: > >2008-09-16T00:17:04-0400 amnesiac postfix/smtpd[23434]: > > lost connection after DATA (4307 bytes) > > from arm227.bigfootinteractive.com[206.132.3.227] > I have errors lost connection and timeout after data, from

Re: Message appear only in cleanup

2008-09-17 Thread [EMAIL PROTECTED]
Victor Duchovni ha scritto: On Wed, Sep 17, 2008 at 08:07:08AM +0200, [EMAIL PROTECTED] wrote: 2008-09-16T00:17:04-0400 amnesiac postfix/smtpd[23434]: lost connection after DATA (4307 bytes) from arm227.bigfootinteractive.com[206.132.3.227] I have errors lost c

Re: storing mydestination in mysql

2008-09-17 Thread rihad
rihad wrote: What's going on? How is Postfix supposed to learn the whole mydestination list if there's no such SQL template? I thought Postfix would deduce a "select k from mydestination" query or similar on its own. The manpage is ambiguous in this regard. Answering to myself: OK, Postfix s

Re: storing mydestination in mysql

2008-09-17 Thread Michael Tokarev
rihad wrote: [] allowed. I will replace $myhostname in MySQL with its expanded value once I get the query to happen at all... How about adding the following single line to your postfix startup script, before executing postfix's master: postconf -e myhostname=`mysql-query-for-postfix-hostname

Re: storing mydestination in mysql

2008-09-17 Thread mouss
rihad wrote: rihad wrote: What's going on? How is Postfix supposed to learn the whole mydestination list if there's no such SQL template? I thought Postfix would deduce a "select k from mydestination" query or similar on its own. The manpage is ambiguous in this regard. Answering to myself:

Re: odd error sent to postmaster

2008-09-17 Thread mouss
Robert Cohen wrote: Hmm, your right about ignore_policy_error. Its something that was in the default main.cf that ships with Puremessage, and it doesn't cause any obvious problems, so there was no reason to change it. But it doesn't appear in the postfix documentation. You'd think postfix would

Re: permit_mx_backup_networks and IPv6

2008-09-17 Thread Wietse Venema
martin f krafft: > also sprach Wietse Venema <[EMAIL PROTECTED]> [2008.09.03.1313 +0100]: > > permit_mx_backup_networks uses the same parser as mynetworks, > > and therefore it expects the same main.cf syntax as mynetworks. > > Thought so... > > > > [2001:6f8:128a::1]/128 # dict_open: unsu

Re: Message appear only in cleanup

2008-09-17 Thread Noel Jones
[EMAIL PROTECTED] wrote: Victor Duchovni ha scritto: On Wed, Sep 17, 2008 at 08:07:08AM +0200, [EMAIL PROTECTED] wrote: 2008-09-16T00:17:04-0400 amnesiac postfix/smtpd[23434]: lost connection after DATA (4307 bytes) from arm227.bigfootinteractive.com[206.132.3.227] I

Re: storing mydestination in mysql

2008-09-17 Thread rihad
mouss wrote: rihad wrote: rihad wrote: What's going on? How is Postfix supposed to learn the whole mydestination list if there's no such SQL template? I thought Postfix would deduce a "select k from mydestination" query or similar on its own. The manpage is ambiguous in this regard. Answer

Re: storing mydestination in mysql

2008-09-17 Thread Victor Duchovni
On Wed, Sep 17, 2008 at 08:51:48PM +0500, rihad wrote: > Sure enough, but I'm speaking of a single snapshotted value through a > single request ("transaction"). Besides its being more efficient, > caching makes for more consistent results: you wouldn't want Postfix to > first consider a deliver

Re: storing mydestination in mysql

2008-09-17 Thread mouss
rihad wrote: mouss wrote: rihad wrote: rihad wrote: What's going on? How is Postfix supposed to learn the whole mydestination list if there's no such SQL template? I thought Postfix would deduce a "select k from mydestination" query or similar on its own. The manpage is ambiguous in this re

checking integrity

2008-09-17 Thread Milos Prudek
Hi, I suspect that my email server has been cracked. How do I make sure it happened? I verified via external website service that my server is not an open relay. I verified that my server is not listed at spamhaus RBL (yet). However, /var/log/mail contains huge number of lines like this one:

Re: checking integrity

2008-09-17 Thread Ralf Hildebrandt
* Milos Prudek <[EMAIL PROTECTED]>: > Hi, > > I suspect that my email server has been cracked. How do I make sure it > happened? > > I verified via external website service that my server is not an open relay. > > I verified that my server is not listed at spamhaus RBL (yet). > > However, /va

Re: storing mydestination in mysql

2008-09-17 Thread rihad
Victor Duchovni wrote: On Wed, Sep 17, 2008 at 08:51:48PM +0500, rihad wrote: Sure enough, but I'm speaking of a single snapshotted value through a single request ("transaction"). Besides its being more efficient, caching makes for more consistent results: you wouldn't want Postfix to first c

Re: checking integrity

2008-09-17 Thread Ralf Hildebrandt
* Milos Prudek <[EMAIL PROTECTED]>: > I suspect that my email server has been cracked. How do I make sure it > happened? You check the logs. You check the integrity of the system files using aide or samhain > However, /var/log/mail contains huge number of lines like this one: What does qshape

Re: checking integrity

2008-09-17 Thread Brian Evans - Postfix List
Milos Prudek wrote: > Hi, > > I suspect that my email server has been cracked. How do I make sure it > happened? > > I verified via external website service that my server is not an open relay. > > I verified that my server is not listed at spamhaus RBL (yet). > > However, /var/log/mail contains

Re: checking integrity

2008-09-17 Thread Milos Prudek
> You need to figure out which service is connection denied on localhost. > See also http://www.postfix.org/DEBUG_README.html#logging Thank you! I run egrep '(warning|error|fatal|panic):' /var/log/mail | less. I got a filtered list that looks like this: Sep 17 18:40:04 mail postfix/smtpd[416]: w

Re: storing mydestination in mysql

2008-09-17 Thread rihad
rihad wrote: mouss wrote: Also set parent_domain_matches_subdomains = (empty) Then retry to see how many lookups there are. [snip] But it's different processes doing the queries (one to accept the message, one to route the message to the local delivery agent, ...). Oh, in that case it'

Re: checking integrity

2008-09-17 Thread Milos Prudek
> You check the integrity of the system files using aide or samhain Thank you very much, I will try that tommorow. > > However, /var/log/mail contains huge number of lines like this one: > > What does > qshape > report? T 5 10 20 40 80 160 320 640 1280 1280+

Re: checking integrity

2008-09-17 Thread Brian Evans - Postfix List
Milos Prudek wrote: >> You need to figure out which service is connection denied on localhost. >> See also http://www.postfix.org/DEBUG_README.html#logging >> > > Thank you! I run egrep '(warning|error|fatal|panic):' /var/log/mail | less. I > got a filtered list that looks like this: > > Sep

Re: storing mydestination in mysql

2008-09-17 Thread Victor Duchovni
On Wed, Sep 17, 2008 at 10:09:53PM +0500, rihad wrote: > Correcting myself once again: It's not OK :) I forgot to mention that > all those 4 requests were the result of me issuing RCPT TO alone. I > can't see how message acceptance or routing are involved. You are wasting everyone's time with t

Re: checking integrity

2008-09-17 Thread Milos Prudek
> Again, > > It seems you missed the critical welcome message: OK, here's postconf -n: alias_maps = hash:/etc/aliases biff = no canonical_maps = hash:/etc/postfix/canonical command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/lib/postfix debug_peer_level = 2 defer

Re: checking integrity

2008-09-17 Thread Milos Prudek
Dne Wednesday 17 of September 2008 18:32:35 Ralf Hildebrandt napsal(a): > * Milos Prudek <[EMAIL PROTECTED]>: > > I suspect that my email server has been cracked. How do I make sure it > > happened? > > You check the logs. > You check the integrity of the system files using aide or samhain > > > Ho

Re: checking integrity

2008-09-17 Thread Noel Jones
Milos Prudek wrote: Dne Wednesday 17 of September 2008 18:32:35 Ralf Hildebrandt napsal(a): * Milos Prudek <[EMAIL PROTECTED]>: I suspect that my email server has been cracked. How do I make sure it happened? You check the logs. You check the integrity of the system files using aide or samhain

Re: checking integrity

2008-09-17 Thread Duane Hill
On Wed, 17 Sep 2008, Noel Jones wrote: Milos Prudek wrote: Dne Wednesday 17 of September 2008 18:32:35 Ralf Hildebrandt napsal(a): * Milos Prudek <[EMAIL PROTECTED]>: I suspect that my email server has been cracked. How do I make sure it happened? You check the logs. You check the integrity

Re: checking integrity

2008-09-17 Thread Brian Evans - Postfix List
Milos Prudek wrote: >> Again, >> >> It seems you missed the critical welcome message: >> > > OK, here's postconf -n: > [...] > relay_domains = vinoteky.cz, ewine.cz, pilaoplustil.cz, swisshaus.ru, > swisshaus.org, moravin.cz, tvojeimage.cz,ibclubcenter.com > > smtpd_sender_restrictions = h

Re: checking integrity

2008-09-17 Thread Noel Jones
Duane Hill wrote: On Wed, 17 Sep 2008, Noel Jones wrote: Milos Prudek wrote: Dne Wednesday 17 of September 2008 18:32:35 Ralf Hildebrandt napsal(a): * Milos Prudek <[EMAIL PROTECTED]>: I suspect that my email server has been cracked. How do I make sure it happened? You check the logs. You c

Re: checking integrity

2008-09-17 Thread mouss
Brian Evans - Postfix List wrote: Milos Prudek wrote: Again, It seems you missed the critical welcome message: OK, here's postconf -n: [...] relay_domains = vinoteky.cz, ewine.cz, pilaoplustil.cz, swisshaus.ru, swisshaus.org, moravin.cz, tvojeimage.cz,ibclubcenter.com smtpd_sender_

Re: checking integrity

2008-09-17 Thread Noel Jones
mouss wrote: Brian Evans - Postfix List wrote: You have tvojeimage.cz and ibclubcenter.com in two address classes (virtual_mailbox and relay). he probably have warnings in his logs! No, this is legal, but probably not what the OP intends. Postfix thinks "tvojeimage.cz" is a virtual mailbo

Domain name appended despite remote_header_rewrite_domain being empty

2008-09-17 Thread rihad
Hi there, I'm a Postfix newb playing my way with FreeBSD 7 port named postfix-current-2.6.20080814,4. In http://www.postfix.org/ADDRESS_REWRITING_README.html it says that: Postfix never rewrites message header addresses from remote SMTP clients when the remote_header_rewrite_domain parameter v

Re: storing mydestination in mysql

2008-09-17 Thread rihad
Victor Duchovni wrote: On Wed, Sep 17, 2008 at 10:09:53PM +0500, rihad wrote: Correcting myself once again: It's not OK :) I forgot to mention that all those 4 requests were the result of me issuing RCPT TO alone. I can't see how message acceptance or routing are involved. You are wasting ev

Re: Domain name appended despite remote_header_rewrite_domain being empty

2008-09-17 Thread mouss
rihad wrote: Hi there, I'm a Postfix newb playing my way with FreeBSD 7 port named postfix-current-2.6.20080814,4. In http://www.postfix.org/ADDRESS_REWRITING_README.html it says that: Postfix never rewrites message header addresses from remote SMTP clients when the remote_header_rewrite_doma

Re: storing mydestination in mysql

2008-09-17 Thread mouss
rihad wrote: Victor Duchovni wrote: On Wed, Sep 17, 2008 at 10:09:53PM +0500, rihad wrote: Correcting myself once again: It's not OK :) I forgot to mention that all those 4 requests were the result of me issuing RCPT TO alone. I can't see how message acceptance or routing are involved. You

Re: storing mydestination in mysql

2008-09-17 Thread rihad
mouss wrote: rihad wrote: Victor Duchovni wrote: If you want the fewest possible lookups against $mydestination, get $mydestination out of $relay_domains (backwards compatible, but no longer optimal default). relay_domains was and is empty (please see one of my last replies to mouss). Whil

Re: storing mydestination in mysql

2008-09-17 Thread rihad
rihad wrote: Victor Sorry again, I meant Viktor.