Re: Config check

I couldn't find any 2.8.0-1 SRPMS.

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

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 '=' Ja

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

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

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 / software-d

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

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'

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

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

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

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 postfix/do

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

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

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

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

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

Blacklist per-domain

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

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 (latin1_swedish_ci,

After postfix stop, postscreen remains alone without master supervisor process

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 39

Inbound email into script

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

> 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

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 data

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

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

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 fo

Re: Blacklist per-domain

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 usag

Re: Inbound email into script

Thank you Victor for taking the time to answer my questions. Please see respond inline On 24 January 2011 16:46, Victor Duchovni wrote: > > I have postfix setup to deliver all emails to @my-domain.com to an smrsh > > script. > > It is not clear why forgetting who the message was really sent t

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

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 addres

Re: Inbound email into script

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 mailto:victor.ducho...@morganstanley.com>> wrote: > I have postfix setup to deliver all emails to @my-domain.com

Re: Inbound email into script

On 24 January 2011 17:35, Noel Jones 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 >> > > wrote: >> >> >> >>

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

* Stefano Mason : > 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 Netzwerk Charité - Uni

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

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 a

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

Ralf Hildebrandt: > * Stefano Mason : > > 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. The postscreen daemon creates a child and finishe

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

* Wietse Venema : > 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é - Universitätsmedizin Be

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

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

Re: Inbound email into script

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 unmodifi

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

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 appe

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

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

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

Delivered-To header and local users

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

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

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

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

On Monday 24 January 2011 18:38:55 polofuzzu wrote: > On 24 January 2011 17:35, Noel Jones 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 > >>

Re: Inbound email into script

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 addresse

RE: problem with log file entry

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

Re: problem with log file entry

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

Re: problem with log file entry

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