SQLBOX doesnt store SMS in database

[hans joachim]

Hello,

 

I want SQLBOX to store information about every outgoing sms in the database. I send my SMS via HTTP-Call like  "http://xxx.xxx.xxx.xx:xxxxx/cgi-bin/sendsms?username=user&password=pass&from=1234566&to=123456789&text=test" but no information is stored in my database.

 

SQLBOX connects and created the tables (send_sms & sent_sms). I see the SQLBOX in the Kannel-Webinterface too.

 

Can you please help me to find the error ?

 

KANNEL.CONF

 

# MAIN CONFIG
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = 123
access-log = "/var/log/kannel/sms-trace.log"
access-log-clean = true
access-log-format= "SMS ID="%F" TS="%t" TYPE="%l" SMSC="%i" FROM="%p" TO="%P" ENCODING="%c" TEXT="%b" UDH="%u""
log-file = "/var/log/kannel/bearerbox.log"
log-level = 0

 

#Fake SMSC for Testing
#group = smsc
#smsc = fake
#smsc-id = Fake smsc
#port = 13009

#connect-allow-ip = 127.0.0.1

 

# GSM-MODEM 1 
group = smsc
smsc = at
smsc-id = GSM1
modemtype = auto 
device = /dev/ttyS0
sim-buffering = true
log-file= "/var/log/kannel/smsc.log"
log-level=0

 

# HEX HTTP-API
group = smsc
smsc = http
smsc-id = HEX
system-type = generic
port = 13004
send-url = ""> status-success-regex = "ok"
log-file = "/var/log/kannel/hex.log"

 

group = modems
id = SIEMENS MC35i 
name = "Siemens MC35i"
detect-string = "SIEMENS"
detect-string2 = "MC35i"
init-string = "AT+CPMS="SM""
speed = 19200

group = smsbox

 

smsbox-id = smsbox1
bearerbox-host = localhost
sendsms-port = 13003
log-file= "/var/log/kannel/smsbox.log"

 

group = sendsms-user
username = user1
password = pass1

 

 

SQLBOX.CONF:

 

group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox1
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13010
#smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-file = "/var/log/kannel/sqlbox.log"
log-level = 0
#ssl-client-certkey-file = ""
#ssl-server-cert-file = ""
#ssl-server-key-file = ""
#ssl-trusted-ca-file = ""

 

# Database connection examples. Please uncomment as needed

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