<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <div class="moz-cite-prefix">On 13/08/14 15:46, Satish Patel wrote:<br>
    </div>
    <blockquote
cite="mid:CAPgF-fr5uSbGvHYh+Dwsa+mOcR2zvV2zEpw_Ep1_FRL+_f12+g@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>dictionary.kamailio has few attributes only! <br>
          <br>
        </div>
        also i am using CDRTool and in their document they suggest use
        /etc/freeradius/dictionary.
        <div>opensips <br>
          <br>
        </div>
        <div>I believe opensip and kamailio are same project, doesn't ?<br>
        </div>
      </div>
    </blockquote>
    I guess no. That project started as a fork of kamailio in 2008, with
    the goal of rewriting everything from scratch based on a different
    concept -- now 6 years later I expect they achieved the plans of
    writing from scratch. If they still look like same/similar, then
    maybe they surprisingly failed so far with their plans.<br>
    <br>
    On the other hand, here is about a dictionary file for radius
    library and server. Those are independent projects, so you can copy
    from one to another or use the other.<br>
    <br>
    Also, I have no clue on cdrtool expectations (well, being using
    cdrtools on linux for writing CDs, but here looks different), but if
    you look for a billing system/complete platform based on kamailio,
    check <a class="moz-txt-link-freetext" href="sip:provider">sip:provider</a> ce:<br>
    <br>
    - <a class="moz-txt-link-freetext" href="https://www.sipwise.com/products/spce/">https://www.sipwise.com/products/spce/</a><br>
    <br>
    It is free with a lot of features out of box, including advanced
    billing options.<br>
    <br>
    For something more lightweight/starting point, siremis includes two
    stored procedures for generating cdrs and rating them:<br>
    <br>
    -
<a class="moz-txt-link-freetext" href="http://sourceforge.net/p/siremis/git/ci/master/tree/siremis/modules/ser/mod.install.siremis.sql">http://sourceforge.net/p/siremis/git/ci/master/tree/siremis/modules/ser/mod.install.siremis.sql</a><br>
    - <a class="moz-txt-link-freetext" href="http://kb.asipto.com/siremis:install40x:accounting">http://kb.asipto.com/siremis:install40x:accounting</a><br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <blockquote
cite="mid:CAPgF-fr5uSbGvHYh+Dwsa+mOcR2zvV2zEpw_Ep1_FRL+_f12+g@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Wed, Aug 13, 2014 at 4:06 AM,
          Daniel-Constantin Mierla <span dir="ltr"><<a
              moz-do-not-send="true" href="mailto:miconda@gmail.com"
              target="_blank">miconda@gmail.com</a>></span> wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> First, you need to
              use dictionary.kamailio.<br>
              <br>
              Cheers,<br>
              Daniel
              <div>
                <div class="h5"><br>
                  <br>
                  <div>On 13/08/14 05:07, Satish Patel wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <div dir="ltr">
                      <div>somehow i am getting following error, if i
                        start radius<br>
                        <br>
                        Error: Errors reading dictionary: dict_init:
                        /etc/freeradius/dictionary.opensips[93]:
                        dict_addattr: Duplicate attribute name
                        Event-Timestamp<br>
                        <br>
                      </div>
                      <div>If i remove it from
                        /etc/freeradius/dictionary.opensips  file it
                        works! but my it screwed my time in mysql table<br>
                        <br>
                        ATTRIBUTE       Event-Timestamp        230    
                        string<br>
                      </div>
                      <div><br>
                        <br>
                      </div>
                      Just run grep to find out but it is not anywhere
                      define but still i am getting error<br>
                      <div><br>
                        root@<a moz-do-not-send="true">sip:/etc/freeradius#</a>
                        grep "Event-Timestamp" * -r<br>
                        dictionary.opensips:ATTRIBUTE      
                        Event-Timestamp        230     string<br>
                        sql.conf:                UNIX_TIMESTAMP('%S') -
                        '%{Event-Timestamp}', \<br>
                        sql.conf:                UNIX_TIMESTAMP('%S') -
                        '%{Event-Timestamp}', \<br>
                        sql.conf:                UNIX_TIMESTAMP('%S') -
                        '%{Event-Timestamp}', \<br>
                        sql.conf:               
                        FROM_UNIXTIME(%{Event-Timestamp}), \<br>
                        sql.conf:               
                        FROM_UNIXTIME(%{Event-Timestamp}), \<br>
                        sql.conf:                UNIX_TIMESTAMP('%S') -
                        '%{Event-Timestamp}', \<br>
                        sql.conf:                UNIX_TIMESTAMP('%S') -
                        '%{Event-Timestamp}', \<br>
                        <br>
                      </div>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                  </div>
                </div>
                <pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre>
                <span class="HOEnZb"><font color="#888888"> </font></span></blockquote>
              <span class="HOEnZb"><font color="#888888"> <br>
                  <pre cols="72">-- 
Daniel-Constantin Mierla
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Next Kamailio Advanced Trainings 2014 - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Sep 22-25, Berlin, Germany ::: Oct 15-17, San Francisco, USA</pre>
                </font></span></div>
            <br>
            _______________________________________________<br>
            SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
            mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
              target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Next Kamailio Advanced Trainings 2014 - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Sep 22-25, Berlin, Germany ::: Oct 15-17, San Francisco, USA</pre>
  </body>
</html>