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 = coreadmin-port = 13000smsbox-port = 13006admin-password = **********status-password = statadmin-deny-ip = "*.*.*.*"admin-allow-ip = "127.0.0.1;192.168.1.*"dlr-storage = mysqllog-file = "/usr/local/etc/tmp/kannel.log"log-level = 0access-log = "/usr/local/etc/tmp/kannel.access"access-log-clean = 0access-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 connectiongroup = mysql-connectionid = mydlrhost = localhostusername = ******password = *******database = dlr_queuemax-connections = 1 # table connectiongroup = dlr-dbid = mydlrtable = dlrfield-smsc = smscfield-timestamp = tsfield-destination = destinationfield-source = sourcefield-service = servicefield-url = urlfield-mask = maskfield-status = statusfield-boxc-id = boxc # SMSC SMPPgroup = smscsmsc = smppsmsc-id = smppidlog-file = "/usr/local/etc/tmp/smpp.log"log-level = 0host = *.*.*.*port = *#receive-port =smsc-username = *******smsc-password = *******transceiver-mode= 1system-type = smpp#address-range = # SMSC Fakegroup = smscsmsc = fakesmsc-id = FAKEport = 13008log-file = "/usr/local/etc/tmp/fake.log"log-level = 0 # SMSBOX SETUP group = smsboxbearerbox-host = localhost#bearerbox-port = 13001#smsbox-id = tariqboxsendsms-port = 13013sendsms-chars = "0123456789 "global-sender = sandoolog-file = "/usr/local/etc/tmp/smsbox.log"log-level = 0access-log = "/usr/local/etc/tmp/smsbox.access"mo-recode = true # SEND-SMS USERS group = sendsms-userusername = *****password = *****name = tardefault-smsc = smppidmax-messages = 5concatenation = true group = sendsms-userusername = kannelpassword = rL4ymax-messages = 5concatenation = true # SMS SERVICE Default# there should be default alwaysgroup = sms-servicekeyword = defaultmax-messages = 5concatenation = truetext = "No service specified" ######################################sqlbox.conf######################################group = sqlboxid = sqlbox-dbsmsbox-id = sqlboxbearerbox-host = localhostbearerbox-port = 13006#smsbox-port = 13001#smsbox-port-ssl = falsesql-log-table = sent_smssql-insert-table = send_smslog-file = "/usr/local/etc/tmp/kannel-sqlbox.log"log-level = 0 group = mysql-connectionid = sqlbox-dbhost = localhostusername = *******password = ********database = kannel_dbmax-connections = 10###################################################
