<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Gustavo A Gonzalez escribió:
<blockquote cite="mid:20090423174952.9931E14A162@mail.despegar.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Hello! I’ve an issue whit
CDR using asterisk 1.4.23.1.
I’ve configured mysql to store cdr information, but, while I put into
cdr_mysql.conf
the field ‘userfield=1’ and doing a query I found that this field is
empty in the cdr table. On the other hand I can’t find records in the
cdr
table that show me calls generated through AMI using Originate Action,
that’s
calls are not stored in the CDR, but I don’t know why if I calls from
pstn are stored whitout problems. Parameters that I send are:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Channe:SIP/$CHANNEL<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">CallerID:listener<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Application:ChanSpy'<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><a class="moz-txt-link-freetext" href="Data:SIP/AgentPhone">Data:SIP/AgentPhone</a>.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Variable:CDR(userfield)=listened<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Async=yes<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
Well, there's two things to look around here. First, the variable en
the AMI Originate action lets you set channel variables on to the
channel of the originated call, not onto the spied (and already
established) call. Second, if you can't see the originated calls on the
CDR, try setting the option "unanswered=yes" on cdr.conf and issue a
"cdr reload" command on the CLI. You can check with "cdr status" that
this option is set, that tells asterisk to maintain a CDR for <b>every</b>
call attempt that goes through it. Then you can check if the originated
calls show up on your CDR database.<br>
<br>
Cheers,<br>
<br>
<blockquote cite="mid:20090423174952.9931E14A162@mail.despegar.net"
type="cite">
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Thanks for any idea about
that<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><b><font color="navy"
face="Times New Roman" size="3"><span
style="font-size: 12pt; color: navy; font-weight: bold;">Gustavo A.
González</span></font></b><font color="#1f497d" face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana; color: rgb(31, 73, 125);"><br>
Dto. de Infraestructura<br>
Despegar.com, Inc.</span></font><font color="navy" face="Verdana"
size="1"><span
style="font-size: 7.5pt; font-family: Verdana; color: navy;"><br>
</span></font><font color="black" face="Arial" size="1"><span
style="font-size: 7.5pt; font-family: Arial; color: black;" lang="ES"><a
moz-do-not-send="true" href="mailto:ggonzalez@despegar.com"><span
lang="EN-US">ggonzalez@despe</span>gar.com</a></span></font><font
color="#1f497d" face="Verdana" size="1"><span
style="font-size: 7.5pt; font-family: Verdana; color: rgb(31, 73, 125);"
lang="ES"> </span></font><font color="navy"><span style="color: navy;"
lang="ES"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<U1:P></U1:P></div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
-- Bandwidth and Colocation Provided by <a class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
PBX: (+57 1)6500800 ext. 1201
Fax: (+57 1)6500816
Móvil: (+57)3138873587
</pre>
</body>
</html>