Am 07.11.2013 23:55, schrieb Viktor Dukhovni:
> On Thu, Nov 07, 2013 at 11:46:43PM +0100, Tobi wrote:
>
>>> If the ip/port are different, it is not the *SAME* configuration.
>> I know but it's not possible otherwise. The two other server reach
>> the mysql-cluster via other ips/ports.
> Do double-check that 3rd configuration file, make sure it contains
> no hidden backspace or unusual whitespace characters that might
> upset MySQL.
>
> If MySQL reports a missing table, I would not doubt that. Thus
> either your configuration has non-trivial differences you're not
> reporting, or you're reaching a different MySQL. Debug your NAT
> or cluster config.
>
Hi Victor
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
<<
postmap -q '192.167.34.21' mysql:/etc/postfix/mysql-test.cnf
*postmap: warning: mysql query failed: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '-cidr WHERE inet_aton('192.167.34.21')
BETWEEN `network` AND `broadcast`' at line 1*
postmap: fatal: table mysql:/etc/postfix/mysql-test.cnf: query error:
Success
2013 Nov 8 15:36:45 mail1 fatal: table
mysql:/etc/postfix/mysql-test.cnf: query error: Success
>>
Furthermore as I wrote in my first mail here I can connect via mysql
from my mailserver to the database and fire the query as stated in the
cnf file without any problem. So the query itself is a valid query for
mysql.
Normally I would not doubt if mysql reports a missing table. But if this
table would be really missing, then none of my mailserver would be in
operating state anymore.
I just connected from the mailserver in question to the datase using ip,
port and credentials from cnf file and made a show table
<<
mysql> show tables;
+-------------------+
| Tables_in_postfix |
+-------------------+
| alias |
| autoreply |
| blacklist-cidr |
| mailbox |
| vmailbox |
+-------------------+
>>
And as this is a cluster based setup it's (imho) not possible that one
client can see the table and another not
tobi
