Hi Alvaro and Spameden,
Thanks for your information. I installed sqlbox. The table send_sms and sent_sms were created automatically to mysql database. But there are still no records in the table. Here’s the sqlbox configuration. group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 13130 smsbox-port = 13135 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 = "" # Database connection examples. Please uncomment as needed # Example MYSQL Connection group = mysql-connection id = sqlbox-db host = localhost username = kannel password = kannel database = kannel The bearerbox-port is the same port as admin-port in kannel.conf. The smsbox-port is just a random number not being used. Is there anything wrong.? Thank you, Henry From: spameden <spame...@gmail.com> Sent: Monday, December 31, 2018 6:51 PM To: Alvaro Cornejo <cornejo.alv...@gmail.com> Cc: xkb.surf...@gmail.com; users <users@kannel.org> Subject: Re: Kannel Won't Insert Message Delivery Record to MySQL You need to use sqlbox plugin in order to store saved MT/MO/DLR or implement the logic of saving those in your app. Exactly, what Alvaro has said. пн, 31 дек. 2018 г. в 17:33, Alvaro Cornejo <cornejo.alv...@gmail.com <mailto:cornejo.alv...@gmail.com> >: 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 <http://www.perusms.com> Le dim. 30 déc. 2018 à 16:39, <xkb.surf...@gmail.com <mailto: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
