You should connect an smsbox with smsbox-id = smsbox-id. In that case, the dlr will be sent to that smsbox instance. And the dlr-url will get called.
Of course, you are free to enter a custom smsbox-id. == Rene From: Ravindra Gupta // Viva [mailto:[email protected]] Sent: Monday, 30 July, 2012 18:25 To: Rene Kluwen Cc: [email protected]; [email protected] Subject: Re: dlr-url call on sqlbox Dear Rene, We have got below error. INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id, dlr_mask, dlr_url, boxc_id) VALUES ('MT', 'JMFINA', '91XXXXXXXXXX', 'SQLBOX TESTING SERVER', 2, 'test', 31, 'http://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26Ba tchID%3Dravi123-5d12d25be2a00b', 'smsbox-id' ) WARNING: Could not route message to smsbox id <smsbox-id>, smsbox is gone! 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP PDU 0x2aaaac004d30 dump: 2012-07-31 03:25:22 [16354] [6] DEBUG: type_name: submit_sm 2012-07-31 03:25:22 [16354] [6] DEBUG: command_id: 4 = 0x00000004 2012-07-31 03:25:22 [16354] [6] DEBUG: command_status: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: sequence_number: 265 = 0x00000109 2012-07-31 03:25:22 [16354] [6] DEBUG: service_type: NULL 2012-07-31 03:25:22 [16354] [6] DEBUG: source_addr_ton: 5 = 0x00000005 2012-07-31 03:25:22 [16354] [6] DEBUG: source_addr_npi: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: source_addr: "test" 2012-07-31 03:25:22 [16354] [6] DEBUG: dest_addr_ton: 1 = 0x00000001 2012-07-31 03:25:22 [16354] [6] DEBUG: dest_addr_npi: 1 = 0x00000001 2012-07-31 03:25:22 [16354] [6] DEBUG: destination_addr: "91XXXXXXXXXX" 2012-07-31 03:25:22 [16354] [6] DEBUG: esm_class: 3 = 0x00000003 2012-07-31 03:25:22 [16354] [6] DEBUG: protocol_id: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: priority_flag: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: schedule_delivery_time: NULL 2012-07-31 03:25:22 [16354] [6] DEBUG: validity_period: NULL 2012-07-31 03:25:22 [16354] [6] DEBUG: registered_delivery: 1 = 0x00000001 2012-07-31 03:25:22 [16354] [6] DEBUG: replace_if_present_flag: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: data_coding: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: sm_default_msg_id: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: sm_length: 21 = 0x00000015 2012-07-31 03:25:22 [16354] [6] DEBUG: short_message: 2012-07-31 03:25:22 [16354] [6] DEBUG: Octet string at 0x2aaaac004a60: 2012-07-31 03:25:22 [16354] [6] DEBUG: len: 21 2012-07-31 03:25:22 [16354] [6] DEBUG: size: 22 2012-07-31 03:25:22 [16354] [6] DEBUG: immutable: 0 2012-07-31 03:25:22 [16354] [6] DEBUG: data: 53 51 4c 42 4f 58 20 54 45 53 54 49 4e 47 20 53 SQLBOX TESTING S 2012-07-31 03:25:22 [16354] [6] DEBUG: data: 45 52 56 45 52 ERVER 2012-07-31 03:25:22 [16354] [6] DEBUG: Octet string dump ends. 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP PDU dump ends. 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP[test]: throughput (1.00,50.00) 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP[test]: throughput (1.00,50.00) 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP[test]: Got PDU: 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP PDU 0x2aaaac004d30 dump: 2012-07-31 03:25:22 [16354] [6] DEBUG: type_name: submit_sm_resp 2012-07-31 03:25:22 [16354] [6] DEBUG: command_id: 2147483652 = 0x80000004 2012-07-31 03:25:22 [16354] [6] DEBUG: command_status: 0 = 0x00000000 2012-07-31 03:25:22 [16354] [6] DEBUG: sequence_number: 265 = 0x00000109 2012-07-31 03:25:22 [16354] [6] DEBUG: message_id: 2012-07-31 03:25:22 [16354] [6] DEBUG: Octet string at 0x2aaaac004a60: 2012-07-31 03:25:22 [16354] [6] DEBUG: len: 36 2012-07-31 03:25:22 [16354] [6] DEBUG: size: 37 2012-07-31 03:25:22 [16354] [6] DEBUG: immutable: 0 2012-07-31 03:25:22 [16354] [6] DEBUG: data: 33 31 64 39 61 33 38 63 2d 31 62 32 65 2d 34 30 31d9a38c-1b2e-40 2012-07-31 03:25:22 [16354] [6] DEBUG: data: 64 36 2d 61 38 33 35 2d 36 66 34 65 39 38 65 35 d6-a835-6f4e98e5 2012-07-31 03:25:22 [16354] [6] DEBUG: data: 62 38 30 39 b809 2012-07-31 03:25:22 [16354] [6] DEBUG: Octet string dump ends. 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP PDU dump ends. 2012-07-31 03:25:22 [16354] [6] DEBUG: DLR[internal]: Adding DLR smsc=test, ts=31d9a38c-1b2e-40d6-a835-6f4e98e5b809, src=test, dst=91XXXXXXXXXX, mask=31, boxc=smsbox-id 2012-07-31 03:25:22 [16354] [6] DEBUG: SMSC[test]: creating DLR message 2012-07-31 03:25:22 [16354] [6] DEBUG: SMSC[test]: DLR = http://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26Bat chID%3Dravi123-5d12d25be2a00b 2012-07-31 03:25:22 [16354] [6] WARNING: Could not route message to smsbox id <smsbox-id>, smsbox is gone! 2012-07-31 03:25:22 [16354] [6] DEBUG: SMPP[test]: throughput (1.00,50.00) 2012-07-31 03:25:22 [16354] [12] DEBUG: send_msg: sending msg to box: <127.0.0.1> On Mon, Jul 30, 2012 at 8:54 PM, Rene Kluwen <[email protected]> wrote: INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id, dlr_mask, dlr_url, boxc_id) VALUES ('MT', 'DEMO', '919XXXXXXXXX', 'SQLBOX TESTING SERVER', 2, 'test', 31, 'http%3A// <http://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26> 10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26 BatchID%3DXXXX123-5d1XXXXXa', 'smsbox-id' ); Where 'smsbox-id' is a random instance of any smsbox that you have connected. From: Ravindra Gupta // Viva [mailto:[email protected]] Sent: Monday, 30 July, 2012 16:43 To: Rene Kluwen Cc: [email protected]; [email protected] Subject: Re: dlr-url call on sqlbox Dear Rene, Can send some sample example. On Mon, Jul 30, 2012 at 8:08 PM, Rene Kluwen <[email protected]> wrote: This is a FAQ. Sqlbox doesn't call dlr-url's, since it's sql based and not http based. The workaround is as follows: Insert as your "boxc_id" the smsbox id of your connected smsbox. == Rene From: [email protected] [mailto:[email protected]] On Behalf Of Ravindra Gupta // Viva Sent: Monday, 30 July, 2012 16:31 To: [email protected]; [email protected] Subject: dlr-url call on sqlbox Dear Team, How to call dlr-url on sqlbox. Kindly find the mysql query as given below. INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id, dlr_mask, dlr_url) VALUES ('MT', 'DEMO', '919XXXXXXXXX', 'SQLBOX TESTING SERVER', 2, 'test', 31, 'http%3A// <http://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26Ba tchID%3DXXXX123-5d1XXXXXa> 10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26 BatchID%3DXXXX123-5d1XXXXXa' );
