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 > ################################################### >
