19 Dec
2011
19 Dec
'11
1:58 p.m.
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 and usleep)?
The idea is to implement time based call-forwards, and an approach could
be to provision various time-related values in usr_preferences table,
and then check it in the config. For example, when doing call-forwards
from Monday to Friday only, I could put this into usr_preferences:
attribute: cf_weekday
value: [1, 2, 3, 4, 5] (each entry is a separate row in usr_preferences)
And in kamailio config, I'd call this:
avp_db_load(...);
if(is_weekday("$avp(s:cf_weekday)")) { do CF }
So is_weekday would iterate over the entries in the avp list and return
true if the weekday at the time of routing matches an entry in the list.
A module config param could control whether to use gmtime or localtime
for matching.
Does this make sense? Suggestions for other approaches? I'd rather
prefer to do it directly in config instead of using some external
interpreter like lua, python etc.
Andreas
19 Dec
19 Dec
7:29 p.m.
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 are already time-based functions there like
sleep and usleep)?
The idea is to implement time based call-forwards, and an approach could
be to provision various time-related values in usr_preferences table,
and then check it in the config. For example, when doing call-forwards
from Monday to Friday only, I could put this into usr_preferences:
attribute: cf_weekday
value: [1, 2, 3, 4, 5] (each entry is a separate row in usr_preferences)
And in kamailio config, I'd call this:
avp_db_load(...);
if(is_weekday("$avp(s:cf_weekday)")) { do CF }
So is_weekday would iterate over the entries in the avp list and return
true if the weekday at the time of routing matches an entry in the list.
A module config param could control whether to use gmtime or localtime
for matching.
Does this make sense? Suggestions for other approaches? I'd rather
prefer to do it directly in config instead of using some external
interpreter like lua, python etc.
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.
For me does not matter if it is new module or not, it is up to developer
convenience. The only thing here I would comment a bit about, is the
plan to apply on avp lists always? The maybe its better in avpops (if
you want to do it in an old module), also use avp somehow in the name,
e.g., is_avp_weekday().
Cheers,
Daniel
--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda
7:50 p.m.
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!
Andreas
8:55 p.m.
Hello,
On 12/19/11 7:50 PM, Andreas Granig wrote:
Hi Daniel,
On 12/19/2011 07:29 PM, Daniel-Constantin Mierla wrote:
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
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! 
14 Aug
14 Aug
7:16 p.m.
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> 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:
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<http:/…
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!
7:27 p.m.
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 <mailto:miconda@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(a)lists.sip-router.org <mailto:sr-users@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://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
7:30 p.m.
Daniel,
It ONLY works with the $time avp
Sent from my iPhone
On Aug 14, 2012, at 10:27 AM, Daniel-Constantin Mierla <miconda(a)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(a)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(a)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://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
7:34 p.m.
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> 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(a)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(a)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://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
9:04 p.m.
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 <mailto:miconda@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(a)gmail.com <mailto:miconda@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(a)lists.sip-router.org <mailto:sr-users@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://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
9:21 p.m.
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> 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=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>
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(a)gmail.com> wrote:
Hello,
On 12/19/11 7:50 PM, Andreas Granig wrote:
--
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
Hi Daniel,
On 12/19/2011 07:29 PM, Daniel-Constantin Mierla wrote:
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
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!
9:48 p.m.
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 <mailto:miconda@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=95…
I guess it was accidentally, I will ask on devels list.
Cheers,
Daniel
On 8/14/12 7:34 PM, Brandon Armstead wrote:
--
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
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 <mailto:miconda@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(a)gmail.com <mailto:miconda@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(a)lists.sip-router.org
>> <mailto:sr-users@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
9:55 p.m.
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> 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(a)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=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>
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(a)gmail.com> wrote:
--
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
Hello,
On 12/19/11 7:50 PM, Andreas Granig wrote:
--
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
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
10:11 p.m.
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 <mailto:miconda@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-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
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 <mailto:miconda@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=95…
I guess it was accidentally, I will ask on devels list.
Cheers,
Daniel
On 8/14/12 7:34 PM, Brandon Armstead wrote:
--
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
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 <mailto:miconda@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(a)gmail.com <mailto:miconda@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(a)lists.sip-router.org
>> <mailto:sr-users@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
10:17 p.m.
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
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(a)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(a)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=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 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(a)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(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
>
>
10:22 p.m.
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 <mailto:miconda@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-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
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 <mailto:miconda@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-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,
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 <mailto:miconda@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=95…
I guess it was accidentally, I will ask on devels list.
Cheers,
Daniel
On 8/14/12 7:34 PM, Brandon Armstead wrote:
--
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
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 <mailto:miconda@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(a)gmail.com <mailto:miconda@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(a)lists.sip-router.org
>> <mailto:sr-users@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
10:23 p.m.
WORKS!
Thank you.
On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla <miconda(a)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(a)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(a)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(a)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=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 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(a)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(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
>
>
11:14 p.m.
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 <miconda(a)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(a)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(a)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(a)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=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 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(a)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(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
>
>
16 Aug
16 Aug
6:14 p.m.
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(a)gmail.com <mailto:miconda@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-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
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 <mailto:miconda@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-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,
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 <mailto:miconda@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-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,
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 <mailto:miconda@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=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
> <mailto:miconda@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(a)gmail.com
>>> <mailto:miconda@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(a)lists.sip-router.org
>>> <mailto:sr-users@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
4277
days inactive
4518
days old
17 comments
3 participants
participants (3)
-
Andreas Granig -
Brandon Armstead -
Daniel-Constantin Mierla