[Serusers] SER+Freeradius+CDRTool: rlm_sql problem Unsupported Acct-Status-Type Failed

[Ilya Pichugin]

Hi,

I installed openSER 1.3, Freeradius 1.1.6, CDRTool v6.7.2

Now I can see in my CDRtool web-interface successfully calls (OK 200), but I
want to see unsuccessfully calls too (like Cancel, etc)

In radius RFC this type of calls binded by
VALUE Acct-Status-Type     Failed           15         # RFC2866, acc

So, in radius debug I see messages like:

raddact:
Mon Mar 23 09:14:51 2009
        Acct-Status-Type = Failed
        Service-Type = Sip-Session
        Sip-Response-Code = 487
        Sip-Method = Invite
        Event-Timestamp = "Mar 23 2009 09:14:51 MSK"
        Sip-From-Tag = "f758dc31"
        Sip-To-Tag = "5affff00ff10ff10ff00003048ffff26"
        Acct-Session-Id = "OTQxMDJmOGE4ZjQ0MjVlNTJlMjE0ZGNmYjg1YjlmZmE."
        Acct-Session-Id = "OTQxMDJmOGE4ZjQ0MjVlNTJlMjE0ZGNmYjg1YjlmZmE."
        Calling-Station-Id = "sip:33640000 at mysipserver.com"
        Sip-Translated-Request-URI = "sip:2984545 at xx.xxx.xxx.xx:5060"
        User-Name = "3360000"
        Media-Codecs = "call|3360000|mysipserver.com|<null>"
        Media-Info = "2984545|xxx.xx.xxx.xx|<null>"
        NAS-Port = 5060
        Acct-Delay-Time = 0
        NAS-IP-Address = 127.0.0.1
        Timestamp = 1237788891


and radius.log:
Sat Mar 21 20:39:18 2009 : Info: rlm_sql (sql): Unsupported Acct-Status-Type = 15


I tried to install Freeradius-2.1.4 and I get same thing:

Mon Mar 23 11:17:29 2009 : Error: rlm_radutmp: NAS localhost port 5060 unknown packet type 15)


But! I see success processing Cancel-calls at AG-projects in screen
like http://cdrtool.ag-projects.com/attachment/wiki/WikiStart/CDRTool-CallSearch.jpg

So, how may I fix this trouble?

Thanks a lot.
        


-- 
Best Regards,
Ilya Pichugin