[AsteriskBrasil] Erro ao executar query em PostgreSQL odbc voicemessage

[Moisés Paes Sena]

Em 18 de junho de 2010 09:07, Rodrigo Vian
<listas em porttaltecnologia.com.br>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 [1 em interno:1] VoiceMail("SIP/253-00000001", "250 em 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 <moises em oriontec.com.br>
(Desenvolvedor WEB)
Oriontec Automação Comercial
http://www.oriontec.com.br
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20100618/e68ff26e/attachment.htm