[SR-Users] Suggestions for time utils

Daniel-Constantin Mierla miconda at gmail.com
Thu Aug 16 18:14:46 CEST 2012


Hello,

On 8/14/12 11:14 PM, Brandon Armstead wrote:
> Daniel,
>
>    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'ing action.

it is evaluated at runtime.

Cheers,
Daniel

>
> Sincerely,
> Brandon Armstead
>
> On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla 
> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>
>     Hello,
>
>     the $timef(...) is evaluated, but you don't have time specifiers
>     there, only static letters. You have to use % in front of the
>     letters, as I guess from the example:
>
>     http://www.kamailio.org/wiki/cookbooks/3.2.x/pseudovariables
>
>     Try acc_$timef(%Y%m%d).
>
>     Cheers,
>     Daniel
>
>
>
>     On 8/14/12 10:17 PM, Brandon Armstead wrote:
>>     Daniel,
>>
>>         My apologies - forgot to make clean.  However still no cigar.
>>
>>     Aug 14 20:16:40 /usr/local/sbin/kamailio[12410]: ERROR: db_mysql
>>     [km_dbase.c:122]: driver error on query: Table 'kamailio.acc_Ymd'
>>     doesn't exist
>>     Aug 14 20:16:40 /usr/local/sbin/kamailio[12410]: ERROR: acc
>>     [acc.c:405]: failed to insert into database
>>
>>     Sincerely,
>>     Brandon Armstead
>>
>>     On Tue, Aug 14, 2012 at 1:11 PM, Daniel-Constantin Mierla
>>     <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>>
>>         Hello,
>>
>>         are you sure you re-installed and the right acc.so is used?
>>
>>         The support is for generic PV, if it works with one it should
>>         work with any. Which one does work for you?
>>
>>         Can you give exact table name as printed in the SQL query?
>>         Does it have the parenthesis and the format string?
>>
>>         Cheers,
>>         Daniel
>>
>>
>>         On 8/14/12 9:55 PM, Brandon Armstead wrote:
>>>         Daniel,
>>>
>>>            Patch applies fine - it still does not seem to take when
>>>         using $timef, i..e
>>>
>>>         modparam("acc", "db_table_acc", "acc_$timef(Ymd)")
>>>
>>>         It looks as if the $timef is not being interpreted and is
>>>         simply writing to acc'ing i.e. INSERT INTO acc_$timef
>>>
>>>         Thanks!
>>>
>>>         Sincerely,
>>>         Brandon Armstead
>>>         On Tue, Aug 14, 2012 at 12:48 PM, Daniel-Constantin Mierla
>>>         <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>>>
>>>             Hello,
>>>
>>>             I reapplied the patch (cherry-picked from the initial
>>>             one) to the master branch.
>>>
>>>             Can you test that and see if it works fine?
>>>
>>>             You can cherry-picked to your branch, try:
>>>
>>>             git pull origin
>>>             git cherry-pick -x 95ee0a3ee75556a25f3a9286837a57decf6c3c91
>>>
>>>             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.
>>>
>>>             Cheers,
>>>             Daniel
>>>
>>>
>>>             On 8/14/12 9:21 PM, Brandon Armstead wrote:
>>>>             Daniel,
>>>>
>>>>                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.
>>>>
>>>>             Sincerely,
>>>>             Brandon Armstead
>>>>
>>>>             On Tue, Aug 14, 2012 at 12:04 PM, Daniel-Constantin
>>>>             Mierla <miconda at gmail.com <mailto:miconda at gmail.com>>
>>>>             wrote:
>>>>
>>>>                 Hello,
>>>>
>>>>                 checked the sources and it seems that Juha reverted
>>>>                 this feature with the commit:
>>>>
>>>>                 http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca
>>>>
>>>>                 I guess it was accidentally, I will ask on devels list.
>>>>
>>>>                 Cheers,
>>>>                 Daniel
>>>>
>>>>
>>>>
>>>>                 On 8/14/12 7:34 PM, Brandon Armstead wrote:
>>>>>                 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't work in 3.3 either.  Thanks!
>>>>>
>>>>>                 Sent from my iPhone
>>>>>
>>>>>                 On Aug 14, 2012, at 10:27 AM, Daniel-Constantin
>>>>>                 Mierla <miconda at gmail.com
>>>>>                 <mailto:miconda at gmail.com>> wrote:
>>>>>
>>>>>>                 Hello,
>>>>>>
>>>>>>                 this functionality should be already there.
>>>>>>                 Doesn't work for you?
>>>>>>
>>>>>>                 Cheers,
>>>>>>                 Daniel
>>>>>>
>>>>>>                 On 8/14/12 7:16 PM, Brandon Armstead wrote:
>>>>>>>                 Sorry to wake up an old thread.
>>>>>>>
>>>>>>>                 However - I am looking to export this $timef
>>>>>>>                 function to the param initialization for
>>>>>>>                 accounting, i.e. db_table_acc
>>>>>>>
>>>>>>>                 modparam("db_table_acc", "acc_$ftime(Ymd)");
>>>>>>>
>>>>>>>                 I'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).
>>>>>>>
>>>>>>>                 Look forward to any help / insight you may be
>>>>>>>                 able to provide.
>>>>>>>
>>>>>>>                 Thanks as always!
>>>>>>>
>>>>>>>                 Sincerely,
>>>>>>>                 Brandon Armstead
>>>>>>>
>>>>>>>                 On Mon, Dec 19, 2011 at 11:55 AM,
>>>>>>>                 Daniel-Constantin Mierla <miconda at gmail.com
>>>>>>>                 <mailto:miconda at gmail.com>> wrote:
>>>>>>>
>>>>>>>                     Hello,
>>>>>>>
>>>>>>>
>>>>>>>                     On 12/19/11 7:50 PM, Andreas Granig wrote:
>>>>>>>
>>>>>>>                         Hi Daniel,
>>>>>>>
>>>>>>>                         On 12/19/2011 07:29 PM,
>>>>>>>                         Daniel-Constantin Mierla wrote:
>>>>>>>
>>>>>>>                             I don't know what are all the
>>>>>>>                             functions you think of, but for the
>>>>>>>                             example provided above, config file
>>>>>>>                             does it easy right now. There is a
>>>>>>>                             pseudo-variable that gives
>>>>>>>                             broken-time attribute that can be
>>>>>>>                             used with
>>>>>>>                             avp_check(), iirc, should be:
>>>>>>>
>>>>>>>                             avp_db_load(...);
>>>>>>>                             if(avp_check("$time(wday)",
>>>>>>>                             "eq/$avp(s:cf_weekday)/g")) { do CF }
>>>>>>>
>>>>>>>                             Of course there is the option of
>>>>>>>                             doing while loop, but maybe gets to
>>>>>>>                             large for desired config file.
>>>>>>>
>>>>>>>                         This is pretty much what I had in mind
>>>>>>>                         with my new functions/module, but
>>>>>>>                         I've completely overlooked that PV when
>>>>>>>                         searching the docs for this
>>>>>>>                         feature. Thank you very much for
>>>>>>>                         pointing that out!
>>>>>>>
>>>>>>>                     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.
>>>>>>>
>>>>>>>
>>>>>>>                     Cheers,
>>>>>>>                     Daniel
>>>>>>>
>>>>>>>                     -- 
>>>>>>>                     Daniel-Constantin Mierla --
>>>>>>>                     http://www.asipto.com
>>>>>>>                     http://linkedin.com/in/miconda --
>>>>>>>                     http://twitter.com/miconda
>>>>>>>
>>>>>>>
>>>>>>>                     _______________________________________________
>>>>>>>                     SIP Express Router (SER) and Kamailio
>>>>>>>                     (OpenSER) - sr-users mailing list
>>>>>>>                     sr-users at lists.sip-router.org
>>>>>>>                     <mailto:sr-users at lists.sip-router.org>
>>>>>>>                     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>                 -- 
>>>>>>                 Daniel-Constantin Mierla -http://www.asipto.com
>>>>>>                 http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>>>>>>                 Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 -http://asipto.com/u/katu
>>>>>>                 Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 -http://asipto.com/u/kpw
>>>>
>>>>                 -- 
>>>>                 Daniel-Constantin Mierla -http://www.asipto.com
>>>>                 http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>>>>                 Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 -http://asipto.com/u/katu
>>>>                 Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 -http://asipto.com/u/kpw
>>>>
>>>>
>>>
>>>             -- 
>>>             Daniel-Constantin Mierla -http://www.asipto.com
>>>             http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>>>             Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 -http://asipto.com/u/katu
>>>             Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 -http://asipto.com/u/kpw
>>>
>>>
>>
>>         -- 
>>         Daniel-Constantin Mierla -http://www.asipto.com
>>         http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>>         Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 -http://asipto.com/u/katu
>>         Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 -http://asipto.com/u/kpw
>>
>>
>
>     -- 
>     Daniel-Constantin Mierla -http://www.asipto.com
>     http://twitter.com/#!/miconda  <http://twitter.com/#%21/miconda>  -http://www.linkedin.com/in/miconda
>     Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 -http://asipto.com/u/katu
>     Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 -http://asipto.com/u/kpw
>
>

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120816/6e2ec90b/attachment-0001.htm>


More information about the sr-users mailing list