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
jid
TEXT
n/a
The address of the roster entry
sub
NUMBER
n/a
The subscription status of the entry
ask
NUMBER
n/a
The ask status of the entry
recv
NUMBER
n/a
Flag indicating the entry is a roster request that was received
nick
VARCHAR
255
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.