Just to add to it if i send sms using http://host:13013/cgi-bin/sendsms? -----etc i get dlr-url invoked but not if i am using sqlbox
On Tue, Jan 5, 2010 at 1:29 AM, preeteesh kakkar <preeteesh.kak...@gmail.com> wrote: > Hi, > > I am using sqlbox to send sms. Below are some problem i am facing > > I push dlr-mask as 31 & dlr-url = > "http://localhost/dlr.php?messageid=somecustomid&type=%d" into > send_sms , this goes to sent_sms immediately & i get sms > > Now the kannel doesn't seems to invoke this dlr-url, Instead of this i > see a new entry inserted into sent_sms table.with momt as DLR & > msgdata as something like this "id:1024541450 sub:001 dlvrd:001 submit > date:1001041916 done date:1001041916 stat:DELIVRD err:000 text:" > > I wonder instead of invoking the URL how this entry got to db. > > Anyways what i am looking at is to get message_id from kannel as soon > as any sms is sent for particular sms & store that sms id & the > message_id from kannel in some separate table or just in sent_sms > table in say new field called message_id so that the next time i have > some DLR with that particular message id i can associate it. > > I saw in bearerbox logs that we have message_id in response to submit_sm_resp > > 2010-01-04 20:12:05 [8085] [6] DEBUG: type_name: submit_sm_resp > 2010-01-04 20:12:05 [8085] [6] DEBUG: command_id: 2147483652 = 0x80000004 > 2010-01-04 20:12:05 [8085] [6] DEBUG: command_status: 0 = 0x00000000 > 2010-01-04 20:12:05 [8085] [6] DEBUG: sequence_number: 105 = 0x00000069 > 2010-01-04 20:12:05 [8085] [6] DEBUG: message_id: "1024541450" > > As far as i understand When kannel sends the SMS to SMPP, it uses the > smpp command submit_sm. SMPP immediately responds OK to the submit_sm > with the message_id.and that is when Kannel knows about the messageID > & i want this message_id to be into db for particular SMS it sent > submit_sm. > > The DLR could arrive in the next sencond or up to 3 days later. > > Please provide me with your guidance or thoughts on how this can be achieved. >