If you set an smsbox-Id then you need to have a proper routing to the box (or not ser one of this is your only box besides bearer box)
-- Alejandro Guerrieri > On Jan 1, 2019, at 12:41 AM, <xkb.surf...@gmail.com> <xkb.surf...@gmail.com> > wrote: > > 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>: > 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
