convert all incoming files from postfix

Hi List, Is there utility/tool to convert incoming emails to text and convert attachments to pdf/a format? Eero

Re: mysql lookup table and utf8

On 14/09/2016 04:01, Viktor Dukhovni wrote: On Tue, Sep 13, 2016 at 09:52:16PM +0200, Antoine Nguyen wrote: query = SELECT name FROM admin_domain WHERE name='%s' AND type='domain' AND enabled=1 What is not clear is how MySQL's quoting behaves given the input UTF-8 string. postmap: cfg_get_s

Re: mysql lookup table and utf8

On 14/09/2016 10:27, Antoine Nguyen wrote: The first query was executed using mysql shell and it returns 1 row. The second query was executed by postmap and returns nothing whereas we can see they are the same... I've just tried with postgresql and the result is the same... Antoine

Creating a catch all domain

Hi, I'm obfuscated trying to configure a server for a catch-all domain (all mail directed to that domain delivered to a single mailbox). My problem is that I want all mail received for @mydomain.com to be delivered to a single locally mailbox, but r...@mydomain.com to be relayed to the act

Re: mysql lookup table and utf8

Antoine Nguyen: [ Charset windows-1252 converted... ] > On 14/09/2016 10:27, Antoine Nguyen wrote: > > The first query was executed using mysql shell and it returns 1 row. > > The second query was executed by postmap and returns nothing whereas > > we can see they are the same... > > > I've just

Re: mysql lookup table and utf8

On 14/09/2016 12:53, Wietse Venema wrote: Antoine Nguyen: [ Charset windows-1252 converted... ] On 14/09/2016 10:27, Antoine Nguyen wrote: The first query was executed using mysql shell and it returns 1 row. The second query was executed by postmap and returns nothing whereas we can see they ar

Re: convert all incoming files from postfix

On Wed, Sep 14, 2016 at 10:46:06AM +0300, Eero Volotinen wrote: Hi List, Is there utility/tool to convert incoming emails to text and convert attachments to pdf/a format? It looks like Mimedefang should be able to do this, but you'll need to know how to write some perl. A devil's advocate q

Re: Message size limit responses

In een bericht van 14-9-2016 5:11: By "message" do you mean an actual piece of email reporting the problem or a notification in the Thunderbird user interface? I mean indeed by Thunderbird. Email messages reporting a delivery failure are almost always generated by some MTA, e.g. Postfix. The

Re: convert all incoming files from postfix

2016-09-14 14:42 GMT+03:00 Darac Marjal : > On Wed, Sep 14, 2016 at 10:46:06AM +0300, Eero Volotinen wrote: > >> Hi List, >> >> Is there utility/tool to convert incoming emails to text and convert >> attachments to pdf/a format? >> > > It looks like Mimedefang should be able to do this, but you'll

After smtps rejection, fails falling back to smtp (TLS) (Postfix 3.1.0)

I am using Postfix 3.1.0 and following instructions at http://www.postfix.org/TLS_README.html#client_smtps to set up for sending some (recipient dependent) emails via smtps (whereas others go over TLS to a different relay server). This uses the transport_maps settings in main.cf, a transport file (

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 10:27:32AM +0200, Antoine Nguyen wrote: > >Do make sure that your tests with the sql CLI really make the same > >query against the same database: > > > > SELECT name FROM admin_domain WHERE name='' AND > > type='domain' AND enabled=1 > > > I've enabled queries logging.

Re: After smtps rejection, fails falling back to smtp (TLS) (Postfix 3.1.0)

On Wed, Sep 14, 2016 at 01:11:53PM +0100, Dominic Raferd wrote: > I am using Postfix 3.1.0 and following instructions at > http://www.postfix.org/TLS_README.html#client_smtps to set up for sending > some (recipient dependent) emails via smtps (whereas others go over TLS to > a different relay serv

Re: mysql lookup table and utf8

On 14/09/2016 14:17, Viktor Dukhovni wrote: On Wed, Sep 14, 2016 at 10:27:32AM +0200, Antoine Nguyen wrote: Do make sure that your tests with the sql CLI really make the same query against the same database: SELECT name FROM admin_domain WHERE name='' AND type='domain' AND enabled=1 I'

After smtps rejection, fails falling back to smtp (TLS) (Postfix 3.1.0)

I am using Postfix 3.1.0 and following instructions at http://www.postfix.org/TLS_README.html#client_smtps to set up for sending some (recipient dependent) emails via smtps (whereas others go over TLS to a different relay server). This uses t

Re: After smtps rejection, fails falling back to smtp (TLS) (Postfix 3.1.0)

Thanks for your quick reply Viktor. OK now I understand that what I am trying to do can't be done. If someone could implement the feature you suggest (wrapper mode is enabled conditionally, only when the port is 465, and not when it is some other port) that would of course be ideal. Background: sm

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 02:33:47PM +0200, Antoine Nguyen wrote: > >>> SELECT name FROM admin_domain WHERE name='' AND > >>> type='domain' AND enabled=1 > >>> > >>I've enabled queries logging. Here is the result : > >> > >>160914 8:24:14 57 QuerySELECT name FROM admin_domain WHERE

Re: mysql lookup table and utf8

