incapable de sauvegarder les voicemails dans ODBC

[survivant]

j<obtiens plein d'erreur lorsque je veux sauvegarder un voicemail. J'ai pris ODBC dans le menuselect.

si je prennais FILE.. ca fonctionnait sur disque.



[Nov 4 07:25:59] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:25:59] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:25:59] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
Length is 5780
[Nov 4 07:25:59] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:25:59] WARNING[7306]: app_voicemail.c:3566 delete_file: SQL Execute error!
[DELETE FROM voicemessages WHERE dir=? AND msgnum=?]

== Parsing '/var/spool/asterisk/voicemail/default/1001/INBOX/msg0000.txt': == Found
[Nov 4 07:25:59] WARNING[7306]: app_voicemail.c:3660 insert_data_cb: SQL Direct Execute failed!
[Nov 4 07:25:59] WARNING[7306]: res_odbc.c:601 ast_odbc_direct_execute: SQL Exec Direct failed. Attempting a reconnect...
[Nov 4 07:25:59] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:25:59] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:25:59] WARNING[7306]: app_voicemail.c:3660 insert_data_cb: SQL Direct Execute failed!
[Nov 4 07:25:59] WARNING[7306]: res_odbc.c:601 ast_odbc_direct_execute: SQL Exec Direct failed. Attempting a reconnect...
[Nov 4 07:25:59] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: app_voicemail.c:3770 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,calleri d,origtime,duration,mailboxuser,mailboxcontext,fla g) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: app_voicemail.c:3312 retrieve_file: SQL Execute error!
[SELECT * FROM voicemessages WHERE dir=? AND msgnum=?]

[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
/bin/sh: /usr/sbin/sendmail: not found
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: app_voicemail.c:5132 messagecount: SQL Execute error!
[SELECT COUNT(*) FROM voicemessages WHERE dir = '/var/spool/asterisk/voicemail/default/1001/INBOX' OR dir = '/var/spool/asterisk/voicemail/default/1001/Urgent']

[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR: permission denied for relation voicemessages;
Error while executing the query (85)
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 4 07:26:00] WARNING[7306]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1472 odbc_obj_connect: Connecting asterisk
[Nov 4 07:26:00] NOTICE[7306]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Nov 4 07:26:00] WARNING[7306]: app_voicemail.c:5132 messagecount: SQL Execute error!
[SELECT COUNT(*) FROM voicemessages WHERE dir = '/var/spool/asterisk/voicemail/default/1001/INBOX' OR dir = '/var/spool/asterisk/voicemail/default/1001/Urgent']

-- Executing [123@Interne:2] Hangup("SIP/1001-00000000", "") in new stack
== Spawn extension (Interne, 123, 2) exited non-zero on 'SIP/1001-00000000'
> doing dnsmgr_lookup for '216.18.125.12'

[survivant]

j<ai utilise ce tutoriel

http://ofps.oreilly.com/titles/9780596517342/ch15.html?c=443

voici mon dialplan

; test de boite vocale
exten => 123,1,Voicemail(1001@default,u)) ; leave a voicemail
exten => 123,n,Hangup()

exten => 321,1,VoicemailMain(1001@default,s) ; retrieve a voicemail

PS. meme si je vois mes voicemail sauvegarder sur le disque..

je n'ai jamais ete capable de les entre avec :321 aucune idee pourquoi..

[therebel23]

bonjour,
tu veux sauvegarder dans quelle type de SGBD ? Parce qu'odbc sous linux, faut-être motivé ..!

[survivant]

postgreSQL

j'ai suivi la procedure pour ODBC.