smsbox - sqlbox - bearerbox & dlr status

spameden spameden at gmail.com
Tue Mar 22 16:27:42 CET 2016


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 <jape at 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 <jape at 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
> >>
> >>
> >>
> >
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.kannel.org/pipermail/users/attachments/20160322/3bb41716/attachment-0001.html>


More information about the users mailing list