[SR-Users] Table location, methods field

[Andrew O. Zhukov]

What I'm doing wrong?

select contact, User_agent, methods from location
where (methods & 2048) > 0 and user_agent like 'snom%';

contact                                  user_agent     methods
sip:3039200 at 10.0.1.55:2048;line=yd9qcfm9 snom320/7.3.14 7999


REGISTER sip:ipshka.com SIP/2.0
Via: SIP/2.0/UDP 10.0.1.55:2048;branch=z9hG4bK-sm9svrjytxjs;rport
From: "Andrew O. Zhukov" <sip:3039200 at ipshka.com>;tag=ir1p3z5ie6
To: "Andrew O. Zhukov" <sip:3039200 at ipshka.com>
Call-ID: 3c362d4fe75b-gi8h4zya7bbx
CSeq: 1170 REGISTER
Max-Forwards: 70
Contact: 
<sip:3039200 at 10.0.1.55:2048;line=yd9qcfm9>;reg-id=1;q=1.0;+sip.instance="<urn:uuid:4dd6e733-e1cf-4966-b724-35ecca091e52>";audio;mobility="fixed";duplex="full";description="snom320";actor="principal";events="dialog";methods="INVITE,ACK,CANCEL,BYE,REFER,OPTIONS,NOTIFY,SUBSCRIBE,PRACK,MESSAGE,INFO"
User-Agent: snom320/7.3.14
Supported: gruu
Allow-Events: dialog
X-Real-IP: 10.0.1.55
Expires: 3600
Content-Length: 0
-----------------------------------------

So 7999 it's 1111100111111 binary

INVITE, 1
ACK,    3
CANCEL, 2
BYE,    4
INFO,   5
*
SUBSCRIBE, 7
NOTIFY, 8
MESSAGE, 9
OPTIONS, 10
PRACK, 11
*
REFER,  13

Something wrong !!!


On 06/30/2011 12:15 PM, Henning Westerholt wrote:
> On Thursday 30 June 2011, Andrew O. Zhukov wrote:
>> Can someone send me bitmasks for the Subj.
>> Or just the reference to include file with comments in a source code.
>> I can't find it in all set of availible document's since the SER router. :(
>>
>> I just have to know which UA except Grandstreams an CSipsample use RFC3311
>> :)
>
> Hi Andrew,
>
> they are defined in the parser, as power of two integers:
>
> http://sip-router.org/doxygen/sip-router/branch/master/msg__parser_8h.html#a82f3c7234c5469f18d5e9fac5700cf27
>
> Best regards,
>
> Henning
>