Problem in receiving chat and User status is not authorized

Edward Rudd erudd at netfor.com
Mon Dec 10 20:25:54 UTC 2007


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 <erudd at netfor.com
> <mailto:erudd at netfor.com>> 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"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: erudd.vcf
Type: text/x-vcard
Size: 284 bytes
Desc: not available
Url : http://lists.danga.com/pipermail/djabberd/attachments/20071210/d08b05a7/erudd.vcf 


More information about the Djabberd mailing list