Hi,

I am able to send sms using sqlbox and able to receive dlr reports also.
But, these reports do not go in the table that i specify. Instead, the
reports are stored in sent_sms table. Below is my configuration:

Kannel.conf
------------------

group = core
admin-port = 13000
smsbox-port = 13001
admin-password = bar
dlr-storage = mysql


group = smsbox
bearerbox-host = 127.0.0.1
sendsms-port = 13013
global-sender = 13013


group = sendsms-user
username = tester
password = foobar


group = sms-service
keyword = nop
text = "You asked nothing and I did it!"


group = smsc
smsc = smpp
smsc-id = server1
host = smpp0.net
port = 8000
transceiver-mode = true
throughput = 10
smsc-username = **********
smsc-password = **********


group = sendsms-user
username = tester
password = foobar
forced-smsc = server1
name = users
#user-deny-ip = "*.*.*.*"
user-allow-ip = "*.*.*.*"
max-messages = 3
concatenation = 1
omit-empty = 1


group = mysql-connection
id = mydlr
host = localhost
username = root
password = root
database = kannel


group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-source=source
field-destination = destination
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc


------------------------------
---------------------------------------------

sqlbox.conf
------------------

group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13005
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms



# MYSQL Connection
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = root
database = kannel

---------------------------------------------------------------------------

The sms are sent successfully from send_sms and transferred to the table
sent_sms but the delivery reports are also stored in the same table and the
dlr table is always empty.

If anyone has come accross this problem, please help me.

Reply via email to