To achieve this you need to put smsbox in between of the sqlbox and
bearerbox or enforce smsbox id into boxc_id field, i.e.:
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask,
dlr_url, boxc_id) VALUES ('MT', '1234', '919067184864', 'Abbe russshuuuu',
2, 31, 'http://192.168.111.151:8085/Kannel_Test/Receive_dlr', 'smsbox_id');
2013/6/10 testn4n1 <[email protected]>
> i am trying to send sms by inserting data into send_sms table and want to
> process dlrs with script using dlr_url. So, i have changed the
> configuration to the following but i cannot receive anything in my
> application:
>
>
> group = sendsms-user
> username = tester
> password = foobar
> forced-smsc = smpp-nexmo
> name = users
> dlr-url = http://192.168.111.151:8085/Kannel_Test/Receive_dlr
>
> #user-deny-ip = "*.*.*.*"
> user-allow-ip = "*.*.*.*"
> max-messages = 3
> concatenation = 1
> omit-empty = 1
>
>
> I am executing the following query for inserting the data:
>
> INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask,
> dlr_url) VALUES ('MT', '1234', '919067184864', 'Abbe russshuuuu', 2, 31, '
> http://192.168.111.151:8085/Kannel_Test/Receive_dlr');
>
> The dlr is not routed to my specified url. Can you please tell me what is
> wrong here?
>
> Regards,
> James
>
>
>
>
> On 10 June 2013 17:06, spameden <[email protected]> wrote:
>
>> 2013/6/10 testn4n1 <[email protected]>
>>
>>> ok...but then why are there entries in my sent_sms table like the
>>> following:
>>>
>>> 12 | DLR | 1234 | 919067184864 | NULL |
>>> id%3A288230376265477711+sub%3A001+dlvrd%3A001+submit+date%3A1306061034+done+date%3A1306060504+stat%3ADELIVRD+err%3A000+text%3Anone++++++++++++++++
>>> | 1370495099 | smpp-nexmo | NULL | 51dc0ffb | NULL | 3 | NULL |
>>> NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL
>>> | NULL | NULL | NULL | sqlbox | NULL | ?smpp?dlr_err=000& |
>>>
>>> what are the other ways to handle dlr instead of modifying the source?
>>
>>
>> because sqlbox moves everything into sent_sms table.
>>
>> you can process DLRs with a script supplied to dlr_url
>>
>> but it would be easier and more proper to modify sqlbox code to store
>> where you want them.
>>
>>
>>
>>>
>>>
>>> On 10 June 2013 16:55, spameden <[email protected]> wrote:
>>>
>>>> dlr table only used to track which messages are awaiting reports
>>>>
>>>> you need to modify sqlbox source if you need to store DLR entries
>>>> separately
>>>>
>>>>
>>>> 2013/6/10 testn4n1 <[email protected]>
>>>>
>>>>> Hi,
>>>>>
>>>>> I am able to send sms using sqlbox and able to receive dlr reports
>>>>> also. But, these reports do not go in the table that i specify. Instead,
>>>>> the reports are stored in sent_sms table. Below is my configuration:
>>>>>
>>>>> Kannel.conf
>>>>> ------------------
>>>>>
>>>>> group = core
>>>>> admin-port = 13000
>>>>> smsbox-port = 13001
>>>>> admin-password = bar
>>>>> dlr-storage = mysql
>>>>>
>>>>>
>>>>> group = smsbox
>>>>> bearerbox-host = 127.0.0.1
>>>>> sendsms-port = 13013
>>>>> global-sender = 13013
>>>>>
>>>>>
>>>>> group = sendsms-user
>>>>> username = tester
>>>>> password = foobar
>>>>>
>>>>>
>>>>> group = sms-service
>>>>> keyword = nop
>>>>> text = "You asked nothing and I did it!"
>>>>>
>>>>>
>>>>> group = smsc
>>>>> smsc = smpp
>>>>> smsc-id = server1
>>>>> host = smpp0.net
>>>>> port = 8000
>>>>> transceiver-mode = true
>>>>> throughput = 10
>>>>> smsc-username = **********
>>>>> smsc-password = **********
>>>>>
>>>>>
>>>>> group = sendsms-user
>>>>> username = tester
>>>>> password = foobar
>>>>> forced-smsc = server1
>>>>> name = users
>>>>> #user-deny-ip = "*.*.*.*"
>>>>> user-allow-ip = "*.*.*.*"
>>>>> max-messages = 3
>>>>> concatenation = 1
>>>>> omit-empty = 1
>>>>>
>>>>>
>>>>> group = mysql-connection
>>>>> id = mydlr
>>>>> host = localhost
>>>>> username = root
>>>>> password = root
>>>>> database = kannel
>>>>>
>>>>>
>>>>> group = dlr-db
>>>>> id = mydlr
>>>>> table = dlr
>>>>> field-smsc = smsc
>>>>> field-timestamp = ts
>>>>> field-source=source
>>>>> field-destination = destination
>>>>> field-service = service
>>>>> field-url = url
>>>>> field-mask = mask
>>>>> field-status = status
>>>>> field-boxc-id = boxc
>>>>>
>>>>>
>>>>> ------------------------------
>>>>> ---------------------------------------------
>>>>>
>>>>> sqlbox.conf
>>>>> ------------------
>>>>>
>>>>> group = sqlbox
>>>>> id = sqlbox-db
>>>>> smsbox-id = sqlbox
>>>>> bearerbox-host = localhost
>>>>> bearerbox-port = 13001
>>>>> smsbox-port = 13005
>>>>> smsbox-port-ssl = false
>>>>> sql-log-table = sent_sms
>>>>> sql-insert-table = send_sms
>>>>>
>>>>>
>>>>>
>>>>> # MYSQL Connection
>>>>> group = mysql-connection
>>>>> id = sqlbox-db
>>>>> host = localhost
>>>>> username = root
>>>>> password = root
>>>>> database = kannel
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------------
>>>>>
>>>>> The sms are sent successfully from send_sms and transferred to the
>>>>> table sent_sms but the delivery reports are also stored in the same table
>>>>> and the dlr table is always empty.
>>>>>
>>>>> If anyone has come accross this problem, please help me.
>>>>>
>>>>
>>>>
>>>
>>
>