On 14/09/2016 14:53, Viktor Dukhovni wrote: Please post a single message with two complete traces in which: * The Unix login users executing "postmap -q" and using the MySQL shell are the same. (That is the same unix shell spawns both "postmap -q" and the MySQL interactive sess

Re: mysql lookup table and utf8

On 14/09/2016 16:09, Antoine Nguyen wrote: As I said, I made some tests with postgres and I think I found an interesting hint inside logs: LOG: statement: set client_encoding to 'LATIN1' LOG: statement: SELECT name FROM admin_domain WHERE name='raté.com' AND type='domain' AND enabled Thi

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 04:14:32PM +0200, Antoine Nguyen wrote: > >I haven't found how to change default client encoding yet... Does postfix > >set it ? > > Sorry to reply to myself but looks like the answer is here: > > https://github.com/vdukhovni/postfix/blob/506a3e8993d1d73b397a113b89319ff99

Re: (ot) beware libressl on Freebsd

I'm fixing a few other problems due to the upgrade, but will follow up on libressl eventually.  I'm a long time Linux user, but only have been using Freebsd for a little over a year, so I am cautious to do any rants. ;-)  (I have endured the wrath of Linux users mocking Yast, but I have yet to

Re: mysql lookup table and utf8

On 14/09/2016 17:06, Viktor Dukhovni wrote: On Wed, Sep 14, 2016 at 04:14:32PM +0200, Antoine Nguyen wrote: I haven't found how to change default client encoding yet... Does postfix set it ? Sorry to reply to myself but looks like the answer is here: https://github.com/vdukhovni/postfix/blob/

Re: mysql lookup table and utf8

On 14/09/2016 14:53, Viktor Dukhovni wrote: Please look for any client-side configuration files that might be loaded by the MySQL interactive shell that may affect connection settings, such as perhaps the client character set. Looks like I've found the issue. Actually, the mysql connector doe

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 05:39:50PM +0200, Antoine Nguyen wrote: > >Yes, the Postgres driver is unconditionally LATIN1 at present. > > And this limitation does not exist with the mysql one ? No. Nothing in Postfix explicitly sets the MySQL client encoding. Perhaps that's needed for utf-8 (i.e. do

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 06:07:22PM +0200, Antoine Nguyen wrote: > Looks like I've found the issue. Actually, the mysql connector does not read > the default /etc/my.cnf file (or at least the package I installed for CentOS > 7). Perhaps Postfix needs to try to explicitly load the default config lo

Postfix transport - master_service_disable

Hi List Hoping to clarify if remote transport mappings can be restricted. At this point it appears that master_service_disable allows for specific listeners to be disabled. However the type of listener/service specific to transport mappings "587 submission" is unclear. Essentially t

Re: mysql lookup table and utf8

Viktor Dukhovni: > On Wed, Sep 14, 2016 at 06:07:22PM +0200, Antoine Nguyen wrote: > > > Looks like I've found the issue. Actually, the mysql connector does not read > > the default /etc/my.cnf file (or at least the package I installed for CentOS > > 7). > > Perhaps Postfix needs to try to explic

Re: mysql lookup table and utf8

On Wed, Sep 14, 2016 at 04:14:57PM +, Viktor Dukhovni wrote: > > @Viktor Do you confirm it is not currently possible to host UTF8 domains > > with a postgres backend ? > I don't believe it is. We probably need to make that "LATIN1" > configurable via the ".cf" file. I'm curious what just hard

Re: mysql lookup table and utf8

On 09/14/16 13:44, Wietse Venema wrote: > Viktor Dukhovni: >> On Wed, Sep 14, 2016 at 06:07:22PM +0200, Antoine Nguyen wrote: >> >>> Looks like I've found the issue. Actually, the mysql connector does not read >>> the default /etc/my.cnf file (or at least the package I installed for CentOS >>> 7).

Re: mysql lookup table and utf8

On 14/09/2016 22:07, Phil Stracchino wrote: On 09/14/16 13:44, Wietse Venema wrote: Viktor Dukhovni: On Wed, Sep 14, 2016 at 06:07:22PM +0200, Antoine Nguyen wrote: Looks like I've found the issue. Actually, the mysql connector does not read the default /etc/my.cnf file (or at least the pac

Re: mysql lookup table and utf8

> >> Perhaps Postfix needs to try to explicitly load the default config > >> location when no override is set. > > > > How do we do that, without hard-coding '/etc/my.cnf' into Postfix? > > That pathname is almost certainly incorrect on systems like *BSD > > that install ports configuration files

Re: mysql lookup table and utf8

On 09/14/16 19:29, Wietse Venema wrote: Perhaps Postfix needs to try to explicitly load the default config location when no override is set. >>> >>> How do we do that, without hard-coding '/etc/my.cnf' into Postfix? >>> That pathname is almost certainly incorrect on systems like *BSD >>>

Effects of very large message_size_limit?

Hi, I'm wondering what the downside of setting a large message_size_limit are? By "large" I mean 30MB, 40MB, 50MB I think sendmail has a default of no restriction for message size - that seems crazy, but maybe I don't understand the risks well enough.

Re: Complaints due to helo restrictions

On 13/9/2016 8:52 μμ, Wietse Venema wrote: I'd use none of these. Thank you all for your feedback. Following Wietse's advice, I have removed these directives from the config. All the best, Nick

Re: Creating a catch all domain

El 14/09/16 a las 11:38, Angel L. Mateo escribió: Hi, I'm obfuscated trying to configure a server for a catch-all domain (all mail directed to that domain delivered to a single mailbox). My problem is that I want all mail received for @mydomain.com to be delivered to a single locally ma

Re: Effects of very large message_size_limit?

Am 15.09.2016 um 07:19 schrieb mro...@insiberia.net: > Hi, I'm wondering what the downside of setting a large > message_size_limit are? > > By "large" I mean 30MB, 40MB, 50MB > > I think sendmail has a default of no restriction for message size - that > seems crazy, but maybe I don't understand t