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.
--
_____________________________________________________________________
-- 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
