I have successfully connected kannel to MySQL , and when I start the bearerbox I got the message that it is successfully connected. But I dont understand what is getting stored in database, when I browse the database using phpmyadmin I see nothing there. database name is kannel and table name is dlr and the following fields are defined in the dlr table: smsc ts destination source service url mask status boxc
and below is the configuration file group = core admin-port = 13015 admin-password = **** admin-deny-ip = "*.*.*.*" admin-allow-ip = "" dlr-storage = mysql smsbox-port = 13016 #wdp-interface-name = "*" log-file = "/var/log/kannel/bearerbox.log" box-deny-ip = "*.*.*.*" box-allow-ip = "127.0.0.1" log-level = 1 #group = wapbox #bearerbox-host = localhost #log-file = "/var/log/kannel/wapbox.log" group = smsc smsc = at modemtype = auto device= /dev/ttyUSB0 my-number = ******** connect-allow-ip = 127.0.0.1 log-level = 0 # DLR with MySQL support configuration group = mysql-connection id = mydlr host = localhost username = ****** password = ******* database = ****** group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-source=source field-destination = destination field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc group = modems id = huawei name = "Huawei E220" detect-string = "huawei" init-string = "ATZ" init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" group = smsbox bearerbox-host = ************** sendsms-port = 13017 global-sender = ************* log-level = 0 group = sendsms-user username = ********* password = ********* concatenation= true max-messages = 10
