Re: Config check

2011-01-24 Thread Walter Pinto
I couldn't find any 2.8.0-1 SRPMS.

postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Claudio Prono
Hello all, On a postfix server i have some strange things in logs files, and i don't know what's happening. Jan 22 23:54:07 mail postfix/trivial-rewrite[10285]: warning: mysql query failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Reindl Harald
collation is normally a table property your mysql-tables charset should be uTF8 Am 24.01.2011 10:17, schrieb Claudio Prono: Hello all, On a postfix server i have some strange things in logs files, and i don't know what's happening. Jan 22 23:54:07 mail postfix/trivial-rewrite[10285]:

Re: Config check

2011-01-24 Thread Reindl Harald
take the latest srpm of your distributions version as base and remove patches from the SPEC-File Am 24.01.2011 10:01, schrieb Walter Pinto: I couldn't find any 2.8.0-1 SRPMS. -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO /

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Claudio Prono
Reindl Harald ha scritto: collation is normally a table property your mysql-tables charset should be uTF8 How i can check this? Am 24.01.2011 10:17, schrieb Claudio Prono: Hello all, On a postfix server i have some strange things in logs files, and i don't know what's happening.

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Reindl Harald
Am 24.01.2011 11:15, schrieb Claudio Prono: Reindl Harald ha scritto: collation is normally a table property your mysql-tables charset should be uTF8 How i can check this? show create table tablename; signature.asc Description: OpenPGP digital signature

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Claudio Prono
Reindl Harald ha scritto: show create table tablename; Ok, something strange is come out. Here is the list of tables on postfix database: +---+ | Tables_in_postfix | +---+ | admin | | alias | | alias_domain

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Reindl Harald
I think this can be a problem and would recommend to force UTF8 for all tables, if there are only LATIN1 data they should not be touched in any way and if all is UTF8 there is no point of mixing Well, normally we use LATIN1 historical for some thounsand tables but the whole database for

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Claudio Prono
Reindl Harald ha scritto: I think this can be a problem and would recommend to force UTF8 for all tables, if there are only LATIN1 data they should not be touched in any way and if all is UTF8 there is no point of mixing Well, normally we use LATIN1 historical for some thounsand tables

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Reindl Harald
Am 24.01.2011 14:17, schrieb Claudio Prono: - How i can force UTF8 for all the tables? alter table will be your friend - mysql manual - If i change all into UTF8, can be some data loss or some risk at all? normally not because there is nothing in LATIN1 which is not supported in UTF8, in

virtual_alias_maps and verify

2011-01-24 Thread Heinz A. Krebs
dear all, i'm going to setup a backup-MX, and although i've now a working solution, I'd like to ask, if this is the correct solution ... PART 1 (working): Backup for domain.com with a list of valid recipients in a database. my main.cf looks like: --- relay_domains =

Blacklist per-domain

2011-01-24 Thread polloxx
Dear list, We want to implement blacklisting sender email addresses on a per-domain basis. I know it can be done by Amavis but I would like to implement this directly in Postfix. Is this possible? Thx, P.

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 10:17:25AM +0100, Claudio Prono wrote: On a postfix server i have some strange things in logs files, and i don't know what's happening. Jan 22 23:54:07 mail postfix/trivial-rewrite[10285]: warning: mysql query failed: Illegal mix of collations

After postfix stop, postscreen remains alone without master supervisor process

2011-01-24 Thread Stefano Mason
Sometimes the postscreen process behaviour is: ( After postfix stop, another postscreen is started, look PID number! ) # postconf mail_version mail_version = 2.8.0 # date Mon Jan 24 16:21:45 CET 2011 # cat /etc/redhat-release CentOS release 5.5 (Final) # ps -fe |grep postscreen postfix

Inbound email into script

2011-01-24 Thread ira darwin
Hi, I am new to postfix. I have been searching on how to do this but unable to find an answer. I wonder if someone could help. I have postfix setup to deliver all emails to @my-domain.com to an smrsh script. So in my aliases file I have mydomain-com:|/my-script.php The problem is if postfix

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Mark Martinec
What MySQL makes of such data is up to the MySQL client and server libraries, but Postfix does not promise that the input will be well-formed UTF-8, or ISO Latin or anything of the sort. Just an array of bytes. Right, as it should be. Envelope addresses are not associated with any character

