[asterisk-dev] Recording new Greeting in Asterisk 16 to ODBC in MySql doesn't play greeting.
gjoseph at digium.com
Mon Jan 28 08:03:56 CST 2019
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
> [2019-01-25 14:26:04] WARNING[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[C-00000008]: format_wav.c:145
> check_header: Read failed (type)
> [2019-01-25 14:26:04] WARNING[C-00000008]: file.c:473 fn_wrapper:
> Unable to open format wav
> [2019-01-25 14:26:04] WARNING[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
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:
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...
More information about the asterisk-dev