cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
204
Views
0
Helpful
1
Replies

IM and Presence 9.1.1 Publisher Database

Hi,

I had to rebuild my IMP server and do not have a good backup. The subscriber is up and running, can I sync the subscriber database with Publisher and have a healthy cluster?

 

Thanks

1 Reply 1

Manish Gogna
Cisco Employee
Cisco Employee

Hi George,

This is not possible , you may need to export the database from the subscriber using some sql queries and import on new Pub after editing the outputs of the sql queries. For example:

 

run sql select u.jid, r.contact_jid, r.nickname, g.group_name from users u, rosters r,groups g where u.user_id = r.user_id and r.roster_id = g.roster_id

This will give a result something like the following for each contact:

jid                       contact_jid               nickname                    group_name
========================= ========================= =========================== ==========

Then just need to alter this to match what is required for the import, in the following format:

User ID,User Domain,Contact ID,Contact Domain,Nickname,Group Name
userA,example.com,userB,example.com,buddyB,General

 

Manish

- Do rate helpful posts -