RE: Kannel Won't Insert Message Delivery Record to MySQL

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 <[email protected]> 
Sent: Monday, December 31, 2018 6:51 PM
To: Alvaro Cornejo <[email protected]>
Cc: [email protected]; users <[email protected]>
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 <[email protected] <mailto:[email protected]> >:

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, <[email protected] <mailto:[email protected]> > 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