Hi,
Kannel doesn't work with a DB. You can use sqlbox in-between to insert sent
SMS, but you will have to parse access log to get received SMS to a DB.
BR,
Nikos
----- Original Message -----
From: [email protected]
To: [email protected]
Sent: Tuesday, October 05, 2010 2:24 PM
Subject: mysql with kannel
Suppose you start up kannel with mysql successfully what is required for me
to make the external storage engine to store the send and received messages
with respect to my configuration files below
smskannel configuration
group = core
admin-port = 13000
smsbox-port = 13001
admin-password = camcom
status-password = camcom
#admin-deny-ip = ""
#admin-allow-ip = ""
#log-file = "/tmp/kannel.log"
#log-level = 0
box-deny-ip = "*.*.*.*"
box-allow-ip = "127.0.0.1"
#unified-prefix = "+358,00358,0;+,00"
#access-log = "/tmp/access.log"
#store-file = "kannel.store"
#ssl-server-cert-file = "cert.pem"
#ssl-server-key-file = "key.pem"
#ssl-certkey-file = "mycertandprivkeyfile.pem"
dlr-storage = mysql
#group = smsc
#smsc = fake
#smsc-id = FAKE
#port = 20000
#connect-allow-ip = 127.0.0.1
group = smsc
smsc = at
modemtype = auto
device = /dev/ttyUSB0
my-number = 0888959802
log-level = 0
sim-buffering = true
group = smsbox
bearerbox-host = localhost
sendsms-port = 13013
sendsms-chars = "0123456789"
global-sender = "0888959802"
access-log = "/home/camcom/kannel.access"
log-file = "/home/camcom/smsbox.log"
log-level = 0
#sendsms-chars = "0123456789 +-"
#log-file = "/tmp/smsbox.log"
#access-log = "/tmp/access.log"
group = sendsms-user
username = camcom
password = camcom
max-messages = 2
concatenation = true
group = sms-service
keyword = default
#text = "You asked nothing and I did it!"
get-url =
"http://127.0.0.1:80/var/www/html/receive.php?msg=%a&time=%t&sender=%p";
max-messages = 1
concatenation = true
#group = sms-service
#keyword = default
#text = "No service specified"
group = mysql-connection
id = mydlr
host = localhost
username = root
password = camcom
database = dlr
# max count of connections that will be opened for dbpool
#default is 1
#max-connections = 1
group = dlr-db
id = mydlr
table = dlr
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
group = modems
id = huawei_e160
name = "huawei_e160"
detect-string = "huawei"
init-string = "ATZ"
init-string = "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"
init-string = "AT+CNMI= 2,0,0,2,0"
message-storage = sm
speed = 9600
sqlbox configuration
group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 13001
smsbox-port = 13005
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
#log-file = "/var/log/kannel/kannel-sqlbox.log"
log-level = 0
#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 = camcom
database = dlr
max-connections = 1
