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

[xkb.surfing]

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  
Sent: Monday, December 31, 2018 6:51 PM
To: Alvaro Cornejo 
Cc: xkb.surf...@gmail.com; users 
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 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   

 

 

Le dim. 30 déc. 2018 à 16:39, 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

Kannel Won't Insert Message Delivery Record to MySQL

[xkb.surfing]

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