История изменений - Asterisk: Вопросы и Ответы

Voicemail storage ODBC

Добрый день. Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке. При попытке оставить голосовое сообщение, в логе пишет такое:

== Using SIP RTP CoS mark 5 -- Executing [1111@incoming:1] VoiceMail("SIP/1001-00000003", "1002@default") in new stack -- <sip 1001-00000003=""> Playing 'vm-intro.slin' (language 'ru') -- <sip 1001-00000003=""> Playing 'beep.slin' (language 'ru') -- Recording the message -- x=0, open writing: /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0 -- User ended message by pressing # -- <sip 1001-00000003=""> Playing 'auth-thankyou.slin' (language 'ru') == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt': == Found [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk собран с опцией ODBS STORAGE в разделе Voicemail Build Options. База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем. Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день. Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке. При попытке оставить голосовое сообщение, в логе пишет такое:

== Using SIP RTP CoS mark 5 -- Executing [1111@incoming:1] VoiceMail("SIP/1001-00000003", "1002@default") in new stack -- <sip 1001-00000003=""> [2011-08-03 17:32:46] WARNING[3927]: app_voicemail.c:3258 generic_prepare: SQL Alloc Handle failed! [2011-08-03 17:32:46] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... [2011-08-03 17:32:46] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk [2011-08-03 17:32:46] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] -- <SIP/1001-00000003> Playing 'vm-intro.slin' (language 'ru') -- <sip 1001-00000003=""> [2011-08-03 17:32:46] NOTICE[3927]: channel.c:4128 __ast_read: Dropping incompatible voice frame on SIP/1001-00000003 of format gsm since our native format has changed to 0x4 (ulaw) -- <SIP/1001-00000003> Playing 'beep.slin' (language 'ru') -- Recording the message -- x=0, open writing: /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0 -- User ended message by pressing # -- <sip 1001-00000003=""> <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru') == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt': == Found [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed! [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]... [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed! [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error! [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)](?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk собран с опцией ODBS STORAGE в разделе Voicemail Build Options. База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем. Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день. Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке. При попытке оставить голосовое сообщение, в логе пишет такое:

== Using SIP RTP CoS mark 5 -- Executing [1111@incoming:1] VoiceMail("SIP/1001-00000003", "1002@default") in new stack [2011-08-03 17:32:46] WARNING[3927]: app_voicemail.c:3258 generic_prepare: WARNING[3927]: appvoicemail.c:3258 genericprepare: SQL Alloc Handle failed! [2011-08-03 17:32:46] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: failed! WARNING[3927]: resodbc.c:744 astodbcsanitycheck: Connection is down attempting to reconnect... [2011-08-03 17:32:46] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: Connecting asterisk [2011-08-03 17:32:46] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: Connected to asterisk [asterisk-connector] -- <SIP/1001-00000003> Playing 'vm-intro.slin' (language 'ru') [2011-08-03 17:32:46] NOTICE[3927]: channel.c:4128 __ast_read: Dropping incompatible voice frame on SIP/1001-00000003 of format gsm since our native format has changed to 0x4 (ulaw) -- <SIP/1001-00000003> Playing 'beep.slin' (language 'ru') [asterisk-connector] ..... -- Recording the message -- x=0, open writing: /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0 -- User ended message by pressing # -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru') == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt': == Found [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3736 insert_data_cb: WARNING[3927]: appvoicemail.c:3736 insertdata_cb: SQL Direct Execute failed! [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: failed! WARNING[3927]: resodbc.c:601 astodbcdirectexecute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]... [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: [asterisk-connector]... WARNING[3927]: resodbc.c:744 astodbcsanitycheck: Connection is down attempting to reconnect... [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: Connecting asterisk [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: Connected to asterisk [asterisk-connector] [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3736 insert_data_cb: [asterisk-connector] WARNING[3927]: appvoicemail.c:3736 insertdata_cb: SQL Direct Execute failed! [2011-08-03 17:32:55] WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: failed! WARNING[3927]: resodbc.c:744 astodbcsanitycheck: Connection is down attempting to reconnect... [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: Connecting asterisk [2011-08-03 17:32:55] NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: Connected to asterisk [asterisk-connector] [2011-08-03 17:32:55] WARNING[3927]: app_voicemail.c:3846 store_file: [asterisk-connector]
WARNING[3927]: appvoicemail.c:3846 storefile: SQL Execute error! [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]
(?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk собран с опцией ODBS STORAGE в разделе Voicemail Build Options. База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем. Уже не знаю куда копать....

Voicemail storage ODBC

Добрый ~~день.~~ день.
Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском ~~языке.~~ языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

WARNING[3927]: appvoicemail.c:3258 genericprepare:
WARNING[3927]: app_voicemail.c:3258 generic_prepare: SQL Alloc Handle failed! WARNING[3927]: resodbc.c:744 astodbcsanitycheck: failed! WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: reconnect... NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: asterisk NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] ..... [asterisk-connector] ..... -- Recording the message -- x=0, open writing: /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0 -- User ended message by pressing # -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru') == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt': == Found WARNING[3927]: appvoicemail.c:3736 insertdata_cb: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed! WARNING[3927]: resodbc.c:601 astodbcdirectexecute: failed! WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]... WARNING[3927]: resodbc.c:744 astodbcsanitycheck: [asterisk-connector]... WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: reconnect... NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: asterisk NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] WARNING[3927]: appvoicemail.c:3736 insertdata_cb: [asterisk-connector] WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed! WARNING[3927]: resodbc.c:744 astodbcsanitycheck: failed! WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect... NOTICE[3927]: resodbc.c:1480 odbcobj_connect: reconnect... NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk NOTICE[3927]: resodbc.c:1510 odbcobjconnect: resodbc: asterisk NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] WARNING[3927]: appvoicemail.c:3846 storefile: [asterisk-connector] WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error! [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)](?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk собран с опцией ODBS STORAGE в разделе Voicemail Build ~~Options.~~ Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без ~~проблем.~~ проблем.
Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день.
Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

