Summary:ASTERISK-01173: [patch] 'show voicemail users' doesn't work with USE_MYSQL_VM_INTERFACE=1
Reporter:flavour (flavour)Labels:
Date Opened:2004-03-08 08:30:52.000-0600Date Closed:2004-09-25 02:18:21
Versions:Frequency of
Environment:Attachments:( 0) 20040308__show_vm_users.diff.txt
Description:When USE_MYSQL_VM_INTERFACE=1 is set (i.e. Voicemail users are stored in a live MySQL database) then the CLI command 'show voicemail users' returns no results.


This was shown up by Monastery, which uses this command.
Comments:By: Tilghman Lesher (tilghman) 2004-03-08 11:34:28.000-0600

This command is not necessary when used with a database, because adding the voicemail box to the database will allow the box to be used without a reload.

However, when using voicemail.conf to configure mailboxes, the file and the application may be out of sync (which can be corrected with a reload), which is the primary reason for using this command.

Patch uploaded to remove this command when using MySQL to store voicemail configurations (it would need to be rewritten anyway with ifdef's to support MySQL).

By: flavour (flavour) 2004-03-09 02:33:42.000-0600

I think that it is still useful even with a database - e.g. for web-based monitoring tools such as Monastery.
I'd much prefer to see a patch with the ifdefs to support MySQL.
Note that upon my looking at the code, I didn't see anything specific to the text-file configuration in your original patch....vmu* users should work anyway?...well my C is too poor to be sure, let alone fix yet I didn't see why it didn't 'just work'

By: Tilghman Lesher (tilghman) 2004-03-09 10:31:51.000-0600

In database configurations, voicemail configuration is stored and referenced from the database.  In textfile configurations, voicemail configuration is stored in a linked list.  Because of this difference, you'd need to write the code to query all configurations from the database.

Like I've said on the mailing list, it wouldn't be that difficult to write, if somebody would like to work on it.

By: Brian West (bkw918) 2004-03-13 00:42:54.000-0600

I don't think we need show voicemail stuff if using MySQL because you can quickly do it via other methods more efficiently.


By: James Golovich (jamesgolovich) 2004-03-15 01:27:52.000-0600

I tend to agree with bkw here.  If there are 50K voicemail boxes in mysql do you really want to display them all?

By: Malcolm Davenport (mdavenport) 2004-03-19 16:50:59.000-0600

Fixed in CVS.  Thank you.