Re: [SR-Users] Suggestions for time utils

2012-08-16 Thread Daniel-Constantin Mierla
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

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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. Sincerely, Brandon Armstead On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla wrote: > Hello, > > the $timef(..

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
WORKS! Thank you. On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla 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/w

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Daniel-Constantin Mierla
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

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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]: faile

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Daniel-Constantin Mierla
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

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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,

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Daniel-Constantin Mierla
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 tes

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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 < mico...@gmail.com> wrote: > Hell

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Daniel-Constantin Mierla
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

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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 wrote: > Hello, > > this functionality should be already there. Doesn't wor

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
Daniel, It ONLY works with the $time avp Sent from my iPhone On Aug 14, 2012, at 10:27 AM, Daniel-Constantin Mierla 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

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Daniel-Constantin Mierla
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("

Re: [SR-Users] Suggestions for time utils

2012-08-14 Thread Brandon Armstead
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 t

Re: [SR-Users] Suggestions for time utils

2011-12-19 Thread Daniel-Constantin Mierla
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 a

Re: [SR-Users] Suggestions for time utils

2011-12-19 Thread Andreas Granig
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(), ii

Re: [SR-Users] Suggestions for time utils

2011-12-19 Thread Daniel-Constantin Mierla
Hello, On 12/19/11 1:58 PM, Andreas Granig wrote: Hi, I'd like to implement a couple of helper functions for time handling, e.g. checking day of week, day of month etc. from within the kamailio config file. What would you prefer, a new module ("timeutils" maybe?) or adding it to cfgutils (there

[SR-Users] Suggestions for time utils

2011-12-19 Thread Andreas Granig
Hi, I'd like to implement a couple of helper functions for time handling, e.g. checking day of week, day of month etc. from within the kamailio config file. What would you prefer, a new module ("timeutils" maybe?) or adding it to cfgutils (there are already time-based functions there like sleep an