Re: [SR-Users] Suggestions for time utils

WORKS! Thank you. On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla &lt;miconda(a)gmail.com > 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(a)gmail.com> >> 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(a)gmail.com>> >>> 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(a)gmail.com>>> >>>> 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=95… >>>> >>>> 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(a)gmail.com>>>> >>>> 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(a)gmail.com>>>> >>>>> 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(a)lists.sip-router.org >>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>> >>>> >>>> -- >>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://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 >>>> >>>> >>>> -- >>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://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 >>>> >>>> >>> >>> -- >>> Daniel-Constantin Mierla - http://www.asipto.comhttp://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 >>> >>> >> >> -- >> Daniel-Constantin Mierla - http://www.asipto.comhttp://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 >> >> > > -- > Daniel-Constantin Mierla - http://www.asipto.comhttp://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 > >