<br><br><div class="gmail_quote">Em 18 de junho de 2010 09:07, Rodrigo Vian <span dir="ltr"><<a href="mailto:listas@porttaltecnologia.com.br">listas@porttaltecnologia.com.br</a>></span> escreveu:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Porque usar ODBC para se conectar ao Postgresql???<br>
<br>
O asterisk tem suporte nativo à ele...<br>
<br>
- cdr_pgsql.conf <br>
- res_pgsql.conf<br>
<br clear="all"></div></blockquote><div><br>Mas nao achei a cnfiguração para a tabela voicemessage no arquivo voicemail.conf.<br>Onde configuro-a??<br><br>Veja, configurei tudo usando PostgeSQL nativo e está dando outro erro:<br>
<br>cdr_pgsql.conf<br> [global]<br> hostname=127.0.0.1<br> port=5432<br> dbname=asterisk<br> password=asterisk<br> user=asterisk<br> table=cdr<br><br>res_pgsql.conf<br> [general]<br> dbhost=127.0.0.1<br>
dbport=5432<br> dbname=asterisk<br> dbpass=asterisk<br> dbuser=asterisk<br><br>Veja o Log:<br><br> -- Executing [1@interno:1] VoiceMail("SIP/253-00000001", "250@default") in new stack<br>[Jun 18 09:26:38] WARNING[31235]: app_voicemail.c:2504 retrieve_file: Failed to obtain database object for 'asterisk'!<br>
-- <SIP/253-00000001> Playing 'vm-intro' (language 'pt_BR')<br>[Jun 18 09:26:40] NOTICE[26572]: chan_sip.c:16251 handle_request_subscribe: Received SIP subscribe for peer without mailbox: odbc_test_user<br>
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2552 last_message_index: Failed to obtain database object for 'asterisk'!<br> -- <SIP/253-00000001> Playing 'beep' (language 'pt_BR')<br> -- Recording the message<br>
-- x=0, open writing: /var/spool/asterisk/voicemail/default/250/tmp/mpkGf2 format: wav49, 0xf812568<br> -- User hung up<br>[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2598 message_exists: Failed to obtain database object for 'asterisk'!<br>
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2628 delete_file: Failed to obtain database object for 'asterisk'!<br>[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2799 store_file: Failed to obtain database object for 'asterisk'!<br>
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2504 retrieve_file: Failed to obtain database object for 'asterisk'!<br> == Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt': Found<br>
== Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt': Found<br>[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:3882 messagecount: Failed to obtain database object for 'asterisk'!<br>
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:3882 messagecount: Failed to obtain database object for 'asterisk'!<br> == Spawn extension (interno, 1, 1) exited non-zero on 'SIP/253-00000001'<br>[Jun 18 09:26:45] WARNING[27285]: app_voicemail.c:3838 inboxcount: Failed to obtain database object for 'asterisk'!<br>
</div></div><br>-- <br>Moisés P. Sena <<a href="mailto:moises@oriontec.com.br">moises@oriontec.com.br</a>><br>(Desenvolvedor WEB)<br>Oriontec Automação Comercial<br><a href="http://www.oriontec.com.br">http://www.oriontec.com.br</a><br>