powered by Jive Software

Dropped Subscriptions-- urgent

Hi all:

I recently migrated a server from Debian 7 (Openfire 3.9.3) to Debian 9 (Openfire 4.2.3). My issue is that users’ subscriptions are randomly dropping, with no notification to the users or to the server.

On the old server I exported the original mysql database with a mysqldump:

mysqldump -u root -p openfire -u > mysqldump.sql

And on the new server, imported it with:

mysql -u openfire -p openfire -v < mysqldump.sql

I’m finding that subscriptions that were in place during the orignal import disappear after a seemingly random amount of time (~20 minutes?). By subscriptions, I mean entries that are in the openfire.ofPubsubSubscription table in the openfire database.

After users subscribe and start receiving messages, I’m seeing their entries in that table in MariaDB:

select * from ofPubsubSubscription;

But again, after a set amount of time, they disappear from that table.

My questions are:

  1. What is causing this behavior, and how can I prevent it?
  2. Where and what logs can I look to get more information?
  3. What else could be going on with my migration that could be causing this? Everything else (users, nodes, etc) seem to be working fine.

Thanks!