thanks Bruno for your reply,i've already done that, and yes i insert records
into send_sms table and DLR reports returns back from my provider and inserted
into kannel.access logfile.but the problem is that sqlbox delete the records
from dlr-db (dlr queue) and do not insert them into sent_sms table, i dont
know why?!note that when i send a little amount of SMS's every thing work
correctly and DLR inserted into sent_sms table.any help please.
--- On Thu, 5/6/10, Bruno Rey <tha...@gmail.com> wrote:
From: Bruno Rey <tha...@gmail.com>
Subject: Re: sqlbox and dlr problem
To: users@kannel.org
Cc: "tariq sand" <tariqsan...@yahoo.com>, techni...@telemox.com
Date: Thursday, May 6, 2010, 5:44 AM
Are you inserting the messages via SQL?
To get a DLR report you must ask for it by setting the DLR-MASK field.
Are you doing this? Try setting it to 31 for example (this will give
all the reports).
On 6 May 2010 08:36, tariq sand <tariqsan...@yahoo.com> wrote:
>
> Dear All,
> I've configured kannel with sqlbox,and it works fine, but when i send a huge
> amount of SMS's (more than 1000) DLR received and installed in kannel.access
> file but sqlbox do not insert them into sent_sms table, so i can't update my
> sms interface DB with dlr reports selected from sent_sms table.
> please advise your recommendations.
> kindly, take a look on my configuration files.
> thanks in advance.
> Tariq Sando
> ####################################
> kannel.conf
> #####################################
> group = core
> admin-port = 13000
> smsbox-port = 13006
> admin-password = **********
> status-password = stat
> admin-deny-ip = "*.*.*.*"
> admin-allow-ip = "127.0.0.1;192.168.1.*"
> dlr-storage = mysql
> log-file = "/usr/local/etc/tmp/kannel.log"
> log-level = 0
> access-log = "/usr/local/etc/tmp/kannel.access"
> access-log-clean = 0
> access-log-format = "%t %l [SMSC:%i] [SVC:%n] [ACT:%A] [BINF:%B] [FID:%F]
> [KID:%I] [from:%p] [to:%P] [flags:%m:%c:%M:%C:%d] [msg:%L:%b] [udh:%U:%u]"
> store-file = "/usr/local/etc/tmp/kannell.store"
> #db connection
> group = mysql-connection
> id = mydlr
> host = localhost
> username = ******
> password = *******
> database = dlr_queue
> max-connections = 1
> # table connection
> 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
> # SMSC SMPP
> group = smsc
> smsc = smpp
> smsc-id = smppid
> log-file = "/usr/local/etc/tmp/smpp.log"
> log-level = 0
> host = *.*.*.*
> port = *
> #receive-port =
> smsc-username = *******
> smsc-password = *******
> transceiver-mode= 1
> system-type = smpp
> #address-range =
> # SMSC Fake
> group = smsc
> smsc = fake
> smsc-id = FAKE
> port = 13008
> log-file = "/usr/local/etc/tmp/fake.log"
> log-level = 0
> # SMSBOX SETUP
> group = smsbox
> bearerbox-host = localhost
> #bearerbox-port = 13001
> #smsbox-id = tariqbox
> sendsms-port = 13013
> sendsms-chars = "0123456789 "
> global-sender = sandoo
> log-file = "/usr/local/etc/tmp/smsbox.log"
> log-level = 0
> access-log = "/usr/local/etc/tmp/smsbox.access"
> mo-recode = true
> # SEND-SMS USERS
> group = sendsms-user
> username = *****
> password = *****
> name = tar
> default-smsc = smppid
> max-messages = 5
> concatenation = true
> group = sendsms-user
> username = kannel
> password = rL4y
> max-messages = 5
> concatenation = true
> # SMS SERVICE Default
> # there should be default always
> group = sms-service
> keyword = default
> max-messages = 5
> concatenation = true
> text = "No service specified"
> ######################################
> sqlbox.conf
> ######################################
> group = sqlbox
> id = sqlbox-db
> smsbox-id = sqlbox
> bearerbox-host = localhost
> bearerbox-port = 13006
> #smsbox-port = 13001
> #smsbox-port-ssl = false
> sql-log-table = sent_sms
> sql-insert-table = send_sms
> log-file = "/usr/local/etc/tmp/kannel-sqlbox.log"
> log-level = 0
> group = mysql-connection
> id = sqlbox-db
> host = localhost
> username = *******
> password = ********
> database = kannel_db
> max-connections = 10
> ###################################################
>
