hi…i am trying to insert the voicemail data into postgres using odbc but cli show the following error [code] Called SIP/4000
– SIP/4000-00000035 is ringing
– Nobody picked up in 10000 ms
– Executing [500@voicemail:2] Set(“SIP/7000-00000034”, “caller_id=7000”) in new stack
– Executing [500@voicemail:3] System(“SIP/7000-00000034”, "psql -U asterisk --dbname=asterisk --command=“update test set test_id=test_id+1"”) in new stack
– Executing [500@voicemail:4] VoiceMail(“SIP/7000-00000034”, “500@MyVoiceMail,u”) in new stack
> 0x7f166c024be0 – Probation passed - setting RTP source address to 202.141.151.100:8000
– <SIP/7000-00000034> Playing ‘vm-theperson.gsm’ (language ‘en’)
> 0x7f166c024be0 – Probation passed - setting RTP source address to 202.141.151.100:8000
– <SIP/7000-00000034> Playing ‘digits/5.gsm’ (language ‘en’)
– <SIP/7000-00000034> Playing ‘digits/0.gsm’ (language ‘en’)
– <SIP/7000-00000034> Playing ‘digits/0.gsm’ (language ‘en’)
– <SIP/7000-00000034> Playing ‘vm-isunavail.gsm’ (language ‘en’)
– <SIP/7000-00000034> Playing ‘vm-intro.gsm’ (language ‘en’)
– <SIP/7000-00000034> Playing ‘beep.gsm’ (language ‘en’)
– Recording the message
– x=0, open writing: /var/spool/asterisk/voicemail/MyVoiceMail/500/tmp/Acs39Y format: wav49, 0x7f1678002138
– User hung up
== Parsing ‘/var/spool/asterisk/voicemail/MyVoiceMail/500/INBOX/msg0000.txt’: Found
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed!
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: res_odbc.c:608 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]…
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Aug 5 18:31:49] NOTICE[22449][C-0000001a]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Aug 5 18:31:49] NOTICE[22449][C-0000001a]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed!
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Aug 5 18:31:49] NOTICE[22449][C-0000001a]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Aug 5 18:31:49] NOTICE[22449][C-0000001a]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Aug 5 18:31:49] WARNING[22449][C-0000001a]: app_voicemail.c:4202 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)]
== Spawn extension (voicemail, 500, 4) exited non-zero on ‘SIP/7000-00000034’
[/code]