The roster table ONLY gets updated when a *subscription* happens. IE. users A subscribes or adds user B to a group in their buddy list.
Rajesh Dharmalingam wrote: > Hi, > > I created new users and able to login. But when i check the roster, i > get the same old data as i sent you previously. The roaster table does > not get updated with the latest users. > > From config file: > The plugin for users > <Plugin DJabberd::Authen::HTDigest> > Realm djabberd > HtDigest /usr/local/chat/djabberd/djabberd.users > </Plugin> > > The plugin for SQLite: > <Plugin DJabberd::RosterStorage::SQLite> > Database /usr/local/chat/djabberd/DJabberd/roster.sqlite > </Plugin> > > I am creating the users as > htdigest -c djabberd.users djabberd user1 > htdigest -c djabberd.users djabberd user2 > > Am i missing something? > > Regards, > -Rajesh > > On Dec 11, 2007 1:08 AM, Edward Rudd <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Rajesh Dharmalingam wrote: > [snip] > > That means the subscriptiong didn't work right. Can you > provide a dump > > of your roster database? > > sqlite3 roster.sqlite .dump > > > > This is the output: > > > > BEGIN TRANSACTION; > [snip] > > CREATE TABLE roster ( > > userid INTEGER REFERENCES > jidmap > > NOT NULL, > > contactid INTEGER REFERENCES > jidmap > > NOT NULL, > > name VARCHAR(255), > > subscription INTEGER NOT NULL > > REFERENCES substates DEFAULT 0, > > PRIMARY KEY (userid, contactid) > > ); > Looks like no subscription information every got save. Odd.. the > roster > table should be filled with entries like (1,2, 'My User',3) and (2,1, > 'My Other User',3) > > Try specifying a *groupname* and alias when subscribing to users and see > how this DB changes. > > > > > -- > Regards, > -Rajesh > > "Stick to our roots and not to forget where we come from"
begin:vcard fn:Edward Rudd n:Rudd;Edward org:Netfor, Inc.;Development adr;dom:;;11810 Technology Lane;Fishers;IN;46038 email;internet:[EMAIL PROTECTED] title:Lead Programmer tel;work:317-813-4500 x 231 x-mozilla-html:FALSE url:http://www.netfor.com/ version:2.1 end:vcard
