SMS

SMSserver - instalation and use

• Download great Stefan Frings Smstools software

Installation and configuration are described on the download site.

• • Configuration page suggests that you use syntax 'inbox=directory' while default configuration file installed (/etc/smsd.conf) suggests (and works with !!!) usage 'incoming=yes', where it uses /var/spool/sms/incoming directory as default (created during installation)

Database connectivity (linux to MSSQL)

Database querying and reporting to SMS

• I created php file that queryies database and writes information to a small text file.
• Entry is added to crontab that calls this php file regulary and so keeps information up to date (at the end of entry I had to add '> /dev/null', not to clutter root email spool with reports
• Another entry in crontab calls a script that parses new messages in /var/spool/sms/outgoing, does actions triggered by messages and renames / moves these messages