WORKS!

Thank you.

On Tue, Aug 14, 2012 at 1:22 PM, Daniel-Constantin Mierla <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,

    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@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@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@gmail.com> wrote:
Hello,

checked the sources and it seems that Juha reverted this feature with the commit:

http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=959ab319903b9625ead7292cc9638a20146e1cca

I guess it was accidentally, I will ask on devels list.

Cheers,
Daniel



On 8/14/12 7:34 PM, Brandon Armstead wrote:
Let me also add that I am using 3.2 but I see the commit was quite some time ago so I have a feeling it wouldn't work in 3.3 either.  Thanks!

Sent from my iPhone

On Aug 14, 2012, at 10:27 AM, Daniel-Constantin Mierla <miconda@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@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@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


-- 
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


-- 
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