<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    O que voc&ecirc; que inserir no CDR?<br>
    <br>
    Em 06-01-2012 22:04, fernando escreveu:
    <blockquote
cite="mid:CAJQabPwC4YZUHF0S5AgzKO3hx08A2WtjHpBWiRr8gjCHk4eePg@mail.gmail.com"
      type="cite">Boa Noite Julio,&nbsp;
      <div><br>
      </div>
      <div>Grato Pela Dica, com esta aplica&ccedil;&atilde;o sera que consigo inserir
        registro na tabela CDR (MYSQL)?<br>
        <br>
        <div class="gmail_quote">Em 6 de janeiro de 2012 21:51, Julio
          Henrique Oliveira <span dir="ltr">&lt;<a
              moz-do-not-send="true" href="mailto:julioh1203@gmail.com">julioh1203@gmail.com</a>&gt;</span>
          escreveu:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">Ol&aacute;,
            <div><br>
            </div>
            <div>Eu fiz assim:</div>
            <div><br>
            </div>
            <div>
              <div>[teste]</div>
              <div>exten =&gt; 999,1,Playback(agent-user)</div>
              <div>exten =&gt; 999,n,MYSQL(Connect connid localhost
                usuario_bd senha nome_bd)</div>
              <div>exten =&gt; 999,n,Read(Login,,4,,,)</div>
              <div>exten =&gt; 999,n,MYSQL(Query resultid ${connid}
                SELECT codigo_usuario FROM Usuarios WHERE
                codigo_usuario=${Login})</div>
              <div>exten =&gt; 999,n,MYSQL(Fetch fetchid ${resultid} x1)</div>
              <div>exten =&gt; 999,n,Set(CDR(userfield)=${x1})</div>
              <div>exten =&gt; 999,n,MYSQL(Clear ${resultid})</div>
              <div>exten =&gt; 999,n,MYSQL(Disconnect ${connid})</div>
              <div>exten =&gt; 999,n,Hangup()</div>
              <div><br>
              </div>
              <div>H&aacute; uma boa documenta&ccedil;&atilde;o em&nbsp;<a moz-do-not-send="true"
href="http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL"
                  target="_blank">http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL</a></div>
              <div><br>
              </div>
              <div><br>
              </div>
              <div>Abra&ccedil;os,</div>
              <div><br>
              </div>
              <div>J&uacute;lio Henrique</div>
              <br>
              <div class="gmail_quote">Em 5 de janeiro de 2012 19:02,
                Fernando F&amp;F Network <span dir="ltr">&lt;<a
                    moz-do-not-send="true"
                    href="mailto:fernando@feftelecom.com.br"
                    target="_blank">fernando@feftelecom.com.br</a>&gt;</span>
                escreveu:<br>
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div bgcolor="white" link="blue" vlink="purple"
                    lang="PT-BR">
                    <div>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">Boa
                          Noite Julio,</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">Eu
                          fiz assim</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">Extensions.conf</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">[celular]</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">exten
                          =&gt; _[7-9]XXXXXXX,1,Answer</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">exten
                          =&gt;
                          _[7-9]XXXXXXX,n,Authenticate(/etc/asterisk/senhas)</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">exten
                          =&gt;
                          _[7-9]XXXXXXX,n,Dial(IAX2/021/${EXTEN},120,Tt,wW)</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">exten
                          =&gt; _[7-9]XXXXXXX,n,Hangup</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">e
                          criei em /etc/asterisk arquivo chamado senhas,
                          Dentro Senhas, Inclui varias senhas, um em
                          cada linha e funcionou,</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">o
                          que n&atilde;o consegui ate agora fazer aparecer na
                          minha tabela SQL o Registro da chamada feita
                          atrav&eacute;s daquela senha, </span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">estou
                          pesquisando, se tiver alguma sugest&atilde;o, grato..</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">Desculpa
                          Monica Cruzou Os Emails aqui,</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <p class="MsoNormal"><span style="color:#1f497d">&nbsp;</span></p>
                      <div>
                        <div style="border:none;border-top:solid #b5c4df
                          1.0pt;padding:3.0pt 0cm 0cm 0cm">
                          <p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">De:</span></b><span
