Summary:	ASTERISK-28012: ODBC Voicemail and 'pollmailboxes=yes' does not update shared state via XMPP
Reporter:	Ross Beer (rossbeer)	Labels:
Date Opened:	2018-08-16 09:30:03	Date Closed:	2021-11-02 14:12:11
Priority:	Minor	Regression?	No
Status:	Closed/Complete	Components:	Applications/app_voicemail Resources/res_xmpp
Versions:	13.22.0 GIT	Frequency of Occurrence	Constant
Related Issues:
Environment:	CentOS 7	Attachments:
Description:	When using ODBC voicemail, 'pollmailboxes=yes' any backend database changes do not cause XMPP shared MWI states to be updated. The only time XMPP MWI states are updated is if the following apps are run: VoiceMail() VoiceMailMain() XMPP states should be updated if changes are made to the database and mailboxes are being polled.
Comments:	By: Asterisk Team (asteriskteam) 2018-08-16 09:30:04.887-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Sean Bright (seanbright) 2019-04-13 14:43:15.926-0500 [~rossbeer], is this still a problem with the latest Asterisk 13? I see that there have been a few changes around polling & MWI since you originally reported this issue. By: Ross Beer (rossbeer) 2019-12-05 08:39:15.180-0600 I've tested with the latest 13 release and this is still an issue. If you access the mailbox using the voicemail apps the update is sent instantly, however the status is not set at all when polling and a change is made to the backend. By: Sean Bright (seanbright) 2019-12-05 12:04:24.711-0600 Setting up a test environment for this would require a lot of domain knowledge. Is there any level of debugging you are comfortable performing on this? If so, the function that does the polling is [here|https://github.com/asterisk/asterisk/blob/6ca76798e14c0495fff2b96b961caea1d42cdc57/apps/app_voicemail.c#L13236-L13255]. By: Ross Beer (rossbeer) 2019-12-05 13:37:24.645-0600 I'll have a go, I'm not that good with C I'm more of a Java guy :) I have a feeling that the code probably doesn't call a procedure when polling, but does when you dial the voicemail app etc. With some luck, I'll find it! By: Sean Bright (seanbright) 2019-12-05 13:54:13.752-0600 [~rossbeer], throwing an {{ast_log(LOG_ERROR, "hello ross\n");}} into the function I referenced would be a good start. The {{queue_mwi_event}} function in {{app_voicemail.c}} is where the MWI would ultimately be published, so some additional logging in that function might also be helpful. By: Sean Bright (seanbright) 2021-04-23 09:25:34.500-0500 [~rossbeer], if this is still occurring I will need a full debug log. By: Ross Beer (rossbeer) 2021-04-23 09:28:13.571-0500 I think the issue with this is that there needs to be an active MWI subscription or SIP registration for the poll process to check the database. As we have Voicemail on a dedicated server and XMPP distributing the MWI, there are no active registrations or subscriptions. By: Sean Bright (seanbright) 2021-04-23 11:15:45.895-0500 In order to move this issue forward we need to be able to reproduce it, which requires instruction from you. Please provide detailed instructions, config files, etc. so that we can lab this up locally.