I have tried following: 1. Initially I was starting - I. Bearerbox II. SQLBox III. SMSbox 2. After your suggestion, I have tried starting I. Bearerbox II. SMSbox III. SQLBox 3. I have also tried dlr-mask as 31 and 7
4. Issue: I am getting DLR in sent_sms table but I want dlrurl to be invoked (that's not happening) so that I can update the DLR status against the message (in same record) that I am storing in separate mysql table. 5. In other words, I want to combine respective SMS and DLR as seen in sent_sms table. 6. I want this so that I can show the message and delivery status in single record. 7. I had also posted one article before few days but didn't received any reply for the same - "SQL Box and DLR Best Practice" Alejandro, did you had chance to look into this issue. I would appreciate a small help from you or any member who has implemented similar scenario. Bharat Vasant -----Original Message----- From: seikath [mailto:[email protected]] Sent: Thursday, July 16, 2009 12:04 PM To: [email protected] Subject: Re: Sqlbox Dlrurl not being Invoked I dont understand the ussue here you have the DLR in the table with the DELIVRD status IF you want to skip that part and your apache to handle the DLR, start the sqlbox AFTER the smsbox and you may set the dlr-mask to 31 in a view to catch all the DLR statuses sent by the smsc. Bharat Vasant wrote: > Enclosed snet_sms table snapshot file as required by you. > > Bharat Vasant > > > > *From:* Bharat Vasant [mailto:[email protected]] > *Sent:* Wednesday, July 15, 2009 10:52 PM > *To:* '[email protected]' > *Subject:* RE: Sqlbox Dlrurl not being Invoked > *Importance:* High > > > > Awaiting any insights into the below issue..!! > > Bharat K. Vasant > > *From:* Bharat Vasant [mailto:[email protected]] > *Sent:* Wednesday, July 15, 2009 5:42 PM > *To:* '[email protected]' > *Cc:* 'Alejandro Guerrieri' > *Subject:* RE: Sqlbox Dlrurl not being Invoked > *Importance:* High > > > > Dear Alejandro: > > > > Thanks for your reply. > > Attached logs. Awaiting your insights about why dlrurl is not updating > the delivery report in our table. Is it being invoked !? > > Bharat K. Vasant > * > **From:* Alejandro Guerrieri [mailto:[email protected]] > *Sent:* Wednesday, July 15, 2009 2:55 PM > *To:* Bharat Vasant > *Cc:* [email protected] > *Subject:* Re: Sqlbox Dlrurl not being Invoked > > > > Bharat, > > > > sqlbox only pipes messages inserted on send_sms into kannel. Kannel then > sends the messages and create/update/delete the DLR entries. > > > > I'd start looking further on your kannel logs to see if the DLR's are in > fact created. Also, make sure that you set dlr-mask and dlr-url on the > sqlbox table when inserting. > > > > Regards, > > > > Alejandro > > On Wed, Jul 15, 2009 at 8:43 AM, Bharat Vasant <[email protected] > <mailto:[email protected]>> wrote: > > I have checked Apache access_log and found that if I submit sms using > http://localhost:13013/cgi-bin/sendsms and provide dlrurl paramater, > the access_log shows the dlrurl invoked on receipt of DLR > > > > But if I try to send SMS by inserting in send_sms table (BB log as > below), I am not seeing the dlr invoked in Apache access_log. > > > > Please suggest me to debug non-invoke of dlrurl after sending sms by > inserting directly to send_sms table. > > > > BBLog: > > 2009-07-15 11:42:22 [5083] [6] DEBUG: SMPP[mysmsc] handle_pdu, got DLR > > 2009-07-15 11:42:22 [5083] [6] DEBUG: DLR[mysql]: Looking for DLR > smsc=mysmsc, ts=60BB0EBB, dst=9198900nnnnn, type=1 > > 2009-07-15 11:42:22 [5083] [6] DEBUG: sql: SELECT mask, service, url, > source, destination, boxc FROM dlr WHERE smsc='mysmsc' AND ts='60BB0EBB'; > > 2009-07-15 11:42:22 [5083] [6] DEBUG: Found entry, row[0]=7, row[1]=, > row[2]=http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&s tatus=%A > <http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&status= %25A>, > row[3]=BSSQL, row[4]=9198900nnnnn row[5]=sqlbox > > 2009-07-15 11:42:22 [5083] [6] DEBUG: DLR[mysql]: created DLR message > for URL > <http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&status= %A > <http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&status= %25A>> > > 2009-07-15 11:42:22 [5083] [6] DEBUG: removing DLR from database > > 2009-07-15 11:42:22 [5083] [6] DEBUG: sql: DELETE FROM dlr WHERE > smsc='mysmsc' AND ts='60BB0EBB' LIMIT 1; > > > > Hope to get some early help from the group regarding the issue. > > > > Bharat Vasant > > > > *From:* Bharat Vasant [mailto:[email protected] > <mailto:[email protected]>] > *Sent:* Tuesday, July 14, 2009 12:52 PM > *To:* '[email protected] <mailto:[email protected]>' > *Subject:* Sqlbox Dlrurl not being Invoked > *Importance:* High > > > > I am adding DlrUrl in Send_sms table while sending SMS by inserting row > to Send_sms table (sqlbox) as > http://localhost/dlr.php?msgid=$uuid&status=%A > <http://localhost/dlr.php?msgid=$uuid&status=%25A> > > > > On receipt of DLR my PHP script is not updating the corresponding Msg > Status. Where I can check whether Kannel/sqlbox is invoking Dlrurl or not ? > > Bharat Vasant > > > > >
