Difference between revisions of "SMS"

From Mesopoly 3.0
Jump to navigation Jump to search
Line 9: Line 9:
 
-----
 
-----
 
==Database querying and reporting to SMS==
 
==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

Revision as of 13:26, 29 June 2006

SMSserver - instalation and use

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