[asterisk-bugs] [JIRA] (ASTERISK-24441) Unable to store voicemail greetings using PostgreSQL with ODBC

[Matt Jordan (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-24441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=223074#comment-223074 ] 

Matt Jordan edited comment on ASTERISK-24441 at 10/19/14 4:33 PM:
------------------------------------------------------------------

What is your table schema?

PostgreSQL is a bit of a pain to set up for Asterisk ODBC VoiceMail, but things haven't really changed at all since this was written:

http://asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/I_section12_tt1578.html


was (Author: mjordan):
What is your table schema?

PostgreSQL is a bit of a pain to set up for Asterisk ODBC VoiceMail, but things haven't really changed at all since this was written:


> Unable to store voicemail greetings using PostgreSQL with ODBC
> --------------------------------------------------------------
>
>                 Key: ASTERISK-24441
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24441
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 13.0.0-beta2
>         Environment: Fedora 20 x86_64, PostgreSQL 9.3.5
>            Reporter: Anthony Messina
>
> Using ODBC voicemail with PostgreSQL backend, I am unable to store voicemail greetings as Asterisk (app_voicemail) attempts to insert invalid integers into the recommended PostgreSQL table, yielding the PostgreSQL error
> {code}
> invalid input syntax for integer: ""
> {code}
> The issue appears to be that Asterisk is passing NULL values as "" and is quoting integers, like "-1" via the store_file function in app_voicemail.c
> I get errors similar to what the user described at http://stackoverflow.com/questions/22863602/unable-to-store-voicemail-through-odbc-in-asterisk
> {code}
> [Oct 19 13:32:04] DEBUG[28796][C-00000000]: res_odbc.c:1062 odbc_release_obj2: odbc_release_obj2(0x252f738) called (obj->txf = (nil))
> [Oct 19 13:32:04] WARNING[28796][C-00000000]: app_voicemail.c:4186 insert_data_cb: SQL Direct Execute failed!
> [Oct 19 13:32:04] WARNING[28796][C-00000000]: res_odbc.c:617 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk]...
> [Oct 19 13:32:04] WARNING[28796][C-00000000]: app_voicemail.c:4186 insert_data_cb: SQL Direct Execute failed!
> [Oct 19 13:32:04] WARNING[28796][C-00000000]: app_voicemail.c:4302 store_file: SQL Execute error!
> [INSERT INTO voicemail_messages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)]
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)