WORKS!<div><br></div><div>Thank you.<br><br><div class="gmail_quote">On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla <span dir="ltr"><<a 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 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 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 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 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 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 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 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a>
-- <a 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 href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a 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 href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a 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 href="http://asipto.com/u/katu" target="_blank">http://asipto.com/u/katu</a>
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - <a href="http://asipto.com/u/kpw" target="_blank">http://asipto.com/u/kpw</a></pre>
</div></div></div>
</blockquote></div><br></div>