I've checked the code for add_rosteritem function on mod_admin_extra module.
It looks like this function adds roster items to mnesia database. If you use a MySQL database, you have no luck.
I could write to MySQL database if I know what the rosterusers table values supposed to be.
Here is the rosterusers table. I have put comments below for each columns.
CREATE TABLE rosterusers (
username varchar(250) NOT NULL, --owner
jid varchar(250) NOT NULL, --buddy's JID
nick text NOT NULL, --buddy's nickname
subscription character(1) NOT NULL, --??? What are we supposed to enter here since this is a 1 char long column...
ask character(1) NOT NULL, --??? No clue
askmessage text NOT NULL, --??? No clue
server character(1) NOT NULL, --??? No clue
subscribe text NOT NULL, --??? [none, from, to, both]
type text, --??? No clue
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8;I would really appreciate if I can get any feedback on this.
Thanks
Re
This uses the same schema than jabberd1, so it was never documented in ejabberd.
You can try to setup mod_roster_odbc, create two accounts, add themselves and look in the table what values do the rows take. Add also contacts like to see also values when contacts are not fully subscribed.