does your mysql user have rights to DELETE rows?
What is in the sqlbox.log ?
----- Original Message -----
From: James Mutuku
To: users@kannel.org
Sent: Wednesday, January 28, 2009 3:00 PM
Subject: multiple sms in sent_sms after inserting single sms in sendsms
Hello,
I am using kannel-snapshot 1.4.1 and sqlbox running on centos. My setup is
kannel and SMPPsim simulator. The problem is when I insert a single sms in the
send_sms table, I get 151 similar records in sent_sms table.
Below is my insert code, kannel.conf and sqlbox.conf.
What could be the problem?
Insert code
$sql="INSERT INTO send_sms (`momt`, `sender`, `receiver`, `msgdata`,
`sms_type`) VALUES ('$momt', '$sender', '$receiver', '$msgdata', '$sms_type')"
Kannel conf
# Default kannel configuration file
group = core
admin-port = 13000
admin-password = root
status-password = root
#admin-deny-ip = "*.*.*.*"
admin-allow-ip = "127.0.0.1, 10.2.2.13,192.168.171.99,192.168.171.88,*.*.*.*"
smsbox-port = 13001
#wapbox-port = 13002
#box-deny-ip = "*.*.*.*"
box-allow-ip = "*.*.*.*"
wdp-interface-name = "*"
log-file = "/var/log/kannel/bearerbox.log"
store-file = "/var/log/kannel/kannel.store"
access-log = "/var/log/kannel/access.log"
log-level = 0
dlr-storage=mysql
# SMSBOX SETUP
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
sendsms-chars = "0123456789 +-"
global-sender = 12345
log-file = "/var/log/kannel/smsbox.log"
log-level = 0
#access-log = "access.log"
#white-list =
#black-list =
#reply-couldnotfetch =
#reply-couldnotrepresent =
#reply-requestfailed =
#reply-emptymessage =
# SENDSMS USERS SETUP
group = sendsms-user
username = root
password = root
# DLR SETUP
#mysql connection
group = mysql-connection
id = mydlr
host = localhost
username = root
password = ""
database = dlr
max-connections = 10
group = dlr-db
id = mydlr
table=sms
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 Fake
group = smsc
smsc = fake
port = 10000
#connect-allow-ip = 127.0.0.1
# SMSC SMPP
group = smsc
smsc = smpp
smsc-id = SMPPSim
validityperiod = 30
host = 192.168.100.2
port = 2775
#receive-port = 2775
smsc-username = smppclient
smsc-password = password
system-type = ""
address-range = ""
# SMS SERVICE Default
# there should be default always
group = sms-service
keyword = default
text = "No service specified. "
sqlbox conf
group = sqlbox
id = sqlbox-db
smsbox-id = smsbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13003
smsbox-port = 13003
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/sqlbox.log"
log-level = 0
#white-list = ""
#black-list = ""
#white-list-regex = ""
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = ""
database = agilesms
max-connections = 1
