incapable de sauvegarder les voicemails dans ODBC
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'
