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]> 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 <http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&status= %25A> &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 <http://localhost/dlr.php?msgid=0a571843-bf7d-18c0-599a-c1ef05ab16a1&status= %25A> &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 <http://localhost/dlr.php?msgid=$uuid&status=%25A> &status=%A 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
