[SR-Users] Suggestions for time utils
Daniel-Constantin Mierla
miconda at gmail.com
Tue Aug 14 22:22:05 CEST 2012
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://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/20120814/e6089cfb/attachment-0001.htm>
More information about the sr-users
mailing list