<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
<div class="moz-cite-prefix">On 11/13/12 7:32 AM, Uri Shacked wrote:<br>
</div>
<blockquote
cite="mid:CAMMbDhTumswK5FN2ybBZSjZu87oufo0mdTYPXuyMbeoTqLUUDg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><font face="Times New Roman" size="3">
</font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt">what i need
at the end is that the
408 record on the acc table will have the same to_tag as
the 18X reply that
came before.</span></p>
<font face="Times New Roman" size="3">
</font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt">i understand
i can not change the
acc module to insert the 408 with this to_tag,</span></p>
</div>
</div>
</blockquote>
yes, it cannot be changed, the 183 is sent by another device than
kamailio, which sends the 408, so the tags are different.<br>
<br>
<blockquote
cite="mid:CAMMbDhTumswK5FN2ybBZSjZu87oufo0mdTYPXuyMbeoTqLUUDg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt"> so i am
trying to update the DB
record with the 18X to_tag i have. the problem is, when do
i do the sqlops? if
i do it on the failure_route i do the update before the
acc inserted the
record....</span></p>
<font face="Times New Roman" size="3">
</font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt"> </span></p>
<font face="Times New Roman" size="3">
</font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt">is this
sounds ok to do? is there a
more elegant way?</span></p>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span style="font-family:"Times New
Roman","serif";font-size:12pt">if this is
the right way when sould i do the sql update if not in
failure route?</span></p>
</div>
</div>
</blockquote>
<br>
You can do insert with sqlops instead of acc - in failure route
reset the flag for acc and just use sql_query() where you set all
the values for the columns in the acc table.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<blockquote
cite="mid:CAMMbDhTumswK5FN2ybBZSjZu87oufo0mdTYPXuyMbeoTqLUUDg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<font face="Times New Roman" size="3">
</font><br>
<br>
</div>
<div class="gmail_quote">On Tue, Nov 13, 2012 at 2:24 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com"
target="_blank">miconda@gmail.com</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px
0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid"
class="gmail_quote">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hello,
<div>
<div class="h5"><br>
<br>
On 11/13/12 6:25 AM, Uri Shacked wrote:<br>
</div>
</div>
</div>
<div>
<div class="h5">
<blockquote type="cite">
<div dir="ltr"><font face="Times New Roman" size="3">
</font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>Hi,</span></p>
<font face="Times New Roman" size="3"> </font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>When i set a timer to
"request time out" kamilio generates a 408
with now to_tag.</span></p>
<font face="Times New Roman" size="3"> </font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>I saved the to_tag from
the 183 and try to update the acc table with
the to_tag (i need that for my CDR to work)</span></p>
<font face="Times New Roman" size="3"> </font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>My question is
(understanding there is no option to set the
to_tag on the 408) is:</span></p>
<font face="Times New Roman" size="3"> </font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>How to i get the right
timing to update using sqlops? i must update
after the acc inserted the row to the acc
table....</span></p>
<font face="Times New Roman" size="3"> </font>
<p style="margin:0cm 0cm 0pt;line-height:normal"
class="MsoNormal"><span>Any ideas?</span></p>
</div>
</blockquote>
</div>
</div>
rtimer module can be used to execute periodically some
route blocks, perhaps you want to look for reply code 408
and change the fields you want.<br>
<br>
However, it may work to use a failure route and reset
to-tag variable to $null if the status code is 408 -- this
is a matter of what mechanism you use to write the
accounting record.<br>
<br>
Cheers,<br>
Daniel<span class="HOEnZb"><font color="#888888"><br>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></pre>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</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>