SMSEagle NXS-9700, User Manual

Page: 140 / 163

140
| SMSEagle NXS-9700-3G | User’s Manual
Database cleaning scripts
We have added some useful scripts which may be used to delete SMS messages from database through
Linux CLI.
Scripts are located at following directory:
/mnt/nand-user/scripts/
•
db_delete –
script for deleting SMS from folders Inbox, SentItems older than provided date.
Usage:
./db_delete YYYYMMDDhhmm
•
db_delete_7days –
script for deleting SMS from folders Inbox, Sentitems older than 7 days.
Usage:
./db_delete_7days
•
db_delete_allfolders –
script for cleaning PostgreSQL database folders (Inbox, SentItems,
Outbox). Specially designed to run periodically through cron. Usage:
./db_delete_allfolders
•
db_delete_select -
script for deleting SMS from chosen databse folder (Inbox, Outbox,
SentItems, Trash). Usage:
./db_delete_select {inbox|outbox|sentitems|trash}
Adding script to system cron daemon
1) Create a file inside
/etc/cron.d/
directory with your desired name (eg.
pico db_cleaner
)
2) Example content of this file:
0 0 1 * * root /mnt/nand-user/scripts/db_delete_allfolders
This will run cleaning script every 1
st
day of month.