User Tune (XEP-0118) + shared rosters + offline storage

Openfire Openfire Support
1

Hi,

I was poking thru my database today and noticed that the jiveoffline table had 1,000,000+ rows in it! I sampled some of the messages and noticed it is filled with <tune/> stanzas from Pidgin. Checking further, each time somebody logs in, a message is placed in the database for each user not online and in the logged in user’s shared roster.

I suppose there is nothing wrong with this behaviour(?), but was wondering if other folks had ideas on how to work around it.

  1. Do I periodically scrub the database for these entries via some script?

  2. Hack at the openfire code to ignore these pubsub messages?

  3. Yell at my users to log on more often to clean those out?

Maybe I am missing a setting to help with this? thanks!

daryl

2

Hi,

Just to follow up on this. There was a bug with Pidgin between 2.3.0(?) and 2.4.0 that would cause it to send User Tune messages regardless of if the plugin was enabled. Having folks update to 2.4.1 is resolving this issue.

I also am manually deleting out the messages every so often

daryl