Re: virtual_alias_maps and verify

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 03:52:18PM +0100, Heinz A. Krebs wrote: dear all, i'm going to setup a backup-MX, and although i've now a working solution, I'd like to ask, if this is the correct solution ... PART 1 (working): Backup for domain.com with a list of valid recipients in a database.

Re: After postfix stop, postscreen remains alone without master supervisor process

2011-01-24 Thread Wietse Venema
Stefano Mason: Sometimes the postscreen process behaviour is: ( After postfix stop, another postscreen is started, look PID number! ) By design, postscreen finishes ongoing work in the background. Wietse

Re: Inbound email into script

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 03:53:06PM +, ira darwin wrote: I am new to postfix. I have been searching on how to do this but unable to find an answer. I wonder if someone could help. I have postfix setup to deliver all emails to @my-domain.com to an smrsh script. It is not clear why

Re: Blacklist per-domain

2011-01-24 Thread Noel Jones
On 1/24/2011 9:12 AM, polloxx wrote: Dear list, We want to implement blacklisting sender email addresses on a per-domain basis. I know it can be done by Amavis but I would like to implement this directly in Postfix. Is this possible? Thx, P. Yes, using smtpd_restriction_classes. General

Re: Inbound email into script

2011-01-24 Thread polofuzzu
Thank you Victor for taking the time to answer my questions. Please see respond inline On 24 January 2011 16:46, Victor Duchovni victor.ducho...@morganstanley.com wrote: snip I have postfix setup to deliver all emails to @my-domain.com to an smrsh script. It is not clear why forgetting

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Claudio Prono
Mark Martinec ha scritto: What MySQL makes of such data is up to the MySQL client and server libraries, but Postfix does not promise that the input will be well-formed UTF-8, or ISO Latin or anything of the sort. Just an array of bytes. Right, as it should be. Envelope addresses are

Re: Inbound email into script

2011-01-24 Thread Noel Jones
On 1/24/2011 11:20 AM, polofuzzu wrote: Thank you Victor for taking the time to answer my questions. Please see respond inline On 24 January 2011 16:46, Victor Duchovni victor.ducho...@morganstanley.com mailto:victor.ducho...@morganstanley.com wrote: snip I have postfix setup to deliver

Re: Inbound email into script

2011-01-24 Thread polofuzzu
On 24 January 2011 17:35, Noel Jones njo...@megan.vbhcs.org wrote: On 1/24/2011 11:20 AM, polofuzzu wrote: Thank you Victor for taking the time to answer my questions. Please see respond inline On 24 January 2011 16:46, Victor Duchovni victor.ducho...@morganstanley.com

Re: After postfix stop, postscreen remains alone without master supervisor process

2011-01-24 Thread Ralf Hildebrandt
* Stefano Mason stefano.ma...@t-systems.it: Sometimes the postscreen process behaviour is: ( After postfix stop, another postscreen is started, look PID number! ) Yes, I've seen this once or twice, but assumed it was somehow my fault. -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Jeroen Geilman
On 1/24/11 4:52 PM, Mark Martinec wrote: What MySQL makes of such data is up to the MySQL client and server libraries, but Postfix does not promise that the input will be well-formed UTF-8, or ISO Latin or anything of the sort. Just an array of bytes. Right, as it should be. Envelope addresses

Re: After postfix stop, postscreen remains alone without master supervisor process

2011-01-24 Thread Ralf Hildebrandt
* Wietse Venema wie...@porcupine.org: The postscreen daemon creates a child and finishes work in the background. The parent terminates immediately. Meaning it's safe to igore and it will go away eventually. Fine. -- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité -

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 06:51:09PM +0100, Jeroen Geilman wrote: Right, as it should be. Envelope addresses are not associated with any character set according to RFC 5321, they are just strings of octets. Urgh. Which RFC are you reading ? Pedantically correct, but useless. Mark is well aware