style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">
                              <a moz-do-not-send="true"
                                href="mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org"
                                target="_blank">asteriskbrasil-bounces@listas.asteriskbrasil.org</a>
                              [mailto:<a moz-do-not-send="true"
                                href="mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org"
                                target="_blank">asteriskbrasil-bounces@listas.asteriskbrasil.org</a>]
                              <b>Em nome de </b>J&uacute;lio Henrique<br>
                              <b>Enviada em:</b> quinta-feira, 5 de
                              janeiro de 2012 18:06<br>
                              <b>Para:</b> <a moz-do-not-send="true"
                                href="mailto:asteriskbrasil@listas.asteriskbrasil.org"
                                target="_blank">asteriskbrasil@listas.asteriskbrasil.org</a><br>
                              <b>Cc:</b> &lt;<a moz-do-not-send="true"
                                href="mailto:asteriskbrasil@listas.asteriskbrasil.org"
                                target="_blank">asteriskbrasil@listas.asteriskbrasil.org</a>&gt;<br>
                              <b>Assunto:</b> Re: [AsteriskBrasil] (sem
                              assunto)</span></p>
                        </div>
                      </div>
                      <div>
                        <div>
                          <p class="MsoNormal">&nbsp;</p>
                          <div>
                            <p class="MsoNormal">Ol&aacute;,</p>
                          </div>
                          <div>
                            <p class="MsoNormal">
                              &nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">Eu fiz isto utilizando
                              Mysql. Se quiser posso te ajudar.&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">Abra&ccedil;os.&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal">J&uacute;lio.&nbsp;</p>
                          </div>
                          <div>
                            <p class="MsoNormal"><br>
                              Enviado via iPhone</p>
                          </div>
                          <div>
                            <p class="MsoNormal"
                              style="margin-bottom:12.0pt"><br>
                              Em 05/01/2012, &agrave;s 15:38, "Fernando F&amp;F
                              Network" &lt;<a moz-do-not-send="true"
                                href="mailto:fernando@feftelecom.com.br"
                                target="_blank">fernando@feftelecom.com.br</a>&gt;
                              escreveu:</p>
                          </div>
                          <blockquote
                            style="margin-top:5.0pt;margin-bottom:5.0pt">
                            <div>
                              <p class="MsoNormal">Boa Tarde,</p>
                              <p class="MsoNormal">&nbsp;</p>
                              <p class="MsoNormal">Preciso Usar
                                &nbsp;Authenticate em cada Ramal, Deixo
                                explicar Melhor,</p>
                              <p class="MsoNormal">Quando Ramal for
                                fazer liga&ccedil;&atilde;o ele vai discar EX.:
                                XXXX-XXXX para completar devera pedir a
                                senha Cadastrada para cada usu&aacute;rio, tem
                                como fazer, alguma sugest&atilde;o,</p>
                              <p class="MsoNormal">Desde j&aacute; Grato,</p>
                            </div>
                          </blockquote>
                          <blockquote
                            style="margin-top:5.0pt;margin-bottom:5.0pt">
                            <div>
                              <p class="MsoNormal"><span
                                  style="font-size:12.0pt;font-family:&quot;Times
                                  New Roman&quot;,&quot;serif&quot;">_______________________________________________<br>
                                  KHOMP ::: External Series Experience
                                  :::<br>
                                  Um novo conceito para o mercado de
                                  aplica&ccedil;&otilde;es que vai<br>
                                  fazer voc&ecirc; pensar fora da caixa.
                                  Aguarde este lan&ccedil;amento<br>
_______________________________________________<br>
                                  DIGIVOICE: Lider no mercado de placas
                                  para Asterisk<br>
                                  &Uacute;nico fabricante com Centro de
                                  Treinamento especializado.<br>
                                  LAN&Ccedil;AMENTO: Channel Bank TDMoE, at&eacute; 64
                                  canais FXS / FXO. <br>
                                  <a moz-do-not-send="true"
                                    href="http://www.digivoice.com.br"
                                    target="_blank">www.digivoice.com.br</a>
                                  ou <a moz-do-not-send="true"
                                    href="tel:%2811%293016-5200"
                                    value="+551130165200"
                                    target="_blank">(11)3016-5200</a>.<br>
                                  ________<br>
                                  <br>
