mysql lookup table and utf8
Dear list, I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "relay access denied" errors in the logs) and I get the same result using postmap: > postmap -q raté.com mysql:/etc/postfix/sql-domains.cf >
mysql lookup table and utf8
Dear list, sorry for my previous incomplete message. I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "relay access denied" errors in the logs) and I get the same result using postmap: postmap -q raté.com mysql:/etc/postfix/sql-domains.cf If I try with a domain containing ascii characters only, it works just fine. What am I doing wrong ? Thanks for your help, Antoine Nguyen
Re: mysql lookup table and utf8
Antoine Nguyen: > Dear list, > > sorry for my previous incomplete message. > > I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 > domains. The setup is almost ready but when I make some tests, utf8 > domains are not found (I see "relay access denied" errors in the logs) > and I get the same result using postmap: > > > postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf > > And why should this return a result? Hint: do the sql query by hand. Wietse
Re: mysql lookup table and utf8
On 12/09/2016 12:42, Wietse Venema wrote: Antoine Nguyen: Dear list, sorry for my previous incomplete message. I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "relay access denied" errors in the logs) and I get the same result using postmap: postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf And why should this return a result? Hint: do the sql query by hand. The query returns a result when I execute it manually within the mysql shell. (sorry for the previous copy/paste, my email client does not use the same encoding) MariaDB [modoboa]> SELECT name FROM admin_domain WHERE name='raté.com' and enabled=1; +---+ | name | +---+ | raté.com | +---+ 1 row in set (0.01 sec) Antoine
Re: mysql lookup table and utf8
Antoine Nguyen: > On 12/09/2016 12:42, Wietse Venema wrote: > > Antoine Nguyen: > >> Dear list, > >> > >> sorry for my previous incomplete message. > >> > >> I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 > >> domains. The setup is almost ready but when I make some tests, utf8 > >> domains are not found (I see "relay access denied" errors in the logs) > >> and I get the same result using postmap: > >> > >>> postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf > >>> > > And why should this return a result? Hint: do the sql query by hand. > > > > > The query returns a result when I execute it manually within the mysql > shell. (sorry for the previous copy/paste, my email client does not use > the same encoding) > > MariaDB [modoboa]> SELECT name FROM admin_domain WHERE name='rat?.com' and > enabled=1; Just for test, what happens when you do: (this is what Postfix daemons use by default) LC_ALL=C postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf (this is to test what happens with an UTF-8 locale) LC_ALL=en_US.UTF-8 postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf Wietse
Re: mysql lookup table and utf8
On 12/09/2016 17:04, Wietse Venema wrote: Antoine Nguyen: On 12/09/2016 12:42, Wietse Venema wrote: Antoine Nguyen: Dear list, sorry for my previous incomplete message. I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "relay access denied" errors in the logs) and I get the same result using postmap: postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf And why should this return a result? Hint: do the sql query by hand. The query returns a result when I execute it manually within the mysql shell. (sorry for the previous copy/paste, my email client does not use the same encoding) MariaDB [modoboa]> SELECT name FROM admin_domain WHERE name='rat?.com' and enabled=1; Just for test, what happens when you do: (this is what Postfix daemons use by default) LC_ALL=C postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf (this is to test what happens with an UTF-8 locale) LC_ALL=en_US.UTF-8 postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf Still no result with both command lines. I'm a bit lost... could it be a mysql collation issue ? Antoine
Re: [PATCH] Preserve timestamps during 'make install'
Can you confirm that this patch is going to get merged in? Thanks. Ondra On 09/04/2016 04:47 PM, Viktor Dukhovni wrote: On Sun, Sep 04, 2016 at 04:25:36AM -0400, Ondrej Lysonek wrote: And what about 'touch -r ref'? I checked man pages of the systems listed on the Postfix home page, and the option '-r' is everywhere. I'm attaching a new patch. Yes, that should be quite portable, as it is in POSIX, both the 1997 and 2013 editions: http://pubs.opengroup.org/onlinepubs/7908799/xcu/touch.html http://pubs.opengroup.org/onlinepubs/9699919799/utilities/touch.html
Re: [PATCH] Preserve timestamps during 'make install'
Ondrej Lysonek: > And what about 'touch -r ref'? I checked man pages of the systems > listed on the Postfix home page, and the option '-r' is everywhere. > I'm attaching a new patch. Adopted, but I added the requirement that one says "postfix-install -keep-new-mtime ..." because this is a visible change for use in a custom installation process. Wietse
(ot) beware libressl on Freebsd
Freebsd 10.3I ran freebsd "pkg" and didn't see any of the mail suite or openssl in the list of files to update, so I figured it was safe to run. (I've been burnt by pkg messing up dovecot or postfix, so I always use the ports). Some program must of needed libressl and openssl got replaced, breaking my email. Even reinstalling openssl wasn't sufficient because any program using openssl broke. SpamAssassin was having none of this, so I ended up reinstalling the whole email suite. No con file issues fortunately. Openssl and libressl have a conflict, so I had uninstalled libressl prior to reinstalling openssl.I think ntp was the program that wanted libressl. It didn't occur to me the program even used TLS
Re: (ot) beware libressl on Freebsd
On Tue, Sep 13, 2016 at 6:13 AM, wrote: > Freebsd 10.3 > > I ran freebsd "pkg" and didn't see any of the mail suite or openssl in the > list of files to update, so I figured it was safe to run. (I've been burnt > by pkg messing up dovecot or postfix, so I always use the ports). > > Some program must of needed libressl and openssl got replaced, breaking my > email. Even reinstalling openssl wasn't sufficient because any program > using openssl broke. SpamAssassin was having none of this, so I ended up > reinstalling the whole email suite. No con file issues fortunately. > > Openssl and libressl have a conflict, so I had uninstalled libressl prior to > reinstalling openssl. > > I think ntp was the program that wanted libressl. It didn't occur to me the > program even used TLS > have you reported this to the any of the freebsd list(s)? -jf
