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.
Code:[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,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) 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'
Répondre avec citation