How to change JID's domain in Tigase database
We would like to change our xmpp domain from let say test.com to test.net. Supposing that, thousands of users have been registered in Tigase database with test.com. Is there any way, for instance an Ad-hoc command, to convert Tigase database full JID domains from test.com to test.net?
Added by Wojciech Kapcia over 2 years ago
Currently there is no easy way to achieve that - it requires changing each item in user_id column in the database and in addition to that re-calculating sha1 value for each row.
In addition - if you are using PubSub or Message Archiving component same process should be applied to it's tables.