Daniel,<div><br></div><div>   One question I do have - is the $timef(%Y%m%d)  evaluated only once at run time (when kamailio is started) - or is it evaluated at the time of the ACC&#39;ing action.</div><div><br></div><div>
Sincerely,</div><div>Brandon Armstead<br><br><div class="gmail_quote">On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</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">
    Hello,<br>
    <br>
    the $timef(...) is evaluated, but you don&#39;t have time specifiers
    there, only static letters. You have to use % in front of the
    letters, as I guess from the example:<br>
    <br>
    <a href="http://www.kamailio.org/wiki/cookbooks/3.2.x/pseudovariables" target="_blank">http://www.kamailio.org/wiki/cookbooks/3.2.x/pseudovariables</a><br>
    <br>
    Try acc_$timef(%Y%m%d).<br>
    <br>
    Cheers,<br>
    Daniel<div><div class="h5"><br>
    <br>
     <br>
    <div>On 8/14/12 10:17 PM, Brandon Armstead
      wrote:<br>
    </div>
    <blockquote type="cite">Daniel,
      <div><br>
      </div>
      <div>    My apologies - forgot to make clean.  However still no
        cigar.</div>
      <div><br>
      </div>
      <div>
        <div>Aug 14 20:16:40 /usr/local/sbin/kamailio[12410]: ERROR:
          db_mysql [km_dbase.c:122]: driver error on query: Table
          &#39;kamailio.acc_Ymd&#39; doesn&#39;t exist</div>
        <div>Aug 14 20:16:40 /usr/local/sbin/kamailio[12410]: ERROR: acc
          [acc.c:405]: failed to insert into database</div>
        <div><br>
        </div>
        <div>Sincerely,</div>
        <div>Brandon Armstead</div>
        <br>
        <div class="gmail_quote">On Tue, Aug 14, 2012 at 1:11 PM,
          Daniel-Constantin Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</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"> Hello,<br>
              <br>
              are you sure you re-installed and the right acc.so is
              used?<br>
              <br>
              The support is for generic PV, if it works with one it
              should work with any. Which one does work for you?<br>
              <br>
              Can you give exact table name as printed in the SQL query?
              Does it have the parenthesis and the format string?<br>
              <br>
              Cheers,<br>
              Daniel
              <div>
                <div><br>
                   <br>
                  <div>On 8/14/12 9:55 PM, Brandon Armstead wrote:<br>
                  </div>
                  <blockquote type="cite">Daniel,
                    <div><br>
                    </div>
                    <div>   Patch applies fine - it still does not seem
                      to take when using $timef, i..e</div>
                    <div><br>
                    </div>
                    <div>modparam(&quot;acc&quot;, &quot;db_table_acc&quot;,
                      &quot;acc_$timef(Ymd)&quot;)</div>
                    <div> <br>
                    </div>
                    <div>It looks as if the $timef is not being
                      interpreted and is simply writing to acc&#39;ing i.e.
                      INSERT INTO acc_$timef</div>
                    <div><br>
                    </div>
                    <div>Thanks!</div>
                    <div><br>
                    </div>
                    <div>Sincerely,</div>
                    <div>Brandon Armstead<br>
                      <div class="gmail_quote">On Tue, Aug 14, 2012 at
                        12:48 PM, Daniel-Constantin Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</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"> Hello,<br>
                            <br>
                            I reapplied the patch (cherry-picked from
                            the initial one) to the master branch.<br>
                            <br>
                            Can you test that and see if it works fine?<br>
                            <br>
                            You can cherry-picked to your branch, try:<br>
                            <br>
                            git pull origin<br>
                            git cherry-pick -x
                            95ee0a3ee75556a25f3a9286837a57decf6c3c91<br>
                            <br>
                            If it applies fine, compiles and the test go
                            ok, then I will backport as soon as Juha
                            confirms that was no solid reason in
                            discarding this feature by his commit.<br>
                            <br>
                            Cheers,<br>
                            Daniel
                            <div>
                              <div><br>
                                <br>
                                <div>On 8/14/12 9:21 PM, Brandon
                                  Armstead wrote:<br>
                                </div>
                                <blockquote type="cite">Daniel,
                                  <div><br>
                                  </div>
                                  <div>   In my research I saw that
                                    commit as well but figured it was
                                    some kind of weird merging error.
                                     Thanks for your time!  Look forward
                                    to hearing back from you guys.</div>
                                  <div><br>
                                  </div>
                                  <div>Sincerely,</div>
                                  <div>Brandon Armstead<br>
                                    <br>
                                    <div class="gmail_quote">On Tue, Aug
                                      14, 2012 at 12:04 PM,
                                      Daniel-Constantin Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</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"> Hello,<br>
                                          <br>
                                          checked the sources and it
                                          seems that Juha reverted this
                                          feature with the commit:<br>
                                          <br>
                                          <a href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca" target="_blank">http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca</a><br>

                                          <br>
                                          I guess it was accidentally, I
                                          will ask on devels list.<br>
                                          <br>
                                          Cheers,<br>
                                          Daniel
                                          <div>
                                            <div><br>
                                              <br>
                                              <br>
                                              <div>On 8/14/12 7:34 PM,
                                                Brandon Armstead wrote:<br>
                                              </div>
                                              <blockquote type="cite">
                                                <div>Let me also add
                                                  that I am using 3.2
                                                  but I see the commit
                                                  was quite some time
                                                  ago so I have a
                                                  feeling it wouldn&#39;t
                                                  work in 3.3 either.
                                                   Thanks!</div>
                                                <div><br>
                                                  Sent from my iPhone</div>
                                                <div><br>
                                                  On Aug 14, 2012, at
                                                  10:27 AM,
                                                  Daniel-Constantin
                                                  Mierla &lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;



                                                  wrote:<br>
                                                  <br>
                                                </div>
                                                <blockquote type="cite">
                                                  <div> Hello,<br>
                                                    <br>
                                                    this functionality
                                                    should be already
                                                    there. Doesn&#39;t work
                                                    for you?<br>
                                                    <br>
                                                    Cheers,<br>
                                                    Daniel<br>
                                                    <br>
                                                    <div>On 8/14/12 7:16
                                                      PM, Brandon
                                                      Armstead wrote:<br>
                                                    </div>
                                                    <blockquote type="cite">Sorry
                                                      to wake up an old
                                                      thread.
                                                      <div><br>
                                                      </div>
                                                      <div>However - I
                                                        am looking to
                                                        export this
                                                        $timef function
                                                        to the param
                                                        initialization
                                                        for accounting,
                                                        i.e.
                                                        db_table_acc</div>
                                                      <div><br>
                                                      </div>
                                                      <div>modparam(&quot;db_table_acc&quot;,

&quot;acc_$ftime(Ymd)&quot;);</div>
                                                      <div><br>
                                                      </div>
                                                      <div>I&#39;ve looked
                                                        into completing
                                                        this myself
                                                        however I simply
                                                        am not familiar
                                                        enough at this
                                                        point between
                                                        the three
                                                        different
                                                        modules that it
                                                        would take to
                                                        implement this
                                                        (acc, dbsr1,
                                                        pv).</div>
                                                      <div><br>
                                                      </div>
                                                      <div>Look forward
                                                        to any help /
                                                        insight you may
                                                        be able to
                                                        provide.</div>
                                                      <div><br>
                                                      </div>
                                                      <div>Thanks as
                                                        always!</div>
                                                      <div><br>
                                                      </div>
                                                      <div>Sincerely,</div>
                                                      <div>Brandon
                                                        Armstead<br>
                                                        <br>
                                                        <div class="gmail_quote">On

                                                          Mon, Dec 19,
                                                          2011 at 11:55
                                                          AM,
                                                          Daniel-Constantin
                                                          Mierla <span dir="ltr">&lt;<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>&gt;</span>
                                                          wrote:<br>
                                                          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,


                                                          <div>
                                                          <div><br>
                                                          <br>
                                                          On 12/19/11
                                                          7:50 PM,
                                                          Andreas Granig
                                                          wrote:<br>
                                                          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                                          Hi Daniel,<br>
                                                          <br>
                                                          On 12/19/2011
                                                          07:29 PM,
                                                          Daniel-Constantin
                                                          Mierla wrote:<br>
                                                          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                                          I don&#39;t know
                                                          what are all
                                                          the functions
                                                          you think of,
                                                          but for the<br>
                                                          example
                                                          provided
                                                          above, config
                                                          file does it
                                                          easy right
                                                          now. There is
                                                          a<br>
                                                          pseudo-variable

                                                          that gives
                                                          broken-time
                                                          attribute that
                                                          can be used
                                                          with<br>
                                                          avp_check(),
                                                          iirc, should
                                                          be:<br>
                                                          <br>
