I just spent some time trying to set up dynamic mysql tables. The log keeps
Dec 13 15:26:01 INFO ( out/mysql ): *** Purging cache - START (PID: 20506) ***
Dec 13 15:26:01 ERROR ( out/mysql ): PRIMARY 'mysql' backend trouble.
Dec 13 15:26:01 ERROR ( out/mysql ): The SQL server says: Table
'pmacct.acct_out_20161213-1525' doesn't exist
The table 'pmacct.acct_out_20161213-1525' definitly exists - pmacct did
succesfully create it using the sql_table_schema from my config. After some
debugging I found that the problem is the "-" sign I am using for my table
names, as it is considered as a special character for mysql. To use special
characters in mysql you need to use the quote character - the backtick.
Its not a problem for me to go without these characters and its probably not a
good practice to use them in first place. But still maybe its worth thinking
about to wrap the dynamic sql statements generation into backticks to get
around this problem if someone needs to use such characters?
pmacct-discussion mailing list