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