[Freeswitch-users] Setup Voicemail to Expire after X amount of Days.

[Michael Collins]

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 (
   created_epoch INTEGER,
   read_epoch    INTEGER,
   username      VARCHAR(255),
   domain        VARCHAR(255),
   uuid          VARCHAR(255),
   cid_name      VARCHAR(255),
   cid_number    VARCHAR(255),
   in_folder     VARCHAR(255),
   file_path     VARCHAR(255),
   message_len   INTEGER,
   flags         VARCHAR(255),
   read_flags    VARCHAR(255),
   forwarded_by  VARCHAR(255)
);
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. :)

-MC


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.
>
> -Avi
>
>
>
> 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
>> automatically?
>>
>> I havent found anything in the Wiki or other documentation.
>>
>>
>>
>> Your input is much appreciated.
>>
>>
>>
>>
>> Thanks,
>>
>> -Chris
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>


-- 
Michael S Collins
Twitter: @mercutioviz
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120828/8a0a572a/attachment.html