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 class="h5"><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/#!/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>