On Fri, Nov 08, 2013 at 03:45:03PM +0100, Tobi wrote:
> The error message is 99.999% not from mysql. Because when I remove the
> backticks around the table name then I get an error from mysql which
> looks different
That error is also from MySQL. Postfix does not parse SQL queries,
the database client and server code do.
> And as this is a cluster based setup it's (imho) not possible that one
> client can see the table and another not
Databases do have access controls. And differnt ip:port means NAT
devices and/or load-balancers in the way, which may be consistently
connecting you to a different server in the cluster. In any case:
Post the output of:
$ cat -etv /path/table.cf
where "/path/table.cf" is the table config file in question. Also
post the output of
postmap -v -q 192.0.2.1 mysql:/path/table.cf
showing the database parameters and query (feel free to hide the
password value). Also post the exact same query typed into the
mysql command-line interpreter.
Do make sure the username and password sent by "postmap" are
IDENTICAL to the username and password you specify interactively.
Table access permissions may depend on the user login.
Anyway, this is really not a Postfix issue. Don't blame the
messenger, Postfix just prints the errors reported by the MySQL
library. You really must treat this as you would any other problem
with a MySQL application, check the login settings, query settings,
...
--
Viktor.
