SMSEagle NPE-9300-GPRS/3G, User Manual

Page: 92 / 107

Page
92
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
Due to security reasons crontab is being erased while rebooting the device. Thats why normal cron
entry won't work. Please see file /mnt/mtd/rcs - this script is being launched due to startup of the
device. Here you have some our cron rules added. You just need to add your rule at the end of the file.
Example:
cron_add db_clean ” 0 0 1 * * /mnt/nand-user/scripts/db_delete_allfolders”
which will run cleaning script every 1
st
day of month.