Em 18 de junho de 2010 09:07, Rodrigo Vian
<[email protected]>escreveu:
> Porque usar ODBC para se conectar ao Postgresql???
>
> O asterisk tem suporte nativo à ele...
>
> - cdr_pgsql.conf
> - res_pgsql.conf
>
>
Mas nao achei a cnfiguração para a tabela voicemessage no arquivo
voicemail.conf.
Onde configuro-a??
Veja, configurei tudo usando PostgeSQL nativo e está dando outro erro:
cdr_pgsql.conf
[global]
hostname=127.0.0.1
port=5432
dbname=asterisk
password=asterisk
user=asterisk
table=cdr
res_pgsql.conf
[general]
dbhost=127.0.0.1
dbport=5432
dbname=asterisk
dbpass=asterisk
dbuser=asterisk
Veja o Log:
-- Executing [...@interno:1] VoiceMail("SIP/253-00000001", "2...@default") in
new stack
[Jun 18 09:26:38] WARNING[31235]: app_voicemail.c:2504 retrieve_file: Failed
to obtain database object for 'asterisk'!
-- <SIP/253-00000001> Playing 'vm-intro' (language 'pt_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
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2552 last_message_index:
Failed to obtain database object for 'asterisk'!
-- <SIP/253-00000001> Playing 'beep' (language 'pt_BR')
-- Recording the message
-- x=0, open writing:
/var/spool/asterisk/voicemail/default/250/tmp/mpkGf2 format: wav49,
0xf812568
-- User hung up
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2598 message_exists:
Failed to obtain database object for 'asterisk'!
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2628 delete_file: Failed
to obtain database object for 'asterisk'!
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2799 store_file: Failed to
obtain database object for 'asterisk'!
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:2504 retrieve_file: Failed
to obtain database object for 'asterisk'!
== Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt':
Found
== Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt':
Found
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:3882 messagecount: Failed
to obtain database object for 'asterisk'!
[Jun 18 09:26:45] WARNING[31235]: app_voicemail.c:3882 messagecount: Failed
to obtain database object for 'asterisk'!
== Spawn extension (interno, 1, 1) exited non-zero on 'SIP/253-00000001'
[Jun 18 09:26:45] WARNING[27285]: app_voicemail.c:3838 inboxcount: Failed to
obtain database object for 'asterisk'!
--
Moisés P. Sena <[email protected]>
(Desenvolvedor WEB)
Oriontec Automação Comercial
http://www.oriontec.com.br
_______________________________________________
KHOMP: qualidade em placas de E1, GSM, FXS e FXO para Asterisk.
- Hardware com alta disponibilidade de recursos e qualidade KHOMP
- Suporte técnico local qualificado e gratuito
Conheça a linha completa de produtos KHOMP em www.khomp.com.br
_______________________________________________
Participe do I Encontro VoIPCenter, 08 a 10 de junho Rio de Janeiro.
Área de exposição, palestras e cursos de VoIP, Asterisk e Convergência de Redes.
http://www.encontrovoipcenter.com.br
______________________________________________
Lista de discussões AsteriskBrasil.org
[email protected]
http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil
