I have a production WildFire server which needs to be renamed (not the server, just the WildFire instance running on it). However, I have tested with another WildFire server and when I rename the WildFire server, this invalidates the rosters because the JID is now xxxx@newhostname. All client rosters contain xxxx@oldhostname and when trying to IM, they can no longer contact a person on their roster without having to re-add the contact.
Is there any way to update the rosters so that they contain the newhostname in the JID without having everyone recreate their rosters? I’‘m far from a DBA, but as the table name describes I’'m sure the rosters are stored in the jiveRoster table.
rosterID NUMBER n/a ID of roster (Primary Key)
username VARCHAR 32 User Name
The address of the roster entry
The subscription status of the entry
The ask status of the entry
Flag indicating the entry is a roster request that was received
The nickname assigned to this roster entry
If I create a query that will parse through the tables jid column for all oldhostnames and update with newhostname, will this remedy the issue?
I searched and searched but was not able to locate a related doc in the forum. Any help/direction that you can provide on this matter is greatly appreciated and thank you in advance.