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

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