How to delete older call recordings

For users with VoipNow 3.0.0, the only way to delete older recordings from multiple extensions is to manually remove them from the VoipNow web interface.

The process must be repeated for each extension, which makes the whole thing very time-consuming.

Because of disk space limits set per user, call recording will not exceed those limits.

To set a disk space limit, you need to go to Unified Communications >> Roles and Permissions >> Maximum disk space for call recording.

Step-by-step guide

Assuming you are using a CentOS 6.x., please follow the steps below:

1. Download the script.

   wget -O delete_records.pl https://raw.githubusercontent.com/4psa/voipnowtoolbox/master/delete_records.pl

2. Install the needed Perl libraries:

   yum install perl-DBD-mysql perl-File-Copy-Recursive perl-File-Remove perl-DateTime perl-Archive-Tar perl-DBD-mysql

3. Edit the delete_records.pl script and adjust the following variables :

   $disabled = 0 
   $older = 1
   $archive_files = 1

   When $disabled = 0, the script will delete the records. When $disabled = 1, it will only do a backup.
   When $older = 1, the script will remove recordings older than this value (calculated in months) will be removed.
   When $archive_files = 1, the scrip will perform a backup (both MySQL and files) in the /backup directory.

4. Run the script. 
   

   perl delete_records.pl

5. As a result, recordings will get deleted from the database as well as from the disk.

   If you are not sure of what you are doing, it's recommended that you set archieve_files to 1, so that you have a backup in case something goes wrong.