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 session).
* The target MySQL database name and database user are clearly
identified in both cases.
* The queries and results are reported in detail.
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.
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
This is the result of postmap execution, it uses LATIN1 as encoding and
not UTF8... (whereas server default encoding is UTF8 and my shell's
current locale is en_US.UTF-8)
I haven't found how to change default client encoding yet... Does
postfix set it ?
Antoine
