Yes I know radius accounting will work but I have to do it without radius. So I'm doing it manually using avp_db_query. <br><br><div><span class="gmail_quote">On 3/26/07, <b class="gmail_sendername">raviprakash sunkara
</b> <<a href="mailto:sunkara.raviprakash.feb14@gmail.com">sunkara.raviprakash.feb14@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi <br><br>U can use the Radius for account <br><br>with Acc of radius some avp functions are there <br><br>u means <br>like this <br>onroute_reply[]<br>{<br>if( status==200) <br>{<br>i f ( method == "invite" )
<br>accouting start of avp module<br>if methosd == bye) <br>acctoung stop of avp module<br>}<br>}<br><br><br><div><div><span class="e" id="q_1118d79fd6f88a51_1"><span class="gmail_quote">On 3/26/07, <b class="gmail_sendername">
Asterisk Expert</b> <<a href="mailto:asterisk.expert@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
asterisk.expert@gmail.com</a>> wrote:</span></span></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><span class="e" id="q_1118d79fd6f88a51_3">
Hello,<br clear="all">I'm trying to implement custom CDR using OpenSER. What I do is, insert a record in cdr table on invite request. I get the id of the inserted row using LAST_INSERT_ID() function of mysql in avp_db_query and store in avp variable rowid. I set connect time in reply route when I receive 200 OK for Invite request. When I get 200 OK for BYE request, I update the cdr record and store connect time, disconnect time, duration, etc. But at this place(reply route) I get the null rowid so as connect time. According to tm module's onreply_avp_mode parameter, I should be able to see the values set from request route in reply route if I set that parameter to 1 but it has no effect. I can not use either avp variables or script variables as transaction variables to record custom cdr. Can anyone guide me implementing this scenario or tell me what I've done wrong?
<br><span>-- <br>Regards<br>Ruchir Brahmbhatt<br>Ecosmob Technologies<br>
</span><br></span></div>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Users@openser.org
</a><br><a href="http://openser.org/cgi-bin/mailman/listinfo/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://openser.org/cgi-bin/mailman/listinfo/users</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Thanks and Regards<br>Ravi Prakash Sunkara <br><a href="mailto:ravi.sunkara@hyperion-tech.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
ravi.sunkara@hyperion-tech.com
</a> <br>M:+91 9985077535<br><a href="http://www.hyperion-tech.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.hyperion-tech.com</a><br>Client and Parent company :- <a href="http://www.august-networks.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
www.august-networks.com</a>
</blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Asterisk Expert