<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=utf-8"><meta name=Generator content="Microsoft Word 15 (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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EstiloDeEmail18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></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="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><a name="_MailEndCompose"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'>Boa Tarde, <o:p></o:p></span></a></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'>extconfig.conf é o caminho das pedras. <o:p></o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'>Abaixo é a estrutura do banco de dados que no meu caso é mysql. E como você coloca as informações para que o asterisk utilize as configurações do banco ao invés dos arquivos .conf<o:p></o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'>No extconfig fica assim </span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:9.0pt;font-family:"Courier New"'>sip.conf => mysql,(nome da conexão mysql) ,config ( Nome da tabela onde estão as configurações )</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p></o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><img width=881 height=57 style='width:9.175in;height:.5916in' id="Imagem_x0020_2" src="cid:image002.jpg@01D23AC1.21F6FEA0"></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p></o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'>Abracos, <o:p></o:p></span></span></p><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><div><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse'><tr><td width=142 rowspan=6 valign=top style='width:106.35pt;border:none;border-right:solid #ED7D31 1.5pt;padding:0cm 5.4pt 0cm 5.4pt'><p class=MsoNormal align=center style='text-align:center'><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></span></p><p class=MsoNormal align=center style='text-align:center'><span style='mso-bookmark:_MailEndCompose'></span><a href="http://www.virtual4b.net/"><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Helvetica",sans-serif;color:windowtext;text-decoration:none'><img border=0 width=112 height=47 style='width:1.1666in;height:.4916in' id="Imagem_x0020_22" src="cid:image006.png@01D23AC1.21F6FEA0" alt="cid:image008.png@01D1BFE3.EAEA4C80"></span></span><span style='mso-bookmark:_MailEndCompose'></span></a><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><b><span style='font-size:14.0pt;font-family:"Helvetica",sans-serif;color:#2E74B5'>Silvio Duclos</span></b></span><span style='mso-bookmark:_MailEndCompose'><b><span style='font-size:14.0pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></b></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr><tr><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.0pt;font-family:"Helvetica",sans-serif;color:#ED7D31'>Virtual Solutions for Business</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.0pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr><tr style='height:3.3pt'><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt;height:3.3pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:Wingdings;color:#7D7D7D'>(</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:7.0pt;font-family:"Calibri",sans-serif;color:#7D7D7D'> </span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:#7D7D7D'>Office +55 (11) 4349-1956</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr><tr style='height:6.3pt'><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt;height:6.3pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:Wingdings;color:#7D7D7D'>)</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:7.0pt;font-family:"Calibri",sans-serif;color:#7D7D7D'> </span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:#7D7D7D'>Mobile +55 (11) 95474-6663</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'> </span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr><tr><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:Wingdings;color:gray'>*</span></span><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'> </span></span><span style='mso-bookmark:_MailEndCompose'></span><a href="mailto:silvio@virtual4b.com"><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'>silvio@virtual4b.com</span></span><span style='mso-bookmark:_MailEndCompose'></span></a><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'> </span></span><span style='mso-bookmark:_MailEndCompose'></span><a href="http://www.virtual4b.net/"><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'>www.virtual4b.net</span></span><span style='mso-bookmark:_MailEndCompose'></span></a><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr><tr style='height:6.6pt'><span style='mso-bookmark:_MailEndCompose'></span><td width=236 valign=top style='width:176.9pt;padding:0cm 5.4pt 0cm 5.4pt;height:6.6pt'><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'>Skype: </span></span><span style='mso-bookmark:_MailEndCompose'></span><a href="http://www.virtual4b.net/" target="_blank"><span style='mso-bookmark:_MailEndCompose'><span style='font-size:8.5pt;font-family:"Helvetica",sans-serif;color:gray'>silvio.duclos</span></span><span style='mso-bookmark:_MailEndCompose'></span></a><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p></o:p></span></span></p></td><span style='mso-bookmark:_MailEndCompose'></span></tr></table><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'><o:p> </o:p></span></span></p></div><p class=MsoNormal><span style='mso-bookmark:_MailEndCompose'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></span></p><span style='mso-bookmark:_MailEndCompose'></span><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>De:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> asteriskbrasil-bounces@listas.asteriskbrasil.org [mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org] <b>Em nome de </b>Rogério Felício<br><b>Enviada em:</b> quarta-feira, 9 de novembro de 2016 17:02<br><b>Para:</b> asteriskbrasil@listas.asteriskbrasil.org<br><b>Assunto:</b> [AsteriskBrasil] Asterisk - configuracao de ramais e troncos via banco de dados<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div id="yui_3_16_0_ym19_1_1478715931294_40962"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'>Saudações a todos!<o:p></o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_40962"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_40962"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'>Instalei o "Asterisk certified/13.1-cert8" e estou precisando configurá-lo para funcionar com a estrutrua dinamica onde eu possa fazer o cadastro de ramais, diretamente vai banco de dados ao inves de fazer a inserção nos arquivos sip.conf<o:p></o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_40962"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_40962"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'>Alguem pode me ajudar com o "caminho das pedras" para isto funcionar?<o:p></o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_42545"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'> <o:p></o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_42545"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'><o:p> </o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_42545"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'>att.<o:p></o:p></span></p></div><div id="yui_3_16_0_ym19_1_1478715931294_42545"><p class=MsoNormal style='background:white'><span style='font-size:13.5pt;font-family:"Helvetica",sans-serif;color:black'>Rogério.<o:p></o:p></span></p></div></div></div></body></html>