<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=gb18030" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    <tt>Hello,<br>
      <br>
      The missing value should be provided by the dictionary.sip file
      (that comes with radius client library) - be sure you are using
      that dictionary on the server side too.<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
    <br>
    On 07/04/2013 03:44 AM, ㄨ冷se灬 wrote:
    <blockquote cite="mid:tencent_316D297900D938D25D2794C3@qq.com"
      type="cite">there is no errors <br>
      <br>
      <div>
        <div>from log I can see only like: <br>
          <br>
          [sql] Unsupported Acct-Status-Type = 15<br>
          ++[sql] returns noop</div>
        <div><br>
        </div>
        <div style="font-size: 12px; font-family: Arial Narrow; padding:
          2px 0pt;">------------------ 原始邮件 ------------------</div>
        <div style="font-size: 12px; background: none repeat scroll 0%
          0% rgb(239, 239, 239); padding: 8px;">
          <div><b>发件人:</b> "Laszlo"<a class="moz-txt-link-rfc2396E" href="mailto:laszlo@voipfreak.net">&lt;laszlo@voipfreak.net&gt;</a>;</div>
          <div><b>发送时间:</b> 2013年7月3日(星期三) 晚上6:16</div>
          <div><b>收件人:</b> "OpenSIPS users mailling
            list"<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org">&lt;users@lists.opensips.org&gt;</a>; <wbr></div>
          <div><b>主题:</b> Re: [OpenSIPS-Users]回复: freeradiusd-2.2.0
            Unsupported Acct-Status-Type= 15</div>
        </div>
        <div><br>
        </div>
        <p>What errors did you get?</p>
        <div class="gmail_quote">2013.07.03. 11:07, "ㄨ冷se灬" &lt;<a
            moz-do-not-send="true" href="mailto:291490117@qq.com">291490117@qq.com</a>&gt;
          ezt írta:<br type="attribution">
          <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
            0.8ex; border-left: 1px solid rgb(204, 204, 204);
            padding-left: 1ex;">
            <pre>readme.txt show me:
Patch for 
- Added support for acct type Failed (15)
- Added MySQL stored procedures support
- Removed Cisco hack that causes errors in radius.log if acctsessiontime= 0

but the patch isn't working.
</pre>
            <div>
              <div> <br>
              </div>
              <div><br>
              </div>
              <div style="font-size: 12px; font-family: Arial Narrow;
                padding: 2px 0pt;">------------------ 原始邮
                件 ------------------</div>
              <div style="font-size: 12px; background: none repeat
                scroll 0% 0% rgb(239, 239, 239); padding: 8px;">
                <div><b>发件人:</b> "Laszlo"&lt;<a moz-do-not-send="true"
                    href="mailto:laszlo@voipfreak.net" target="_blank">laszlo@voipfreak.net</a>&gt;;</div>
                <div><b>发送时间:</b> 2013年7月3日(星期三) 下午3:30</div>
                <div><b>收件人:</b> "OpenSIPS users mailling list"&lt;<a
                    moz-do-not-send="true"
                    href="mailto:users@lists.opensips.org"
                    target="_blank">users@lists.opensips.org</a>&gt;; </div>
                <div><b>主题:</b> Re: [OpenSIPS-Users] freeradiusd-2.2.0
                  Unsupported Acct-Status-Type= 15</div>
              </div>
              <div><br>
              </div>
              <div dir="ltr">
                <div>
                  <div>Did you compile freeradius from source? If so,
                    you will need to patch it and then recompile
                    freeradius.<br>
                  </div>
                  The patch can be found here: <a
                    moz-do-not-send="true"
