it is macro

Tagged: sms RSS

• 

  bayu 10:00 pm on November 1, 2009 Permalink | Reply
  Tags: gammu (7), sms, trigger (7)   

  nice implementation of gammu

  http://matt.bottrell.com.au/archives/205-Nagios-2-way-alerting-via-SMS-Part-2.html

   

  Reply Click here to cancel reply.

  Name (required)

  Email (required)

  Web Site

   
• 

  bayu 11:50 pm on October 30, 2009 Permalink | Reply
  Tags: mail (5), pushmail, sms, trigger (7)   

  proven, converts mail to sms format: http://daniel.haxx.se/projects/mail2sms/readme.shtml

   
• 

  bayu 11:52 am on October 30, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), shell (10), sms, trigger (7)   

  the other half (cron-ed php script)
  mysql_query(‘SELECT * FROM kerja ORDER by id ASC LIMIT 1′)

  $ret=system(‘/usr/bin/uptime’);
  $ret=trim($ret);

   
• 

  bayu 10:04 am on October 30, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), sms, trigger (7)   

  half of the actual trigger
  DELIMITER $$
  CREATE TRIGGER kerjakan AFTER INSERT ON inbox FOR EACH ROW BEGIN
  insert into kerja(cmd_id) values(NEW.TextDecoded);
  END $$
  DELIMITER ;

  bayu is discussing. Toggle Comments

   
  • 

    bayu 12:11 am on December 16, 2009 Permalink

    create trigger kerjakan AFTER INSERT ON inbox FOR each row begin insert into kerja(command,sender) values (NEW.TextDecoded,NEW.SenderNumber); END$$

• 

  bayu 10:07 pm on October 29, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), sms   

  Sending sms using smsd-mysql works perfectly using this one.

  INSERT INTO outbox ( DestinationNumber, TextDecoded, CreatorID, Coding ) VALUES ( ’3636′, ‘flash info’, ‘Program’, ‘Default_No_Compression’);

   
• 

  bayu 9:47 pm on October 29, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), sms   

  gammu smsd reference

  http://www.gammu.org/wiki/index.php?title=Gammu:SMSD

   
• 

  bayu 9:16 pm on October 29, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), sms   

  gammu smsdrc default configuration

  /usr/share/doc/gammu/examples/config/smsdrc.gz

   
• 

  bayu 8:51 pm on October 29, 2009 Permalink | Reply
  Tags: gammu (7), phone (7), sms   

  send sms using gammu

  echo lala | gammu –sendsms TEXT [cellnumber]