ejabberd - Comments for "[Fixed] Some users cannot connect anymore since 16.09 update - Pubsub errors"

Thank you very much for your

TH-Gemini — Fri, 23 Dec 2016 07:47:57 +0000

Thank you very much for your precious advice. It allowed me to fixed these users login problems.
Kind regards.

Login to ejabberd WebAdmin ->

badlop — Wed, 30 Nov 2016 12:14:13 +0000

Login to ejabberd WebAdmin -> Nodes -> your node -> Database -> on each pubsub table, switch to "delete content" -> then click "Send"

Indeed, I have confirmed it

TH-Gemini — Mon, 28 Nov 2016 23:12:07 +0000

Indeed, I have confirmed it is related to pubsub data : I managed to allow that user connect by disabling pubsub for the whole server.

However, this is not really a solution, but just a workaround. It is totally acceptable to empty all the pubsub data.

The database system used is Mnesia. Could you please explain me how I can delete the pusub table contents with Mnesia ?

As you can see most of the

badlop — Fri, 25 Nov 2016 16:08:48 +0000

As you can see most of the elements in the XMPP packets are in binary format: <<"something">>, and using the new xmlel. But somewhere in the log I can see plain strings: "something" and the old xmlelement. This probably indicates that migration of data in the database from old format to new format was not complete, maybe due to a bug in ejabberd.

The good news is that apparently the half-migrated data is in the pubsub table. If you are using SQL, try to delete the entries in pubsub tables related to that user. If you are using mnesia, probably you don't know how to do this... is it acceptable for you to delete all the pubsub table contents?