______________________________________________<br>
                                  Para remover seu email desta lista,
                                  basta enviar um email em branco para <a
                                    moz-do-not-send="true"
                                    href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org"
                                    target="_blank">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a></span></p>
                            </div>
                          </blockquote>
                        </div>
                      </div>
                    </div>
                  </div>
                  <br>
                  _______________________________________________<br>
                  KHOMP ::: External Series Experience :::<br>
                  Um novo conceito para o mercado de aplica&ccedil;&otilde;es que vai<br>
                  fazer voc&ecirc; pensar fora da caixa. Aguarde este
                  lan&ccedil;amento<br>
                  _______________________________________________<br>
                  DIGIVOICE: Lider no mercado de placas para Asterisk<br>
                  &Uacute;nico fabricante com Centro de Treinamento
                  especializado.<br>
                  LAN&Ccedil;AMENTO: Channel Bank TDMoE, at&eacute; 64 canais FXS /
                  FXO.<br>
                  <a moz-do-not-send="true"
                    href="http://www.digivoice.com.br" target="_blank">www.digivoice.com.br</a>
                  ou <a moz-do-not-send="true"
                    href="tel:%2811%293016-5200" value="+551130165200"
                    target="_blank">(11)3016-5200</a>.<br>
                  ________<br>
                  <br>
                  ______________________________________________<br>
                  Para remover seu email desta lista, basta enviar um
                  email em branco para <a moz-do-not-send="true"
                    href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org"
                    target="_blank">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a><br>
                </blockquote>
              </div>
              <br>
            </div>
            <br>
            _______________________________________________<br>
            KHOMP ::: External Series Experience :::<br>
            Um novo conceito para o mercado de aplica&ccedil;&otilde;es que vai<br>
            fazer voc&ecirc; pensar fora da caixa. Aguarde este lan&ccedil;amento<br>
            _______________________________________________<br>
            DIGIVOICE: Lider no mercado de placas para Asterisk<br>
            &Uacute;nico fabricante com Centro de Treinamento especializado.<br>
            LAN&Ccedil;AMENTO: Channel Bank TDMoE, at&eacute; 64 canais FXS / FXO.<br>
            <a moz-do-not-send="true" href="http://www.digivoice.com.br"
              target="_blank">www.digivoice.com.br</a> ou <a
              moz-do-not-send="true" href="tel:%2811%293016-5200"
              value="+551130165200">(11)3016-5200</a>.<br>
            ________<br>
            <br>
            ______________________________________________<br>
            Para remover seu email desta lista, basta enviar um email em
            branco para <a moz-do-not-send="true"
              href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a><br>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        <div>ATT,</div>
        <div>&nbsp;</div>
        <div>Fernando</div>
        <div>Analista Telecomunica&ccedil;&atilde;o e T.I</div>
        <br>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
KHOMP ::: External Series Experience :::
Um novo conceito para o mercado de aplica&ccedil;&otilde;es que vai
fazer voc&ecirc; pensar fora da caixa. Aguarde este lan&ccedil;amento
_______________________________________________
DIGIVOICE: Lider no mercado de placas para Asterisk
&Uacute;nico fabricante com Centro de Treinamento especializado.
LAN&Ccedil;AMENTO: Channel Bank TDMoE, at&eacute; 64 canais FXS / FXO. 
<a class="moz-txt-link-abbreviated" href="http://www.digivoice.com.br">www.digivoice.com.br</a> ou (11)3016-5200.
________

______________________________________________
Para remover seu email desta lista, basta enviar um email em branco para <a class="moz-txt-link-abbreviated" href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a></pre>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Udson F. Assis<br>
      Gerente Adm.<br>
      Maisvoipshop Telecom / Maiseletroshop<br>
      Tel.: 31-3515-0323<br>
      Skype: atendimentomaisvoipshop<br>
      Email e Msn: <a class="moz-txt-link-abbreviated" href="mailto:contato@maisvoipshop.com.br">contato@maisvoipshop.com.br</a><br>
      Site: <a class="moz-txt-link-abbreviated" href="http://www.maisvoipshop.com.br">www.maisvoipshop.com.br</a><br>
      <p>
        -----PLACA MT-TDM400 4FXO R$ 469,90 | GATEWAY FXO 4 CANAIS R$
        899,00------<br>
        -----PLACA MT-TDM800 8FXS R$ 1074,60 | GATEWAY FXS 8 CANAIS R$
        834,99------<br>
        - Maisvoipshop: Placas E1, GSM, FXS e FXO para Asterisk.<br>
        - Hardware Maistel com excelente qualidade e garantia<br>
        - Consultoria, suporte, termina&ccedil;&atilde;o voip. Contrate DID Brasil por
        29,90.<br>
        - Conhe&ccedil;a a linha completa de produtos Maistel
        <a class="moz-txt-link-abbreviated" href="http://www.maisvoipshop.com.br">www.maisvoipshop.com.br</a><br>
___________________________________________________________________________<br>
        <br>
        <iframe
          src="http://sip.brfonevoip.com.br/webcall/maisvoipshop/index.php"
          frameborder="0" height="205" scrolling="no" width="280"
          align="Left"></iframe></p>
    </div>
  </body>
</html>