paste here the result from : select * from sent_sms limit 10;
Bharat Vasant wrote: > Awaiting any insights into the below issue..!! > > Bharat K. Vasant > > *From:* Bharat Vasant [mailto:bha...@charteredinfo.com] > *Sent:* Wednesday, July 15, 2009 5:42 PM > *To:* 'users@kannel.org' > *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:alejandro.guerri...@gmail.com] > *Sent:* Wednesday, July 15, 2009 2:55 PM > *To:* Bharat Vasant > *Cc:* users@kannel.org > *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 <bha...@charteredinfo.com > <mailto:bha...@charteredinfo.com>> 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 > <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:bha...@charteredinfo.com > <mailto:bha...@charteredinfo.com>] > *Sent:* Tuesday, July 14, 2009 12:52 PM > *To:* 'users@kannel.org <mailto:users@kannel.org>' > *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 > > > > >