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&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:[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
