Am 08.11.2013 15:59, schrieb Wietse Venema:
> Tobi:
>> 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
> When the same Postfix on different systems produces different
> results, then the difference is not Postfix, one would expect that
> that should be clear by now.
>
> Please use systematic elimination instead of wasting everyone's
> time with guesswork. Reproduce the problem configuration on other
> machines, one step at a time. Eventually you will find what part
> of your configuration is in error.
>
> Wietse
That's exactly the problem: I cannot reproduce this error on the two
other systems. I really tried hard to
If I look at this error message from postfix
<<
postmap: warning: mysql query failed: Table 'postfix.blacklist-cidr'
doesn't exist
>>
then I see that the table name in the error message is not as configured
in the cnf file.
The cnf file defines the name as `blacklist-cidr` but the error shows no
backticks. And without backticks the table cannot be found because of
the - sign in the name
<<
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
>>
this error shows up when I do not use backticks in the cnf file.
Sorry for wasting everyone's time. Probably better to rename the table
without - so no backticks are necessary. Other tables in the same
database but without - in their names work perfect from the server in
question.
tobi
