Hi Kannel uses mysql for storing sms temporarily and delete the record after confirmation it has been sent. That is why you usually does not see anything of your kannel table.
If you do want to have a permanent store of that data, as well as sms status,, you need to do it at your app side or use sqlbox. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le dim. 30 déc. 2018 à 16:39, <xkb.surf...@gmail.com> a écrit : > Hi All, > > > > I have installed mysql and created database and tables on the same server > as Kannel. Also, according to the documents I have put the configuration > section to kannel config. Then I tested sending and receiving message using > FAKE SMSC, but Kannel didn’t insert delivery records to MySQL databased. > > > > The configuration section I put into kannel.conf is: > > > > group = core > > admin-port = 13130 > > smsbox-port = 13131 > > admin-password = italksms > > status-password = italksms > > admin-deny-ip = "*.*.*.*" > > admin-allow-ip = "127.0.0.1" > > log-file = "/var/log/kannel/kannel.log" > > log-level = 0 > > box-deny-ip = "*.*.*.*" > > box-allow-ip = "127.0.0.1" > > access-log = "/var/log/kannel/kannel.access.log" > > dlr-storage = mysql > > > > group = mysql-connection > > id = mydlr > > host = localhost > > username = kannel > > password = kannel > > database = kannel > > # 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 > > > > Did I miss steps somewhere? > > > > Thank you. > > Henry >