Mwi not updating

[dan_j]

In my setup, I’ve got an external script that performs voicemail functionality, using the standard asterisk voicemail realtime mysql database structure.

In voicemail.conf, I have pollmailboxes set to yes, and pollfreq set to 60.

In previous installations (asterisk v13), this worked perfectly.
However, in asterisk v20, no endpoints are receiving mwi updates when a voicemail is left.

• is there a way i can use the asterisk cli to see how many messages asterisk is detecting so that i can confirm the connection to the database is working properly?
• how can i enable console debug output for all odbc requests that asterisk makes to ensure that polling is working?

Many thanks

[penguinpbx]

You might consider some PJSIP logging to see what is being sent to the phones.

Basic ODBC connectivity can be checked with “odbc show” on the CLI.

You could also add some SQL in /etc/asterisk/func_odbc.conf file for custom checks. Then your dialplan can use those functions eg.

func_odbc.conf:

[VMCOUNT]
readsql=SELECT COUNT(*) FROM messages WHERE extension='${SQL_ESC(${ARG1})}'

extensions.conf:

same = n,Set(count=${ODBC_VMCOUNT(123)})