<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000"><D IV><FONT
face="Times New Roman">Hi,</FONT></DIV><D IV><FONT face="Times New Roman">In
‘event_route[dialog:end]’I can not get any variable they are all empty but using
<FONT style='face: "Times' New roman?>acc_db_requests() worked for
me.</FONT></FONT></DIV><D IV><FONT face="Times New Roman"><FONT
style='face: "Times' New roman?>Thanks for your help.</FONT></FONT><FONT
face="Times New Roman"></FONT>
<DIV></DIV><D IV><FONT face="Times New Roman"></FONT>
<DIV></DIV><D IV><FONT face="Times New Roman">BEST REGARDS</FONT>
<DIV></DIV><D IV><FONT face="Times New Roman"></FONT>
<DIV></DIV><D IV>
<DIV></DIV><D style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000"
IV>
<DIV></DIV><D
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'
IV><D style="FONT: 10pt Tahoma" IV><D IV>
<DIV></DIV><D style="BACKGROUND: #f5f5f5" IV><D style="font-color: black"
IV><B>From:</B> <A title=miconda@gmail.com
href="mailto:miconda@gmail.com">Daniel-Constantin Mierla</A>
<DIV></DIV><D IV><B>Sent:</B> Monday, August 04, 2014 5:28 PM
<DIV></DIV><D IV><B>To:</B> <A title=sr-users@lists.sip-router.org
href="mailto:sr-users@lists.sip-router.org">Kamailio (SER) - Users Mailing
List</A>
<DIV></DIV><D IV><B>Subject:</B> Re: [SR-Users] missing BYE record on acc table
when usingtimeout_avp
<DIV></DIV>
<DIV></DIV>
<DIV></DIV><D IV>
<DIV></DIV>
<DIV></DIV><D
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'
IV>Hello,<BR><BR>with latest version you can get the cdrs at once via dialog+acc
module.<BR><BR>If you want to use the classic acc, then add either
event_route[dialog:end] or event_route[tm:local-request]. There you can get
actions when the dialog is ended (including the time out), and for the
second you get the BYE sent out. Perhaps SQLOPS with sql_query() or
acc_db_requests() should be used to record the event in db
table.<BR><BR>Cheers,<BR>Daniel<BR><BR><D class=moz-cite-prefix IV>On 04/08/14
15:19, <A class=moz-txt-link-abbreviated
href="mailto:betul.cerit@netgsm.com.tr">betul.cerit@netgsm.com.tr</A> wrote:<BR>
<DIV></DIV>
<BLOCKQUOTE cite=mid:77E158044B904C63AFC5CE848AA59B58@betulpc type="cite"><D
dir=ltr IV><D style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000"
IV><D iv="">Hi to all,</D>
<DIV></DIV><D iv=""></D>
<DIV></DIV><D iv="">I want to limit call duration according to the credit of
the user.To accomplish this I use timeout_avp .When the limit is reached call
ends but no record associated with BYE method is inserted to the acc table and
that makes impossible to bill that call.What can I do to solve this problem or
is there an alternative way to limit call duration?My configuration and logs
are as follows. <D iv=""><D iv="">BEST REGARDS. <D iv=""><D
iv="">#---------------- dialog params ------------- <D iv="">#!ifdef
WITH_DIALOG <D iv="">modparam("dialog", "enable_stats", 1) <D
iv="">modparam("dialog", "hash_size", 8192) <D iv="">modparam("dialog",
"rr_param", "did") <D iv="">modparam("dialog", "dlg_flag",4) <D
iv="">modparam("dialog", "timeout_avp", "$avp(i:10)") <D
iv="">modparam("dialog", "dlg_match_mode", 1) <D iv="">modparam("dialog",
"default_timeout", 3600) <D iv="">modparam("dialog", "detect_spirals", 1) <D
iv="">modparam("dialog", "profiles_with_value", "userid ; opkodu") <D
iv="">modparam("dialog", "dlg_extra_hdrs", "Hint: Hell Yeah\r\n") <D
iv="">modparam("dialog", "send_bye", 1) <D iv="">#endif <D iv=""><D
iv="">--------------------------------------------------------------------------------
<D iv=""><D iv="">route[SW]{ <D
iv="">xlog("L_INFO","Dialog:h_id:$dlg(h_id):h_entry:$dlg(h_entry):timeout:$dlg_ctx(timeout_route):bye:$dlg_ctx(timeout_bye):$avp(i:10)");
<D
iv="">
$dlg_ctx(timeout_bye)=1; <D
iv="">
$avp(i:10)=15; <D
iv="">
$dlg_ctx(timeout_route)=33; <D iv=""><D
iv="">
dlg_manage(); <D
iv="">
set_dlg_profile("userid","$avp(userid)"); <D
iv="">
if(get_profile_size("userid","$avp(s_userid)")){ <D
iv="">
xlog("L_INFO","Userid_Size:$avp(s_userid)"); <D
iv="">
} <D
iv="">xlog("L_INFO","Dialog:h_id:$dlg(h_id):h_entry:$dlg(h_entry):timeout:$dlg_ctx(timeout_route):bye:$dlg_ctx(timeout_bye):$avp(i:10)");
<D iv=""> if(!t_relay()) { <D
iv="">
send_reply("408", "Servis Disi"); <D
iv=""> }else{ <D
iv="">
exit; <D iv=""> } <D
iv=""> return; <D iv="">} <D
iv="">event_route[dialog:start]{ <D
iv="">
xlog("L_ALERT","START:ci:$ci:method:$rm:start"); <D iv="">} <D
iv="">event_route[dialog:end]{ <D
iv=""> xlog("L_ALERT","END"); <D
iv="">
xlog("L_ALERT","END:$fU:$fd:$si:$rU:$rd:$avp(poparty):$avp(networkdatetime):$avp(ptparty):$avp(pprovider):$avp(maliyet_id):$avp(tibtip)");
<D iv="">
xlog("L_ALERT","END:$rm:$rr:$rs:"); <D iv="">} <D
iv="">event_route[dialog:failed]{ <D iv=""><D
iv="">
xlog("L_INFO","FAILED:ci:$ci:method:$rm:end"); <D iv="">} <D iv="">route[33]{
<D iv="">
xlog("L_INFO","route:33:$fU:$fd:$si:$rU:$rd:$avp(poparty):$avp(networkdatetime):$avp(ptparty):$avp(pprovider):$avp(maliyet_id):$avp(tibtip)");
<D iv="">
xlog("L_INFO","route:33:$rm:$rr:$rs:"); <D iv="">} <D iv=""># Handle requests
within SIP dialogs <D iv="">route[WITHINDLG] { <D
iv=""> if (has_totag()) { <D
iv="">
# sequential request withing a dialog should <D
iv="">
# take the path determined by record-routing <D
iv="">
if (loose_route()) { <D
iv="">
route(DLGURI); <D
iv="">
if (is_method("BYE")) { <D
iv="">
setflag(FLT_ACC); # do accounting ... <D
iv="">
setflag(FLT_ACCFAILED); # ... even if the transaction fails <D
iv="">
} <D
iv="">
else if ( is_method("ACK") ) { <D
iv="">
# ACK is forwarded statelessy <D
iv="">
route(NATMANAGE); <D
iv="">
} <D
iv="">
else if ( is_method("NOTIFY") ) { <D
iv="">
# Add Record-Route for in-dialog NOTIFY as per RFC 6665. <D
iv="">
record_route(); <D
iv="">
} <D
iv="">
route(RELAY); <D
iv="">
} else { <D
iv="">
if (is_method("SUBSCRIBE") && uri == myself) { <D
iv="">
# in-dialog subscribe requests <D
iv="">
route(PRESENCE); <D
iv="">
exit; <D
iv="">
} <D
iv="">
if ( is_method("ACK") ) { <D
iv="">
if ( t_check_trans() ) { <D
iv="">
# no loose-route, but stateful ACK; <D
iv="">
# must be an ACK after a 487 <D
iv="">
# or e.g. 404 from upstream server <D
iv="">
route(RELAY); <D
iv="">
exit; <D
iv="">
} else { <D
iv="">
# ACK without matching transaction ... ignore and discard <D
iv="">
exit; <D
iv="">
} <D
iv="">
} <D iv="">
sl_send_reply("404","Not here"); <D
iv="">
} <D
iv="">
exit; <D iv=""> } <D iv="">} <D
iv=""><D iv=""><D
iv="">--------------------------------------------------------------------------------
<D iv="">Aug 1 16:51:52 kamailio /usr/local/sbin/kamailio[6111]: ALERT:
<script>: USERID:456123 <D iv="">Aug 1 16:51:52 kamailio
/usr/local/sbin/kamailio[6111]: ALERT: <script>:
arayan:XXXX:aranan:XXXXX <D iv="">Aug 1 16:51:52 kamailio
/usr/local/sbin/kamailio[6111]: INFO: carrierroute [cr_func.c:710]:
cr_do_route(): uri XXXX was rewritten to <A class=moz-txt-link-freetext
href="sip:YYYYYYYYYYYYYYY@XXXXXXX5:5060">sip:YYYYYYYYYYYYYYY@XXXXXXX5:5060</A>,
carrier 3, domain 1 <D iv="">Aug 1 16:51:52 kamailio
/usr/local/sbin/kamailio[6111]: INFO: <script>: vardesc: 40 <D
iv="">Aug 1 16:51:52 kamailio /usr/local/sbin/kamailio[6111]: INFO:
<script>:
Dialog:h_id:<null>:h_entry:<null>:timeout:0:bye:0:<null> <D
iv="">Aug 1 16:51:52 kamailio /usr/local/sbin/kamailio[6111]: INFO:
<script>: Userid_Size:1 <D iv="">Aug 1 16:51:52 kamailio
/usr/local/sbin/kamailio[6111]: INFO: <script>:
Dialog:h_id:3953:h_entry:3170:timeout:14:bye:1:15 <D iv="">Aug 1
16:51:55 kamailio /usr/local/sbin/kamailio[6114]: ALERT: <script>:
START:ci:2c5695c1644fa2b135f57ea72c590cc7@XXXXXXX:5060:method:INVITE:start <D
iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ERROR:
<core> [parser/parse_from.c:113]: parse_from_uri(): failed to parse From
uri <D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]:
ERROR: pv [pv_core.c:397]: pv_get_xto_attr(): cannot parse From URI <D
iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ERROR:
<core> [parser/parse_from.c:113]: parse_from_uri(): failed to parse From
uri <D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]:
ERROR: pv [pv_core.c:397]: pv_get_xto_attr(): cannot parse From URI <D
iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: INFO:
<script>:
route:33:<null>:<null>:1.0.0.127:you:kamailio.org:<null>:<null>:<null>:<null>:<null>:<null>
<D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: INFO:
<script>: route:33:OPTIONS:<null>:<null>: <D iv="">Aug
1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ALERT: <script>: END
<D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ERROR:
<core> [parser/parse_from.c:113]: parse_from_uri(): failed to parse From
uri <D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]:
ERROR: pv [pv_core.c:397]: pv_get_xto_attr(): cannot parse From URI <D
iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ERROR:
<core> [parser/parse_from.c:113]: parse_from_uri(): failed to parse From
uri <D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]:
ERROR: pv [pv_core.c:397]: pv_get_xto_attr(): cannot parse From URI <D
iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ALERT:
<script>:
END:<null>:<null>:1.0.0.127:you:kamailio.org:<null>:<null>:<null>:<null>:<null>:<null>
<D iv="">Aug 1 16:52:11 kamailio /usr/local/sbin/kamailio[6145]: ALERT:
<script>: END:OPTIONS:<null>:<null>: <D iv="">Aug 1
16:52:11 kamailio /usr/local/sbin/kamailio[6121]: WARNING: dialog
[dlg_req_within.c:212]: bye_reply_cb(): inconsitent dlg timer data on dlg
0x7feb2115d918 [3170:3953] with clid '<A class=moz-txt-link-abbreviated
href="mailto:2c5695c1644fa2b135f57ea72c590cc7@95.0.154.92:5060">2c5695c1644fa2b135f57ea72c590cc7@95.0.154.92:5060</A>'
and tags 'as3c7c5aa4' 'as0b640624' <D iv="">Aug 1 16:52:11 kamailio
/usr/local/sbin/kamailio[6121]: ERROR: acc [acc_cdr.c:574]: cdr_on_end():
invalid values#012! <D iv=""><D iv=""><D iv=""><D iv=""><D iv=""><D
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000" iv=""><IMG
title=BTLCRT
style="BORDER-TOP: 0px; BORDER-RIGHT: 0px; BACKGROUND-IMAGE: none; BORDER-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; BORDER-LEFT: 0px; DISPLAY: inline; PADDING-RIGHT: 0px"
border=0 alt=BTLCRT
src="wlmailhtml:{03549B3C-9746-486C-A96E-6AFED16D0768}mid://00000912/!cid:part1.01020807.01050304@gmail.com"
width=302 height=117> <BR><F class=mimeAttachmentHeader IELDSET>
<FIELDSET></FIELDSET> <BR><PRE wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</A>
<A class=moz-txt-link-freetext href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</A>
</PRE></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></D></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></PRE>
<P>
<HR>
_______________________________________________<BR>SIP Express Router (SER) and
Kamailio (OpenSER) - sr-users mailing
list<BR>sr-users@lists.sip-router.org<BR>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<BR>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></BODY></HTML>