Pessoal, quem puder me auxiliar, agradeço.<br>Na bilhetagem de meu pabx, não está gravando o valor do campo "clid" na tabela "cdr".<br>Não estou percebendo o que estou fazendo de errado.<br>Abaixo segue o resultado e meus arquivos de configuração.<br>
<br><span style="font-family: courier new,monospace;"></span>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 3.1 (Linux)">
<style>
<!--
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small }
-->
</style>
<table frame="VOID" height="136" rules="NONE" width="987" border="0" cellspacing="0" cols="16">
<colgroup><col width="136"><col width="32"><col width="30"><col width="27"><col width="60"><col width="84"><col width="77"><col width="65"><col width="59"><col width="59"><col width="50"><col width="97"><col width="59"><col width="88"><col width="104"><col width="86"></colgroup>
<tbody>
<tr>
<td height="17" width="136" align="LEFT">calldate</td>
<td width="32" align="LEFT">clid</td>
<td width="30" align="LEFT">src</td>
<td width="27" align="LEFT">dst</td>
<td width="60" align="LEFT">dcontext</td>
<td width="84" align="LEFT">channel</td>
<td width="77" align="LEFT">dstchannel</td>
<td width="65" align="LEFT">lastapp</td>
<td width="59" align="LEFT">lastdata</td>
<td width="59" align="LEFT">duration</td>
<td width="50" align="LEFT">billsec</td>
<td width="97" align="LEFT">disposition</td>
<td width="59" align="LEFT">amaflags</td>
<td width="88" align="LEFT">accountcode</td>
<td width="104" align="LEFT">uniqueid</td>
<td width="86" align="LEFT">userfield</td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 11:57 AM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">10</td>
<td align="LEFT">6</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266674259</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 11:58 AM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">9</td>
<td align="LEFT">5</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266674300.1</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 12:04 PM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">10</td>
<td align="LEFT">6</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266674694.2</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 12:19 PM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">4</td>
<td align="LEFT">0</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266675579</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 12:26 PM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">11</td>
<td align="LEFT">7</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266676007.1</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 12:28 PM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">11</td>
<td align="LEFT">7</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266676090.2</td>
<td align="LEFT"> <br></td>
</tr>
<tr>
<td height="17" align="LEFT">02/20/10 12:29 PM</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> <br></td>
<td align="LEFT"> s</td>
<td align="LEFT"> default</td>
<td align="LEFT"> DAHDI/1-1</td>
<td align="LEFT"> <br></td>
<td align="LEFT"> Hangup</td>
<td align="LEFT"> <br></td>
<td align="LEFT">11</td>
<td align="LEFT">7</td>
<td align="LEFT"> ANSWERED</td>
<td align="LEFT">3</td>
<td align="LEFT"> <br></td>
<td align="LEFT">1266676158.3</td>
<td align="LEFT"> <br></td>
</tr>
</tbody>
</table>
<br><span style="font-family: courier new,monospace;"><br>arquivo /etc/asterisk/extensions.conf</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><font size="1"><b><span style="font-family: courier new,monospace;">[general]</span></b><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">static=yes</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">writeprotect=no</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">autofallthrough=no</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">clearglobalvars=no</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">priorityjumping=yes</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><b><span style="font-family: courier new,monospace;">[default]</span></b><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">exten => s,1,Answer ; Atende a ligacao...</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">exten => s,2,Playback(introprotv) ; Mensagem</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">exten => s,3,Hangup() ; termina</span><br style="font-family: courier new,monospace;"></font><br><br><span style="font-family: courier new,monospace;">/etc/asterisk/cdr_mysql.conf</span><br>
<br><font size="1"><b style="font-family: courier new,monospace;">[global]</b><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">hostname=127.0.0.1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">dbname=protv</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">table=cdr</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">password=pt.rj</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">user=root</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;port=3306</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;sock=/tmp/mysql.sock</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;</span><br style="font-family: courier new,monospace;"><b style="font-family: courier new,monospace;">[columns]</b><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;static "<value>" => <column></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias <cdrvar> => <column></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">alias start => calldate</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">alias callerid => clid</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias src => src</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias dst => dst</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias dcontext => dcontext</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias channel => channel</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias dstchannel => dstchannel</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias lastapp => lastapp</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias lastdata => lastdata</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias duration => duration</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias billsec => billsec</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias disposition => disposition</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias amaflags => amaflags</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias accountcode => accountcode</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">;alias userfield => userfield</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">;alias uniqueid => uniqueid</span></font><br><br><font style="font-family: courier new,monospace;" size="1"><font size="2">estrutura da tabela cdr</font><br></font><pre style="font-family: courier new,monospace;">
<font size="1">CREATE TABLE `cdr` (<br> `calldate` datetime NOT NULL default '0000-00-00 00:00:00',<br> `clid` varchar(80) NOT NULL default '',<br> `src` varchar(80) NOT NULL default '',<br> `dst` varchar(80) NOT NULL default '',<br>
`dcontext` varchar(80) NOT NULL default '',<br> `channel` varchar(80) NOT NULL default '',<br> `dstchannel` varchar(80) NOT NULL default '',<br> `lastapp` varchar(80) NOT NULL default '',<br>
`lastdata` varchar(80) NOT NULL default '',<br> `duration` int(11) NOT NULL default '0',<br> `billsec` int(11) NOT NULL default '0',<br> `disposition` varchar(45) NOT NULL default '',<br>
`amaflags` int(11) NOT NULL default '0',<br> `accountcode` varchar(20) NOT NULL default '',<br> `uniqueid` varchar(32) NOT NULL default '',<br> `userfield` varchar(255) NOT NULL default '',<br>
KEY `calldate` (`calldate`),<br> KEY `dst` (`dst`),<br> KEY `accountcode` (`accountcode`)<br>) ENGINE=MyISAM DEFAULT CHARSET=latin1;<br></font></pre><br>