Managing rosters in MSSQL 2000 database.
How does server store the roster/group in the database?
At first it seemed like it would be easy,
the tables jiveRoster & jiveRosterGroups
But if I manually make changes to the tables, such as adding a user to an entry to a users roster or if I delete a user from a users roster, they have no effect on the clients. Is there somewhere else that the roster/group information is stored by the server?
2 users “test” and “test2”, if I do…
insert into jiveRoster
(rosterID, username, jid, sub, ask, recv, nick)
(2, ‘‘test2’’,’‘test@server’’, 3, -1, -1, ‘‘test’’)
insert into jiveRosterGroups
(rosterID, rank, groupName)
There is no effect on the clients, the “test” user does have the testgroup nor the “test2” user.
BTW adding users to the roster/group works fine through the client.
I need to be able to create users/groups in the database to integrate into the rest of our systems. Any assistance is appreciated.