Monitoring plugin is failing to archive messages in mysql for MUC rooms

Hi All,

I was configuring messaging archiving in my openfire server. With mysql backend, openfire is not archiving MUC chats. The error was “You can’t specify target table” was in because of INSERT_MESSAGE variable. Making messageID column as NOT NULL AUTO GENERATE fixes the issue.

Server configuration:

  1. Running on mac osx (dev)
  2. mysql Ver 14.14 Distrib 5.6.23, for osx10.9



It can’t be an identity column because otherwise there’s no possibility for accessing the '313 archive prior to the deployment of the newer archive system. At least, I didn’t think so.

Maybe the SQL statement could be rephrased into a INSERT INTO … SELECT for better compatibility, rather than a subselect?