Hi Alejandro
You need to store that in your app using dlr info.
dlr table you set up in kannel config is only for internal dlr handling.
Once kannel receives the final status from the smsc for a particular sms,
it will delete its record; that is why this table (w3_sms in your case) is
almost always empty.
Regards
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
On Wed, Oct 14, 2015 at 4:21 PM, Alejandro Mussi <alemu...@gmail.com> wrote:
> Hi all,
>
> I have compiled kannel with mysql support but i still not getting the
> records of DLR in my DB. Here are my conf file and an example for sending a
> sms
>
> What i need is to store in some way the command_status for all
> sequence_number (as i get in bearerbox.log)
>
> Here is how i call the api to send sms and my conf file:
>
>
>
> http://domain:13013/cgi-bin/sendsms?username=kannel&password=XXX&to=595981414XXX&from=1244&text=Hello+world&dlr-mask=31&smsc=tigo
>
>
> # Default kannel configuration file
> group = core
> admin-port = 13000
> admin-password = admin
> status-password = XXXX
> admin-deny-ip = "*.*.*.*"
> admin-allow-ip = "127.0.0.1"
> smsbox-port = 13001
> #wapbox-port = 13002
> box-deny-ip = "*.*.*.*"
> box-allow-ip = "127.0.0.1"
> wdp-interface-name = "*"
> log-file = "/var/log/kannel/bearerbox.log"
> log-level = 0
> sms-resend-retry = 0
>
> group = smsc
> smsc = smpp
> smsc-id = "tigo"
> allowed-smsc-id = "tigo"
> host = XXXXX
> port = 5600
> smsc-username = "XXX"
> smsc-password = "XXX"
> system-type = "VMA"
> address-range = ""
> msg-id-type = 0x01
>
>
> # SMSBOX GROUP
>
> group = smsbox
> bearerbox-host = localhost
> sendsms-port = 13013
> sendsms-chars = "0123456789 +-"
> log-file = "/var/log/kannel/smsbox.log"
> log-level = 0
> access-log = "/var/log/kannel/access.log"
>
> # SMS USER GROUP
>
> group = sendsms-user
> username = kannel
> password = XXXX
> concatenation = true
> max-messages = 3
> max-messages = 10
>
> # SMS SERVICE GROUP
>
> group = sms-service
> keyword = default
> accepted-smsc = "tigo"
> get-url = "
> http://domain/api/smpp.php?binfo=%B&keyword=%k&from=%p&to=%P&sw=%s&text=%a
> "
> accept-x-kannel-headers = true
> max-messages = 3
> concatenation = true
> catch-all = true
> omit-empty = true
> denied-receiver-prefix = 5225;5445;5665;5885;1242;5555;1236;1237
>
> group = mysql-connection
> id = mydlr
> host = localhost
> username = w3_sms
> password = XXX
> database = w3_sms
> max-connections = 1
>
> group = dlr-db
> id = mydlr
> table = dlr
> field-smsc = smsc
> field-timestamp = ts
> field-destination = destination
> field-source = source
> field-service = service
> field-url = url
> field-mask = mask
> field-status = status
> field-boxc-id = boxc
>
> Thanks for the support
>
>
> --
> ---------------------------------------------------------
> Alejandro Mussi Campos Cervera
>
