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%26BatchID%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%26BatchID%3Dravi123-5d12d25be2a00b
2012-07-31 03:25:22 [16354] [6] *WARNING: Could not route message to
smsboxid <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 <rene.klu...@chimit.nl> 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//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:ravin...@vivainfomedia.com]
> Sent: Monday, 30 July, 2012 16:43
> To: Rene Kluwen
> Cc: users-requ...@vm1.kannel.org; us...@vm1.kannel.org
> 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 <rene.klu...@chimit.nl>
> 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: users-boun...@vm1.kannel.org [mailto:users-boun...@vm1.kannel.org]
> On
> Behalf Of Ravindra Gupta // Viva
> Sent: Monday, 30 July, 2012 16:31
> To: users-requ...@vm1.kannel.org; us...@vm1.kannel.org
> 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//10.0.0.1/sms/dlrNEW.
> php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
> BatchID%3DXXXX123-5d1XXXXXa<http://10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
> BatchID%3DXXXX123-5d1XXXXXa>' );
>
>
>
>
