195
| SMSEagle MHD-8100
| 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:
/opt/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 /opt/scripts/db_delete_allfolders
This will run cleaning script every 1
st
day of month.
Summary of Contents for MHD-8100-3G
Page 1: ...SMSEAGLE MHD 8100 3G MHD 8100 4G User s Manual ...
Page 9: ...9 SMSEagle NXS 9700 3G User s Manual GET READY TO START I ...
Page 21: ...21 SMSEagle MHD 8100 User s Manual USING OF SMSEAGLE II ...
Page 76: ...76 SMSEagle MHD 8100 User s Manual Screenshot from Blacklist Define STOP word feature ...
Page 207: ...207 SMSEagle MHD 8100 User s Manual TROUBLESHOOTING I I I I I I ...
Page 210: ...210 SMSEagle MHD 8100 User s Manual SERVICE REPAIR IV I ...
Page 212: ...212 SMSEagle MHD 8100 User s Manual TECH SPECS SAFETY INFORMATION V I ...