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 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
