powered by Jive Software

Table ofRoster - meaning of sub/ask/recv

column ASK

ASK_NONE = -1

The roster item has no pending subscription requests.

ASK_SUBSCRIBE = 0

The roster item has been asked for permission to subscribe to their presence but no response has been received.

ASK_UNSUBSCRIBE = 1

The roster owner has asked to the roster item to unsubscribe from it’s presence but has not received confirmation.

column RECV

RECV_NONE = -1

There are no subscriptions that have been received but not presented to the user.

RECV_SUBSCRIBE = 1

The server has received a subscribe request, but has not forwarded it to the user.

RECV_UNSUBSCRIBE = 2

The server has received an unsubscribe request, but has not forwarded it to the user.

column SUB

SUB_REMOVE = -1

Indicates the roster item should be removed.

SUB_NONE = 0

No subscription is established.

SUB_TO = 1

The roster owner has a subscription to the roster item’s presence.

SUB_FROM = 2

The roster item has a subscription to the roster owner’s presence.

SUB_BOTH = 3

The roster item and owner have a mutual subscription.

Information taken from org.jivesoftware.openfire.roster.RosterItem

Dearl all,

I have a problem with openfire Subscription Properties. The first i have set Subscription Service Settings

like this :

  • Subscription requests will be intercepted and rejected and

  • Only subscription requests sent by users who do not have an account on gozigo will be intercepted and rejected.

so member can’t add contact from spark.

First I make a member and Merland Moses.
I try to manually add in the table ofRoster like this:

rosterID username JID sub recv aks nick

36 moses merland @ gozigo 3 -1 -1 merland

37 merland moses @ gozigo 3 -1 -1 moses

and in the table ofRosterGroups
rosterID rank groupName

36 0 Friends

37 0 Friends

I logged in with spark (user = moses) but the user merland does not appear in the list my friend.

what should I do, so user Merland appear in the list my friend.:slight_smile:

thanks

You will need to clear Openfire’s roster cache after manipulating the database. You can do that via AdminConsole. (Another option would be restarting Openfire)