<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EstiloDeEmail17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=PT-BR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Opa vai aí….<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>extconfig.conf<o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>sipusers</span></b><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'> => mysql,asterisk,sip_conf #
define o nome da tabela mysql no banco asterisk que equivale ao sip.conf<o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>sippeers</span></b><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'> => mysql,asterisk,sip_conf #
define o nome da tabela mysql no banco asterisk que equivale ao sip.conf<o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>extensions</span></b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>
=> mysql,asterisk,</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#F79646'>routes</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> # define o nome da tabela mysql no banco asterisk que
equivale ao extensions.conf<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>extensions.conf<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>[</span><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:red'>default</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>]<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>switch => Realtime/</span><b><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#00B050'>mycontext</span></b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>@</span><b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#0D0D0D'>extensions</span></b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>campos da tabela <b>sipppers e sipusers</b> (sip_conf) que
influenciam na discagem <o:p></o:p></span></p>
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=150
style='width:112.35pt;border-collapse:collapse;border:none'>
<tr>
<td width=84 valign=top style='width:63.3pt;border:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>name</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=65 valign=top style='width:49.05pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Context</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width=84 valign=top style='width:63.3pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'</span><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#C00000'>operadora</span></b><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>'<o:p></o:p></span></p>
</td>
<td width=65 valign=top style='width:49.05pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'</span><b><span lang=EN-US style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:red'>default</span></b><span
lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>linha da tabela equivalente a extensions.conf (</span><b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#F79646'>routes</span></b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>)<o:p></o:p></span></p>
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
style='border-collapse:collapse;border:none'>
<tr>
<td width=86 valign=top style='width:64.8pt;border:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>context</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>exten</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>priority</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>app</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.15pt;border:solid black 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>appdata</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width=86 valign=top style='width:64.8pt;border:solid black 1.0pt;
border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'</span><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#00B050'>mycontext</span></b><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'>'<o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border-top:none;border-left:none;
border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'_0XX[23456]X.'<o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border-top:none;border-left:none;
border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>10<o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.1pt;border-top:none;border-left:none;
border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'Dial'<o:p></o:p></span></p>
</td>
<td width=75 valign=top style='width:56.15pt;border-top:none;border-left:
none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>'SIP/${EXTEN}@</span><b><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#C00000'>operadora</span></b><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>:5060|90|S(${tempo})'<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Observe as cores que ligam os campos.... este é o vínculo que o
asterisk faz com o que está no banco de dados.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>[]s<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><a name="Alcindo_Schleder"><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'><img width=250 height=150
id="_x0000_i1042" src="cid:image001.jpg@01CA3F14.BF4A16C0"></span></a><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<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:"Tahoma","sans-serif"'>De:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
asteriskbrasil-bounces@listas.asteriskbrasil.org
[mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org] <b>Em nome de </b>Weder
Prado<br>
<b>Enviada em:</b> sábado, 26 de setembro de 2009 23:49<br>
<b>Para:</b> asteriskbrasil<br>
<b>Assunto:</b> [AsteriskBrasil] Funcionalidade no realtime do asterisk<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Olá pessoal,<br>
Gostaria de saber se alguém pode me ajudar, tenho um ramal cadastrado na tabela
iax do banco realtime do asterisk com o contexto "ramal1", então fui
no extensions.conf e criei a rota do ramal1 para enviar para minha tabela
extensions do banco de dados.<br>
<br>
[ramal1]<br>
switch=>Realtime/@<br>
<br>
Isso está funcionando.<br>
Gostaria que cada ramal meu tivesse um contexto diferente (rama1, ramal2,
ramal2 ...) sem ter que fazer esse mapeamento no extensions.conf, se não faço o
comando switch tenho o seguinte erro;<br>
[Sep 26 23:36:32] NOTICE[21766]: chan_iax2.c:8370 socket_process: Rejected
connect attempt from 172.33.33.152, request '01140042484@ramal1' does not exist<br>
<br>
Existe alguma forma de falar no extensions.conf que que se não encontrar a
extensão no arquivo local a mesma seja procurada no extensions do banco de
dados?<br>
<br>
Grato desde já,<br>
Weder <o:p></o:p></p>
</div>
</body>
</html>