<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
<div class="moz-cite-prefix">On 8/14/12 11:14 PM, Brandon Armstead
wrote:<br>
</div>
<blockquote
cite="mid:CACr1DbDYVaVkUys41aDo+1mK+vDxP9TQJ6LRH1eVzfQaGAy6Fg@mail.gmail.com"
type="cite">Daniel,
<div><br>
</div>
<div> 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.</div>
</blockquote>
<br>
it is evaluated at runtime.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:CACr1DbDYVaVkUys41aDo+1mK+vDxP9TQJ6LRH1eVzfQaGAy6Fg@mail.gmail.com"
type="cite">
<div><br>
</div>
<div>
Sincerely,</div>
<div>Brandon Armstead<br>
<br>
<div class="gmail_quote">On Tue, Aug 14, 2012 at 1:22 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com"
target="_blank">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
<br>
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:<br>
<br>
<a moz-do-not-send="true"
href="http://www.kamailio.org/wiki/cookbooks/3.2.x/pseudovariables"
target="_blank">http://www.kamailio.org/wiki/cookbooks/3.2.x/pseudovariables</a><br>
<br>
Try acc_$timef(%Y%m%d).<br>
<br>
Cheers,<br>
Daniel
<div>
<div class="h5"><br>
<br>
<br>
<div>On 8/14/12 10:17 PM, Brandon Armstead wrote:<br>
</div>
<blockquote type="cite">Daniel,
<div><br>
</div>
<div> My apologies - forgot to make clean.
However still no cigar.</div>
<div><br>
</div>
<div>
<div>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</div>
<div>Aug 14 20:16:40
/usr/local/sbin/kamailio[12410]: ERROR: acc
[acc.c:405]: failed to insert into database</div>
<div><br>
</div>
<div>Sincerely,</div>
<div>Brandon Armstead</div>
<br>
<div class="gmail_quote">On Tue, Aug 14, 2012 at
1:11 PM, Daniel-Constantin Mierla <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:miconda@gmail.com"
target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
<br>
are you sure you re-installed and the right
acc.so is used?<br>
<br>
The support is for generic PV, if it works
with one it should work with any. Which one
does work for you?<br>
<br>
Can you give exact table name as printed in
the SQL query? Does it have the parenthesis
and the format string?<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 8/14/12 9:55 PM, Brandon
Armstead wrote:<br>
</div>
<blockquote type="cite">Daniel,
<div><br>
</div>
<div> Patch applies fine - it still
does not seem to take when using
$timef, i..e</div>
<div><br>
</div>
<div>modparam("acc", "db_table_acc",
"acc_$timef(Ymd)")</div>
<div> <br>
</div>
<div>It looks as if the $timef is not
being interpreted and is simply
writing to acc'ing i.e. INSERT INTO
acc_$timef</div>
<div><br>
</div>
<div>Thanks!</div>
<div><br>
</div>
<div>Sincerely,</div>
<div>Brandon Armstead<br>
<div class="gmail_quote">On Tue, Aug
14, 2012 at 12:48 PM,
Daniel-Constantin Mierla <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:miconda@gmail.com"
target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF"
text="#000000"> Hello,<br>
<br>
I reapplied the patch
(cherry-picked from the
initial one) to the master
branch.<br>
<br>
Can you test that and see if
it works fine?<br>
<br>
You can cherry-picked to your
branch, try:<br>
<br>
git pull origin<br>
git cherry-pick -x
95ee0a3ee75556a25f3a9286837a57decf6c3c91<br>
<br>
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.<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 8/14/12 9:21 PM,
Brandon Armstead wrote:<br>
</div>
<blockquote type="cite">Daniel,
<div><br>
</div>
<div> 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.</div>
<div><br>
</div>
<div>Sincerely,</div>
<div>Brandon Armstead<br>
<br>
<div
class="gmail_quote">On
Tue, Aug 14, 2012 at
12:04 PM,
Daniel-Constantin
Mierla <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0 0
0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
bgcolor="#FFFFFF"
text="#000000">
Hello,<br>
<br>
checked the
sources and it
seems that Juha
reverted this
feature with the
commit:<br>
<br>
<a
moz-do-not-send="true"
href="http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca"
target="_blank">http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca</a><br>
<br>
I guess it was
accidentally, I
will ask on
devels list.<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<br>
<div>On
8/14/12 7:34
PM, Brandon
Armstead
wrote:<br>
</div>
<blockquote
type="cite">
<div>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!</div>
<div><br>
Sent from my
iPhone</div>
<div><br>
On Aug 14,
2012, at 10:27
AM,
Daniel-Constantin
Mierla <<a
moz-do-not-send="true" href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>
wrote:<br>
<br>
</div>
<blockquote
type="cite">
<div> Hello,<br>
<br>
this
functionality
should be
already there.
Doesn't work
for you?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div>On
8/14/12 7:16
PM, Brandon
Armstead
wrote:<br>
</div>
<blockquote
type="cite">Sorry
to wake up an
old thread.
<div><br>
</div>
<div>However -
I am looking
to export this
$timef
function to
the param
initialization
for
accounting,
i.e.
db_table_acc</div>
<div><br>
</div>
<div>modparam("db_table_acc",
"acc_$ftime(Ymd)");</div>
<div><br>
</div>
<div>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).</div>
<div><br>
</div>
<div>Look
forward to any
help / insight
you may be
able to
provide.</div>
<div><br>
</div>
<div>Thanks as
always!</div>
<div><br>
</div>
<div>Sincerely,</div>
<div>Brandon
Armstead<br>
<br>
<div
class="gmail_quote">On
Mon, Dec 19,
2011 at 11:55
AM,
Daniel-Constantin
Mierla <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">Hello,
<div>
<div><br>
<br>
On 12/19/11
7:50 PM,
Andreas Granig
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
Hi Daniel,<br>
<br>
On 12/19/2011
07:29 PM,
Daniel-Constantin
Mierla wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
I don't know
what are all
the functions
you think of,
but for the<br>
example
provided
above, config
file does it
easy right
now. There is
a<br>
pseudo-variable
that gives
broken-time
attribute that
can be used
with<br>
avp_check(),
iirc, should
be:<br>
<br>
avp_db_load(...);<br>
if(avp_check("$time(wday)",
"eq/$avp(s:cf_weekday)/g"))
{ do CF }<br>
<br>
Of course
there is the
option of
doing while
loop, but
maybe gets to<br>
large for
desired config
file.<br>
</blockquote>
This is pretty
much what I
had in mind
with my new
functions/module,
but<br>
I've
completely
overlooked
that PV when
searching the
docs for this<br>
feature. Thank
you very much
for pointing
that out!<br>
</blockquote>
</div>
</div>
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.
<div>
<div><br>
<br>
Cheers,<br>
Daniel<br>
<br>
-- <br>
Daniel-Constantin
Mierla -- <a
moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<a
moz-do-not-send="true"
href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a>
-- <a
moz-do-not-send="true"
href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a><br>
<br>
<br>
_______________________________________________<br>
SIP Express
Router (SER)
and Kamailio
(OpenSER) -
sr-users
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a
moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div>
</blockquote>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a moz-do-not-send="true" href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - <a class="moz-txt-link-freetext" href="http://asipto.com/u/katu">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a class="moz-txt-link-freetext" href="http://asipto.com/u/kpw">http://asipto.com/u/kpw</a></pre>
</body>
</html>