<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
The dialog event route should have the $dlg(...) variable available
that you should use as input in an sql_query():<br>
<br>
-
<a class="moz-txt-link-freetext" href="http://www.kamailio.org/wiki/cookbooks/4.1.x/pseudovariables#dialog_module_pseudo-variables">http://www.kamailio.org/wiki/cookbooks/4.1.x/pseudovariables#dialog_module_pseudo-variables</a><br>
<br>
At timeout there is no request there. It is the event that triggers
tm to build and send a bye, to be available in tm:local-request<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 05/08/14 09:00,
<a class="moz-txt-link-abbreviated" href="mailto:betul.cerit@netgsm.com.tr">betul.cerit@netgsm.com.tr</a> wrote:<br>
</div>
<blockquote cite="mid:01557C64F2D8436A906233E6C5B1DFFF@betulpc"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div dir="ltr">
<div style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR:
#000000"><d iv=""><d style="FONT-SIZE: small; TEXT-DECORATION:
none; FONT-FAMILY: "Calibri"; FONT-WEIGHT:
normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY:
inline" iv=""></d></d></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 dir="ltr" iv=""><d
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR:
#000000" iv=""><font face="Times New Roman">Hi,</font>
<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"
roman?="" new="">acc_db_requests() worked for me.</font></font>
<d iv=""><font face="Times New Roman"><font style="face:
"Times" roman?="" new="">Thanks for your help.</font></font>
<d iv="">
<d iv=""><d iv="">
<d iv=""><font face="Times New Roman">BEST REGARDS</font>
<d iv="">
<d iv=""><d iv="">
<d iv=""><d iv="">
<d style="FONT-SIZE: 12pt;
FONT-FAMILY: 'Calibri'; COLOR:
#000000" iv=""><d iv="">
<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=""><d iv="">
<d iv=""><d
style="BACKGROUND:
#f5f5f5" iv=""><d
style="font-color:
black" iv="">
<d iv="">
<d iv=""><b>From:</b>
<a
moz-do-not-send="true"
title="miconda@gmail.com" href="mailto:miconda@gmail.com">Daniel-Constantin
Mierla</a> <d
iv="">
<d iv=""><b>Sent:</b>
Monday, August
04, 2014 5:28
PM <d iv="">
<d iv=""><b>To:</b>
<a
moz-do-not-send="true"
title="sr-users@lists.sip-router.org"
href="mailto:sr-users@lists.sip-router.org">Kamailio
(SER) - Users
Mailing List</a>
<d iv="">
<d iv=""><b>Subject:</b>
Re: [SR-Users]
missing BYE
record on acc
table when
usingtimeout_avp
<d iv="">
<d iv="">
<d iv="">
<d iv=""><d
iv="">
<d iv="">
<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
moz-do-not-send="true"
class="moz-txt-link-abbreviated" href="mailto:betul.cerit@netgsm.com.tr">betul.cerit@netgsm.com.tr</a>
wrote:<br>
<d iv="">
<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> <d
iv=""> <d
iv=""></d><d
iv=""> <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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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"
alt="BTLCRT"
src="wlmailhtml:%7B03549B3C-9746-486C-A96E-6AFED16D0768%7Dmid://00000912/%21cid:part1.01020807.01050304@gmail.com"
border="0"
height="117"
width="302"> <br>
<f
class="mimeAttachmentHeader"
ieldset=""><f
ieldset="">
<fieldset></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" 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>
</f></f></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></d></d></d></d></blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
<p>
</p>
<hr>
_______________________________________________<br>
SIP Express
Router (SER)
and Kamailio
(OpenSER) -
sr-users
mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<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><br>
<d iv="">
<d iv="">
<d iv="">
</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>
</body>
</html>