[asterisk-dev] Recording new Greeting in Asterisk 16 to ODBC in MySql doesn't play greeting.

[George Joseph]

On Fri, Jan 25, 2019 at 1:37 PM Steve Sether <ssether at usinternet.com> wrote:

> I'm having an issue in Asterisk 16 where when I record a new greeting,
> the greeting doesn't play when I call the users voicemail.
>
> I've tracked this down  NULL being inserted into the context column of
> the voicemail table.  When Asterisk retrieves the greeting, and the
> Context column is is null, it won't play the greeting, and gives this
> error:
>
>
> [2019-01-25 14:26:04] WARNING[32671][C-00000008]: app_voicemail.c:3995
> retrieve_file: SQL Get Data error! coltitle=context
> [SELECT * FROM voicemessages WHERE dir=? AND msgnum=?]
>
> [2019-01-25 14:26:04] WARNING[32671][C-00000008]: format_wav.c:145
> check_header: Read failed (type)
> [2019-01-25 14:26:04] WARNING[32671][C-00000008]: file.c:473 fn_wrapper:
> Unable to open format wav
> [2019-01-25 14:26:04] WARNING[32671][C-00000008]: file.c:1252
> ast_streamfile: Unable to open
> /var/spool/asterisk/voicemail/usitest-VOICEMAIL/253/unavail (format
> (g722)): No such file or directory
>
>
> This NULL in Context gets inserted into the greeting row when I record
> the greeting via Asterisk.  As soon as I change the NULL to anything
> else, the greeting plays normally when I call the users VM.
>
> Asterisk 11 behaves in a similar manner if I manually insert a NULL into
> the context column of a greeting.  However, in Asterisk 11 when I record
> a greeting the context column gets set to the empty string, not NULL, so
> this should never happen.
>
>  From what I can tell, either the playback function needs to be modified
> to ignore NULL values in the Context column, or the function that writes
> the greeting needs to be modified to not insert NULLS into this column.
>

Go ahead and open an issue at https://issues.asterisk.org.  Make sure you
indicate
which DBMS is being used as the backend and which version of unixODBC
is being used.  The odbc and voicemail configs will help as well.


>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev



-- 
*George Joseph*
Digium - A Sangoma Company | Software Developer | Software Engineering
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
direct/fax: +1 256 428 6012
Check us out at: https://digium.com · https://sangoma.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-dev/attachments/20190128/0c5ee16c/attachment.html>