WARNING[3927]: app_voicemail.c:3258 generic_prepare: SQL Alloc Handle failed!

WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...

NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk

NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

.....

    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0
    -- User ended message by pressing #
    -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru')
  == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt':   == Found
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!

WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...

WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...

NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk

NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!

WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...

NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk

NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk собран с опцией ODBS STORAGE в разделе Voicemail Build Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем.
Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день.
Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

.....

    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0
    -- User ended message by pressing #
    -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru')
  == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt':   == Found
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!

WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...

WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...

NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk

NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!

WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...

NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk

NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk 1.8 собран с опцией ODBS STORAGE в разделе Voicemail Build Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем.
Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день.
Проблема записать сообщения голосовой почты в БД postgresql

Настраивал по всем известной книге на русском языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

.....

    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0
    -- User ended message by pressing #
    -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru')
  == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt':   == Found
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
 WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...
 WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
 NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
 NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
 WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
 WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
 NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
 NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
 WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk 1.8 собран с опцией ODBS STORAGE в разделе Voicemail Build Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем.
Уже не знаю куда копать....

Voicemail storage ODBC

Добрый день.
Проблема записать сообщения голосовой почты в БД ~~postgresql~~Postgresql 8.4

Настраивал по всем известной книге на русском языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

.....

    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0
    -- User ended message by pressing #
    -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru')
  == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt':   == Found
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...
WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk 1.8 собран с опцией ODBS STORAGE в разделе Voicemail Build Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем.
Уже не знаю куда копать....

Лог СУБД:

ERROR:  invalid large-object descriptor: 24741
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
LOG:  could not send data to client: Обрыв канала
STATEMENT:  ROLLBACK
ERROR:  invalid large-object descriptor: 24742
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
LOG:  could not send data to client: Обрыв канала
STATEMENT:  ROLLBACK

Voicemail storage ODBC

Добрый день.
Проблема записать сообщения голосовой почты в БД Postgresql 8.4

Настраивал по всем известной книге на русском языке.
При попытке оставить голосовое сообщение, в логе пишет такое:

.....

    -- Recording the message
    -- x=0, open writing:  /var/spool/asterisk/voicemail/default/1002/tmp/fJd1kd format: wav49, 0x8c14ae0
    -- User ended message by pressing #
    -- <SIP/1001-00000003> Playing 'auth-thankyou.slin' (language 'ru')
  == Parsing '/var/spool/asterisk/voicemail/default/1002/INBOX/msg0000.txt':   == Found
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
WARNING[3927]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...
WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
WARNING[3927]: app_voicemail.c:3736 insert_data_cb: SQL Direct Execute failed!
WARNING[3927]: res_odbc.c:744 ast_odbc_sanity_check: Connection is down attempting to reconnect...
NOTICE[3927]: res_odbc.c:1480 odbc_obj_connect: Connecting asterisk
NOTICE[3927]: res_odbc.c:1510 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
WARNING[3927]: app_voicemail.c:3846 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)]

Аsterisk 1.8 собран с опцией ODBS STORAGE в разделе Voicemail Build Options.
База работает, Asterisk к ней подключается, CDR- записи пишет в БД без проблем.
Уже не знаю куда копать....

Лог СУБД:

ERROR:  invalid large-object descriptor: 24741
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
LOG:  could not send data to client: Обрыв канала
STATEMENT:  ROLLBACK
ERROR:  invalid large-object descriptor: 24742
ERROR:  current transaction is aborted, commands ignored until end of transaction block
ERROR:  current transaction is aborted, commands ignored until end of transaction block
LOG:  could not send data to client: Обрыв канала
STATEMENT:  ROLLBACK

Таблица в БД:

asterisk=> SELECT * FROM voicemessages;
 uniqueid | msgnum | dir | context | macrocontext | callerid | origtime | duration | mailboxuser | mailboxcontext | recording | label | read | flag 
----------+--------+-----+---------+--------------+----------+----------+----------+-------------+----------------+-----------+-------+------+------
(0 rows)

История изменений [назад]

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC

Voicemail storage ODBC