The mysql user has rights to delete rows
_sqlbox.log_
009-01-23 09:11:32 [4825] [297] DEBUG: Thread 297 (sqlbox.c:function)
maps to pid 4825.
2009-01-23 09:11:32 [4825] [297] INFO: Client connected from <127.0.0.1>
2009-01-23 09:11:32 [4825] [297] INFO: Connected to bearerbox at
localhost port 13003.
2009-01-23 09:11:32 [4825] [297] DEBUG: Started thread 298
(sqlbox.c:bearerbox_to_smsbox)
2009-01-23 09:11:32 [4825] [297] DEBUG: smsbox_to_bearerbox: got boxc_id
<smsbox> from <127.0.0.1>
2009-01-23 09:11:32 [4825] [297] DEBUG: smsbox_to_bearerbox: sms received
2009-01-23 09:11:32 [4825] [298] DEBUG: Thread 298
(sqlbox.c:bearerbox_to_smsbox) maps to pid 4825.
2009-01-23 09:11:33 [4825] [0] DEBUG: Started thread 299 (sqlbox.c:function)
2009-01-23 09:11:33 [4825] [299] DEBUG: Thread 299 (sqlbox.c:function)
maps to pid 4825.
2009-01-23 09:11:33 [4825] [299] INFO: Client connected from <127.0.0.1>
2009-01-23 09:11:33 [4825] [299] INFO: Connected to bearerbox at
localhost port 13003.
2009-01-23 09:11:33 [4825] [299] DEBUG: Started thread 300
(sqlbox.c:bearerbox_to_smsbox)
2009-01-23 09:11:33 [4825] [299] DEBUG: smsbox_to_bearerbox: got boxc_id
<smsbox> from <127.0.0.1>
2009-01-23 09:11:33 [4825] [299] DEBUG: smsbox_to_bearerbox: sms received
2009-01-23 09:11:33 [4825] [300] DEBUG: Thread 300
(sqlbox.c:bearerbox_to_smsbox) maps to pid 4825.
2009-01-23 09:11:34 [4825] [0] DEBUG: Started thread 301
(sqlbox.c:function)009-01-23 09:11:32 [4825] [297] DEBUG: Thread 297
(sqlbox.c:function) maps to pid 4825.
2009-01-23 09:11:32 [4825] [297] INFO: Client connected from <127.0.0.1>
2009-01-23 09:11:32 [4825] [297] INFO: Connected to bearerbox at
localhost port 13003.
2009-01-23 09:11:32 [4825] [297] DEBUG: Started thread 298
(sqlbox.c:bearerbox_to_smsbox)
2009-01-23 09:11:32 [4825] [297] DEBUG: smsbox_to_bearerbox: got boxc_id
<smsbox> from <127.0.0.1>
2009-01-23 09:11:32 [4825] [297] DEBUG: smsbox_to_bearerbox: sms received
2009-01-23 09:11:32 [4825] [298] DEBUG: Thread 298
(sqlbox.c:bearerbox_to_smsbox) maps to pid 4825.
2009-01-23 09:11:33 [4825] [0] DEBUG: Started thread 299 (sqlbox.c:function)
2009-01-23 09:11:33 [4825] [299] DEBUG: Thread 299 (sqlbox.c:function)
maps to pid 4825.
2009-01-23 09:11:33 [4825] [299] INFO: Client con...................
Cezary Siwek wrote:
does your mysql user have rights to DELETE rows?
What is in the sqlbox.log ?
----- Original Message -----
*From:* James Mutuku <mailto:[email protected]>
*To:* [email protected] <mailto:[email protected]>
*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
_
_
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 3806 (20090128) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
begin:vcard
fn:James Mutuku
n:Mutuku;James
org:Agile Systems Limited;Technical Department
adr:;;P.O Box 55686-00200;Nairobi;Kenya;00200;Kenya
email;internet:[email protected]
title:Lead Consultant
tel;work:+254-722-490994
tel;home:+254-722-490994
tel;cell:+254-722-490994
note;quoted-printable:This email may be confidential. Any distribution, use or copying of thise=
mail or the information it contains by other than an intended recipientsi=
s unauthorized. If you received this email in error, please advise me(byr=
eturn email or otherwise) immediately.=0D=0A=
=0D=0A=
Ce courriel est confidentiel. Toute diffusion, utilisation ou copie decem=
essage ou des renseignements qu'il contient par une personne autrequelesd=
estinataires d=C3=A9sign=C3=A9s est interdite. Si vous recevezcecourriel=
par erreur, veuillez m'en aviser imm=C3=A9diatement, par retourde courri=
el ou par un autre moyen. =
=0D=0A=
=0D=0A=
Este mensaje es confidencial. Cualquier distribuci=C3=B3n, uso o copiadel=
mensaje o de la informaci=C3=B3n en el contenido por otras personasdistin=
tas de los destinatarios esta prohibida. Si usted recibe este mensajepore=
rror, por favor comun=C3=ADquemelo inmediatamente mediante reenv=C3=ADode=
l mensaje o por otro medio.=0D=0A=
=0D=0A=
url:www.agile.co.ke, mutuku.wordpress.com
version:2.1
end:vcard