avp_db_load(...);<br>
                                                          if(avp_check(&quot;$time(wday)&quot;,


                                                          &quot;eq/$avp(s:cf_weekday)/g&quot;))

                                                          { do CF }<br>
                                                          <br>
                                                          Of course
                                                          there is the
                                                          option of
                                                          doing while
                                                          loop, but
                                                          maybe gets to<br>
                                                          large for
                                                          desired config
                                                          file.<br>
                                                          </blockquote>
                                                          This is pretty
                                                          much what I
                                                          had in mind
                                                          with my new
                                                          functions/module,
                                                          but<br>
                                                          I&#39;ve
                                                          completely
                                                          overlooked
                                                          that PV when
                                                          searching the
                                                          docs for this<br>
                                                          feature. Thank
                                                          you very much
                                                          for pointing
                                                          that out!<br>
                                                          </blockquote>
                                                          </div>
                                                          </div>
                                                          for sake of
                                                          public
                                                          knowledge,
                                                          just to add on
                                                          time specific
                                                          features:
                                                          there is also
                                                          $timef(format)
                                                          which returns
                                                          current time
                                                          attributes
                                                          based on
                                                          strftime
                                                          specifiers --
                                                          its
                                                          documentation
                                                          was missing, I
                                                          just added it.
                                                          Also, there is
                                                          a
                                                          transformation
                                                          {s.ftime,format)
                                                          which can take
                                                          any integer
                                                          variable
                                                          holding
                                                          timestamp and
                                                          return value
                                                          based on
                                                          strftime
                                                          format.
                                                          <div>
                                                          <div><br>
                                                          <br>
                                                          Cheers,<br>
                                                          Daniel<br>
                                                          <br>
                                                          -- <br>
                                                          Daniel-Constantin

                                                          Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
                                                          <a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a>
                                                          -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a><br>
                                                          <br>
                                                          <br>
_______________________________________________<br>
                                                          SIP Express
                                                          Router (SER)
                                                          and Kamailio
                                                          (OpenSER) -
                                                          sr-users
                                                          mailing list<br>
                                                          <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
                                                          <a 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>
                                                          </div>
                                                          </div>
                                                          </blockquote>
                                                        </div>
                                                        <br>
                                                      </div>
                                                    </blockquote>
                                                    <br>
                                                    <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
                                                  </div>
                                                </blockquote>
                                              </blockquote>
                                              <br>
                                              <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
                                            </div>
                                          </div>
                                        </div>
                                      </blockquote>
                                    </div>
                                    <br>
                                  </div>
                                </blockquote>
                                <br>
                                <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
                              </div>
                            </div>
                          </div>
                        </blockquote>
                      </div>
                      <br>
                    </div>
                  </blockquote>
                  <br>
                  <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
  </div></div></div>

</blockquote></div><br></div>