Problem in receiving chat and User status is not authorized

Edward Rudd erudd at netfor.com
Mon Dec 10 19:38:47 UTC 2007


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.
-------------- 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/d5fbfd5e/erudd.vcf 


More information about the Djabberd mailing list