Tenta concertar essa conexão do * com SQL.<br><br><div><span class="gmail_quote">Em 13/02/08, <b class="gmail_sendername">Ricardo Aziz Barbosa</b> <<a href="mailto:ricardo@mastermaq.com.br">ricardo@mastermaq.com.br</a>> escreveu:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="PT-BR">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Pessoal tenho dois servidores Asterisk com quatro placas
TDM2400P cada o que somam 96 ramais FXS. Acontece que de vez em quando o
asterisk reinicia do nada, nos logs não consegui encontrar nada de anormal,
simplesmente mostram as chamadas sendo processadas e com intervalo de
aproximadamente 40 segundos aparece o primeiro registro de inicialização do
asterisk.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Vejam os registros no log:</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] VERBOSE[11714]
logger.c: -- Called 68</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] WARNING[11714] chan_iax2.c: No private
structure for packet?</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] WARNING[11714] channel.c: Prodding channel
'IAX2/astk4_1-45' failed</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] VERBOSE[11714] logger.c:
-- Zap/68-1 is ringing</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] VERBOSE[11714]
logger.c: -- Hungup 'Zap/68-1'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] VERBOSE[11714] logger.c: ==
Spawn extension (from-astk, 7370, 1) exited non-zero on 'IAX2/astk4_1-45'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] VERBOSE[11714]
logger.c: -- Hungup 'IAX2/astk4_1-45'</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:03:37] WARNING[11714] channel.c: Channel
'IAX2/astk4_1-45' may not have been hung up properly</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">---------------------- Até aqui estava tudo normal e
abaixo já mostra a inicialização do asterisk, este log é
sequencial------------------</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] cdr.c: CDR simple logging
enabled.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] loader.c: 156 modules will
be loaded.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] WARNING[11735] res_config_pgsql.c: Postgresql
RealTime: No database socket found, using '/tmp/pgsql.sock' as default.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] ERROR[11735] res_config_pgsql.c:
Postgresql RealTime: Failed to connect database server asterisk on <a href="http://127.0.0.1" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">127.0.0.1</a>.
Check debug for more info.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] WARNING[11735] res_config_pgsql.c:
Postgresql RealTime: Couldn't establish connection. Check debug.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] config.c: Registered Config
Engine pgsql</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] VERBOSE[11735] logger.c: Loading
[Sub]Agent Module</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] res_odbc.c: Adding ENV var:
INFORMIXSERVER=my_special_database</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] res_odbc.c: Adding ENV var:
INFORMIXDIR=/opt/informix</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] NOTICE[11735] res_odbc.c: Connecting
asterisk</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">[Feb 12 10:04:57] WARNING[11735] res_odbc.c: res_odbc: Error
SQLConnect=-1 errno=0 [u</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Já pesquisei bastante e não encontrei nada sobre este tipo
de falha.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Se alguém já tiver passado por algo do tipo de puder ajudar
já deixo antecipadamente meus agradecimentos.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Atenciosamente,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Ricardo
Aziz Barbosa</span></font><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"></span></font></p>
</div>
</div>
<br>_______________________________________________<br>Compre uma camiseta da AsteriskBrasil.org!<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.voipmania.com.br" target="_blank">http://www.voipmania.com.br</a><br>
== <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://VoIPMania.com.br" target="_blank">VoIPMania.com.br</a> ==<br><br>_______________________________________________<br>LIsta de discussões AsteriskBrasil.org<br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:AsteriskBrasil@listas.asteriskbrasil.org">AsteriskBrasil@listas.asteriskbrasil.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil" target="_blank">http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Raniere dos Santos Machado<br>Engenheiro Eletricista<br>Intechne - Tecnologia da Informação<br>Tel : 55 98 32468182<br>Cel: 55 98 81468221