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]>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&status=%A, > 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 > > > > 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]] > *Sent:* Tuesday, July 14, 2009 12:52 PM > *To:* '[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 > > >