href="http://download.dns-hosting.info/CDRTool/contrib/freeradius-brandinger/"
                    target="_blank">http://download.dns-hosting.info/CDRTool/contrib/freeradius-brandinger/</a><br>
                  <br>
                  <br>
                </div>
                <div>These are quite old patches, if the most recent
                  patch isn't working for you, then you will need to go
                  through the patching logic manually. It will involve
                  editing the following files:<br>
                  <br>
                </div>
                <div>
                  - freeradius/src/include/radius.h<br>
                </div>
                <div>- freeradius/src/modules/rlm_sql/conf.h<br>
                </div>
                <div>- freeradius/src/modules/rlm_sql/rlm_sql.c<br>
                </div>
                <div>- the config file under freeradius's /etc directory<br>
                  <br>
                </div>
                <div>Look at the lines with the "+" lines in the patch
                  file.<br>
                  <br>
                  <br>
                </div>
                <div>-Laszlo<br>
                </div>
                <div>
                  <div>
                    <div><br>
                    </div>
                  </div>
                </div>
              </div>
              <div class="gmail_extra"><br>
                <br>
                <div class="gmail_quote">2013/7/3 ㄨ冷se灬 <span dir="ltr">&lt;<a
                      moz-do-not-send="true"
                      href="mailto:291490117@qq.com" target="_blank">291490117@qq.com</a>&gt;</span><br>
                  <blockquote class="gmail_quote" style="margin: 0pt 0pt
                    0pt 0.8ex; border-left: 1px solid rgb(204, 204,
                    204); padding-left: 1ex;">dear all:<br>
                             I update my freeradius from v1.1.8 to
                    v2.2.0.<br>
                             when I use v2.2.0 ,I can’t see
                    unsuccessfully calls(like cancel,etc)<br>
                    <br>
                             and radius got this log:<br>
                    rad_recv: Accounting-Request packet from host
                    10.1.17.71 port 47962, id=165, length=510<br>
                        Acct-Status-Type = Failed<br>
                        Service-Type = IAPP-Register<br>
                        Sip-Response-Code = 487<br>
                        Sip-Method = Invite<br>
                        Event-Timestamp = "Jul  3 2013 08:55:14 CST"<br>
                        Sip-From-Tag = "202199366"<br>
                        Sip-To-Tag = "3c11a175"<br>
                        Acct-Session-Id = "<a moz-do-not-send="true"
                      href="mailto:261192415021484-264973041726312@10.49.2.236"
                      target="_blank">261192415021484-264973041726312@10.49.2.236</a>"<br>
                        User-Name = "<a moz-do-not-send="true"
                      href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br>
                        Billing-Party = "<a moz-do-not-send="true"
                      href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br>
                        Calling-Station-Id = "<a moz-do-not-send="true"
                      href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br>
                        Called-Station-Id = "<a moz-do-not-send="true"
                      href="http://sip:66687114@c.corp.esocc.com:5060"
                      target="_blank">sip:66687114@c.corp.esocc.com:5060</a>"<br>
                        Sip-Translated-Request-URI =
                    <a class="moz-txt-link-rfc2396E" href="sip:66687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9">"sip:66687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9"</a><br>
                        Source-IP = "221.228.228.14"<br>
                        Source-Port = "32670"<br>
                        SIP-Proxy-IP = "10.1.17.71"<br>
                        Canonical-URI =
                    <a class="moz-txt-link-rfc2396E" href="sip:008666687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9">"sip:008666687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9"</a><br>
                        User-Agent = "Voip Phone 1.0"<br>
                        Contact = "&lt;<a moz-do-not-send="true"
                      href="http://sip:66687113@221.228.228.14:32670"
                      target="_blank">sip:66687113@221.228.228.14:32670</a>&gt;"<br>
                        From-Header = "66687113 &lt;<a
                      moz-do-not-send="true"
                      href="http://sip:66687113@c.corp.esocc.com:5060"
                      target="_blank">sip:66687113@c.corp.esocc.com:5060</a>&gt;;tag=202199366"<br>
                        NAS-Port = 5060<br>
                        Acct-Delay-Time = 0<br>
                        NAS-IP-Address = 10.1.17.71<br>
                    # Executing section preacct from file
                    /usr/local/freeradius/etc/raddb/radiusd.conf<br>
                    +- entering group preacct {...}<br>
                    ++[preprocess] returns ok<br>
                    # Executing section accounting from file
                    /usr/local/freeradius/etc/raddb/radiusd.conf<br>
                    +- entering group accounting {...}<br>
                    [detail]     expand:
                    /usr/local/freeradius/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
                    -&gt; /usr/local/freeradius/var/log/radius/radacct/<a
                      moz-do-not-send="true"
                      href="http://10.1.17.71/detail-20130703"
                      target="_blank">10.1.17.71/detail-20130703</a><br>
                    [detail]
                    /usr/local/freeradius/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
                    expands to
                    /usr/local/freeradius/var/log/radius/radacct/<a
                      moz-do-not-send="true"
                      href="http://10.1.17.71/detail-20130703"
                      target="_blank">10.1.17.71/detail-20130703</a><br>
                    [detail]     expand: %t -&gt; Wed Jul  3 08:55:14
                    2013<br>
                    ++[detail] returns ok<br>
                    [sql] Unsupported Acct-Status-Type = 15<br>
                    ++[sql] returns noop<br>
                    Sending Accounting-Response of id 165 to 10.1.17.71
                    port 47962<br>
                    Finished request 1.<br>
                    Cleaning up request 1 ID 165 with timestamp +9<br>
                    Going to the next request<br>
                    Waking up in 3.4 seconds.<br>
                    Cleaning up request 0 ID 164 with timestamp +7<br>
                    Ready to process requests.<br>
                    <br>
                    <br>
                          It seem Unsupported Acct-Status-Type = 15,and
                    I check my dictionary <br>
                          VALUE Acct-Status-Type     Failed          
                    15         # RFC2866, acc<br>
                    <br>
                    <br>
                    <span style="text-indent: 0px; letter-spacing:
                      normal; font-variant: normal; text-align: start;
                      font-style: normal; display: inline ! important;
                      font-weight: normal; float: none; line-height:
                      normal; text-transform: none; font-size: 13px;
                      white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">      I'm sure there's a
                      configuration step I've missed. Could anyone
                      suggest some<span> </span></span><br
                      style="text-indent: 0px; letter-spacing: normal;
                      font-variant: normal; text-align: start;
                      font-style: normal; font-weight: normal;
                      line-height: normal; text-transform: none;
                      font-size: 13px; white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">
                    <span style="text-indent: 0px; letter-spacing:
                      normal; font-variant: normal; text-align: start;
                      font-style: normal; display: inline ! important;
                      font-weight: normal; float: none; line-height:
                      normal; text-transform: none; font-size: 13px;
                      white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">      other things to check?<span> </span></span><br
                      style="text-indent: 0px; letter-spacing: normal;
                      font-variant: normal; text-align: start;
                      font-style: normal; font-weight: normal;
                      line-height: normal; text-transform: none;
                      font-size: 13px; white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">
                    <br>
                    <br>
                    <br>
                    <br style="text-indent: 0px; letter-spacing: normal;
                      font-variant: normal; text-align: start;
                      font-style: normal; font-weight: normal;
                      line-height: normal; text-transform: none;
                      font-size: 13px; white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">
                    <span style="text-indent: 0px; letter-spacing:
                      normal; font-variant: normal; text-align: start;
                      font-style: normal; display: inline ! important;
                      font-weight: normal; float: none; line-height:
                      normal; text-transform: none; font-size: 13px;
                      white-space: normal; font-family:
                      Verdana,Geneva,Helvetica,Arial,sans-serif;
                      word-spacing: 0px;">Thanks<span> </span></span><br>
                    vic.xiang<br>
                    <br>
                    <br>
                    _______________________________________________<br>
                    Users mailing list<br>
                    <a moz-do-not-send="true"
                      href="mailto:Users@lists.opensips.org"
                      target="_blank">Users@lists.opensips.org</a><br>
                    <a moz-do-not-send="true"
                      href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
                      target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
                    <br>
                  </blockquote>
                </div>
                <br>
                <br clear="all">
                <br>
                -- <br>
                <div dir="ltr">
                  <div>
                    <div>
                      <div><br>
                        --<br>
                      </div>
                      Kind regards,<br>
                    </div>
                    Laszlo Bekesi<br>
                  </div>
                  <a moz-do-not-send="true" href="http://voipfreak.net"
                    target="_blank">http://voipfreak.net</a><br>
                </div>
              </div>
            </div>
            <br>
            _______________________________________________<br>
            Users mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
              target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
            <br>
          </blockquote>
        </div>
      </div>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
  </body>
</html>