[Freeswitch-users] Setup Voicemail to Expire after X amount of Days.
msc at freeswitch.org
Wed Aug 29 03:54:14 MSD 2012
Cron job is probably the lowest barrier to entry. Just get the sqlite3
client installed and go from there. Check out
fs-install/db/voicemail_default.db, specifically the voicemail_msgs table:
sqlite> .schema voicemail_msgs
CREATE TABLE voicemail_msgs (
CREATE INDEX voicemail_msgs_idx1 on voicemail_msgs(created_epoch);
CREATE INDEX voicemail_msgs_idx2 on voicemail_msgs(username);
CREATE INDEX voicemail_msgs_idx3 on voicemail_msgs(domain);
CREATE INDEX voicemail_msgs_idx4 on voicemail_msgs(uuid);
CREATE INDEX voicemail_msgs_idx5 on voicemail_msgs(in_folder);
CREATE INDEX voicemail_msgs_idx6 on voicemail_msgs(read_flags);
CREATE INDEX voicemail_msgs_idx7 on voicemail_msgs(forwarded_by);
CREATE INDEX voicemail_msgs_idx8 on voicemail_msgs(read_epoch);
CREATE INDEX voicemail_msgs_idx9 on voicemail_msgs(flags);
Just select uuid from voicemail_msgs where created_epoch < xyz and then use
the vm_delete API in fs_cli to zap the message:
vm_delete user at domain <uuid>
FS will do the rest: update the db, send out any MWI indications, etc.
If you get a working cron script let us know and we'll help you post it to
the wiki for all the world to see. :)
On Tue, Aug 28, 2012 at 2:04 PM, Avi Marcus <avi at avimarcus.net> wrote:
> I don't think it exists. You could either custom-code a C module that
> polls at various times..
> Or just set a cron that queries the DB for old VMs then deletes the entry
> and the file.
> On Wed, Aug 29, 2012 at 12:00 AM, Chris Ferreira <chris at gonumina.com>wrote:
>> How can I set FreeSWITCH up so that OLD voicemails get deleted
>> I havent found anything in the Wiki or other documentation.
>> Your input is much appreciated.
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> Official FreeSWITCH Sites
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> Official FreeSWITCH Sites
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
Michael S Collins
-------------- next part --------------
An HTML attachment was scrubbed...
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users