Title: Re: SQL BOX

Ok, found the solution, its very easy.. just put inside query dlr_mask value 31


example:



INSERT INTO `send_sms` (`momt`, `sender`, `receiver`, `msgdata`, `sms_type`, `dlr_mask`) 

VALUES ('MT', '1234', '987654321', 'test sms dlr mask', 2, 31);


31 is = 1+2+4+8+16


About numbers:


1: delivery success

2: delivery failure

4: message buffered

8: smsc submit

16: smsc reject



I tested it, when i sent sms, after some seconds i got new row in database table,


msgdata: id:271746061 stat:DELIVRD


dlr_mask: 1 (this mean success delivered)


Then another test i made:


removed SIM card from phone, and again sent sms.. So.. no delivery report was made.. then after 5min i put back SIM inside mobile, and i got my SMS, and after some secs a new row in database table, status: delivered.



Thanks for Kannel and sqlbox !



Wednesday, April 29, 2009, 2:59:33 PM, you wrote:



Check bearerbox-access.log.

 

By configuring dlr-mask, you can get confirmation from the SMSc is the SMS was accepted succefully or delivered succesfully to the client.

 

Read the manual.

 

BR,

Nikos

 

----- Original Message ----- 

From: [email protected] 

To: [email protected] 

Sent: Wednesday, April 29, 2009 2:43 PM

Subject: SQL BOX


i'm using


Kannel + SQLBox addon


When i Send SMS:


INSERT INTO send_sms 

(momt, sender, receiver, msgdata, sms_type)

VALUES ('MT', '1234', '987654321', 'Hello world', 2);



How can i know: Is SMS delivered to client or it's not ?


i would like to create system, if SMS not delivered/failed to deliver, Retry after 1min, then after 5min, then after 30min etc.


Or this system is implemented inside Kannel ?





-- 

Best regards,

 Waza123                            mailto:[email protected]

Reply via email to