Re: Inbound email into script

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 05:38:55PM +, polofuzzu wrote: Acting on the headers is broken by design. You should be acting on the envelope information, not headers. I wholeheartedly agree. But unfortunately that is the boundaries I have been given to work with. The script is unmodifiable,

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Mark Martinec
Jeroen Geilman wrote: Urgh. Which RFC are you reading ? I quote: Systems MUST NOT define mailboxes in such a way as to require the use in SMTP of non-ASCII characters True (tell it to generators of malicious mail or just incompetent sending sw). This does not prevent illegal data to appear

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 08:07:33PM +0100, Mark Martinec wrote: There is also an initiative to allow UTF-8 characters to appear in SMTP (RFC 5336 and related documents). I looked at these RFCs, I am not encouraged by what I see. They look deeply flawed... -- Viktor.

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Wietse Venema
Mark Martinec: Jeroen Geilman wrote: Urgh. Which RFC are you reading ? I quote: Systems MUST NOT define mailboxes in such a way as to require the use in SMTP of non-ASCII characters True (tell it to generators of malicious mail or just incompetent sending sw). This does not prevent

Delivered-To header and local users

2011-01-24 Thread Florian Effenberger
Hello, my mail users are all local users, added in /etc/passwd and /etc/shadow. Therefore, the virtual alias maps file looks like u...@myvirtualdomain.tld user1. All works like a charm, however, the Delivered-To header reads us...@fqdn.myhostname.tld Is this on purpose, can this be changed? I

Re: Delivered-To header and local users

2011-01-24 Thread Wietse Venema
Florian Effenberger: Hello, my mail users are all local users, added in /etc/passwd and /etc/shadow. Therefore, the virtual alias maps file looks like u...@myvirtualdomain.tld user1. All works like a charm, however, the Delivered-To header reads us...@fqdn.myhostname.tld Is this on

Re: postfix/trivial-rewrite: warning: mysql query failed: Illegal mix of collations

2011-01-24 Thread Jeroen Geilman
On 1/24/11 8:07 PM, Mark Martinec wrote: Jeroen Geilman wrote: Urgh. Which RFC are you reading ? I quote: Systems MUST NOT define mailboxes in such a way as to require the use in SMTP of non-ASCII characters True (tell it to generators of malicious mail or just incompetent sending sw). This

Re: Inbound email into script

2011-01-24 Thread J. Roeleveld
On Monday 24 January 2011 18:38:55 polofuzzu wrote: On 24 January 2011 17:35, Noel Jones njo...@megan.vbhcs.org wrote: On 1/24/2011 11:20 AM, polofuzzu wrote: Thank you Victor for taking the time to answer my questions. Please see respond inline On 24 January 2011 16:46, Victor

Re: Inbound email into script

2011-01-24 Thread Jeroen Geilman
On 1/24/11 9:33 PM, J. Roeleveld wrote: Just curious, how does the script handle BCC ? Eg. where none of the TO and CC headers actually contain a valid email for the domain because that was in the BCC? I suppose it doesn't matter in the slightest. If the script goes off the header addresses

RE: problem with log file entry

2011-01-24 Thread Jack
-Original Message- From: owner-postfix-us...@postfix.org [mailto:owner-postfix- us...@postfix.org] On Behalf Of Wietse Venema Sent: Friday, January 21, 2011 12:45 PM To: Postfix users Subject: Re: problem with log file entry Jack: I see this particular warning: Jan 20

Re: problem with log file entry

2011-01-24 Thread Wietse Venema
Jack: -Original Message- From: owner-postfix-us...@postfix.org [mailto:owner-postfix- us...@postfix.org] On Behalf Of Wietse Venema Sent: Friday, January 21, 2011 12:45 PM To: Postfix users Subject: Re: problem with log file entry Jack: I see this particular

Re: problem with log file entry

2011-01-24 Thread Victor Duchovni
On Mon, Jan 24, 2011 at 04:07:10PM -0500, Jack wrote: OK in further testing I see that the /usr/local/lib/policyd-spf-perl is not responding with anything. I can from other servers get it to respond with a pass/fail/neutral etc. I never get a response from this particular server. I'm not