#!/bin/sh
#settings
export PGPASSWORD="xxxxxxxxxxxxxxxxxxxxx"
db_host=127.0.0.1
db_port=5432
#set the date
now=$(date +%Y-%m-%d)
#show message to the console
echo "Maintenance Started"
echo "deleting freeswitch logs older 7 days"
/usr/bin/find /var/log/freeswitch/freeswitch.log.* -mtime +7 -exec rm {} \;
echo "deleting fax files older than 30 days"
/usr/bin/find /var/lib/freeswitch/storage/fax/* -name '*.tif' -mtime +30 -exec rm {} \;
/usr/bin/find /var/lib/freeswitch/storage/fax/* -name '*.pdf' -mtime +30 -exec rm {} \;
echo "deleting fax files from from the database older than 30 days"
psql --host=127.0.0.1 --username=fusionpbx -c "delete from v_fax_files WHERE fax_date < NOW() - INTERVAL '30 days'"
echo "deleting fax logs from from the database older than 30 days"
psql --host=127.0.0.1 --username=fusionpbx -c "delete from v_fax_logs WHERE fax_date < NOW() - INTERVAL '30 days'"
echo "deleting voicemail files older than 30 days"
/usr/bin/find /var/lib/freeswitch/storage/voicemail/* -name 'msg_*.wav' -mtime +30 -exec rm {} \;
/usr/bin/find /var/lib/freeswitch/storage/voicemail/* -name 'msg_*.mp3' -mtime +30 -exec rm {} \;
echo "deleting voicemails from database older than 30 days"
psql --host=127.0.0.1 --username=fusionpbx -c "delete from v_voicemail_messages WHERE to_timestamp(created_epoch) < NOW() - INTERVAL '30 days'"
echo "deleting recordings files older than 30 days"
/usr/bin/find /var/lib/freeswitch/recordings/*/archive -type f -mtime +30 -exec rm -rf {} \;
echo "deleting call detail records older 30 days"
psql --host=127.0.0.1 --username=fusionpbx -c "delete from v_xml_cdr WHERE to_timestamp(start_epoch) < NOW() - INTERVAL '30 days'"
echo "Maintenance Completed";