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, 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 <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
