Also have a read: http://www.kannel.org/pipermail/users/2013-August/020120.html
2016-03-22 18:27 GMT+03:00 spameden <spame...@gmail.com>: > ok, personally I'm using option 2 without any dlr.php or any other sort of > scripts, so I end up with MT records in database with status field where > field is filled with resulting status. > > Here are couple of ways to resolve what you need: > > 1. Set up trigger (as Rene already suggested) to update tables you need > or update records in sent_sms based on the information coming from the DLR > from > your upstream SMSC operators. > > 2. Modify sent_sms table, add status column and modify sqlbox code to > UPDATE MT records right after DLR comes to the kannel setting the status > from dlr_mask. I'd also suggest auto-generating dlr_url based on the > current time so you would match correct entry. > > 3. You can use sqlbox with smsbox and set up a dlr_url hook to the > external script. > > > >How do I implement DLR status? Is my only option to archive this to create > >a script that writes delivery status to my sent_sms table? If so, how to > >add an ID that is stored to db? > > For this there is dlr_url field or dlr_url GET variable in sendsms query. > For delivery script handling examples please search mailing lists or make > yourself one (there is some examples in documentation I believe). > > 2016-03-22 17:53 GMT+03:00 <j...@evonet.fi>: > >> Actually I can't >> All I find is notes to check kannel.org. And I cannot figure out how to >> do >> this on those documents? As you said its been raised many times, is the >> documentation good? If this sis just trivial thing how the hell I am so >> stupid I cannot understand. >> >> thanx for your help >> >> >> >> > This question has been raised too many times. Can you search a bit on >> > mailing lists? >> > >> > There are multiple solutions out there for your issue. >> > >> > 2016-03-22 17:18 GMT+03:00 <j...@evonet.fi>: >> > >> >> Hi >> >> >> >> I have working setup that sends sms messages just fine. Message is >> >> copied >> >> to sent_sms table as expected. >> >> >> >> How do I implement DLR status? Is my only option to archive this to >> >> create >> >> a script that writes delivery status to my sent_sms table? If so, how >> to >> >> add an ID that is stored to db? in case I use smsbox's http interface >> to >> >> receive user data. >> >> >> >> Or can I configure sqlbox to do this for me? Some discussion left an >> >> impression to me, that this is possible, but I can't find >> documentation >> >> from kannel.org that helps me with this. >> >> >> >> If sqlbox can do it great, if not I think it's bit useless sw. >> >> >> >> and as an extra option how to configure sqlbox to save incoming sms:s >> to >> >> database? is it possible? and is there a way to use database to >> >> configure >> >> incoming sms rules, so that sql box would do the tricks... >> >> >> >> thx, Jarno >> >> >> >> -- kannel.conf >> >> group = core >> >> admin-port = 13000 >> >> admin-password = <changed> >> >> admin-deny-ip = "192.168.100.1" # deny outside gw >> >> admin-allow-ip = "127.0.0.*;192.*.*.*" >> >> smsbox-port = 15001 >> >> log-file = "/var/log/kannel/bearerbox.log" >> >> box-deny-ip = "*.*.*.*" >> >> box-allow-ip = "127.0.0.1" >> >> >> >> group = smsbox >> >> bearerbox-host = 127.0.0.1 >> >> bearerbox-port = 15002 >> >> sendsms-port = 15015 >> >> global-sender = "SERVICE_PROVIDER" >> >> log-level = 0 >> >> log-file = "/var/log/kannel/smsbox.log" >> >> >> >> + incoming message groups >> >> >> >> --sqlbox.conf-- >> >> group = sqlbox >> >> id = sqlbox-db >> >> smsbox-id = sqlbox >> >> bearerbox-host = localhost >> >> bearerbox-port = 15001 >> >> smsbox-port = 15002 >> >> smsbox-port-ssl = false >> >> sql-log-table = sent_sms >> >> sql-insert-table = send_sms >> >> log-file = "/var/log/kannel/kannel-sqlbox.log" >> >> log-level = 0 >> >> >> >> + mysql configuration >> >> >> >> >> >> >> > >> >> >> >
