RE: Adding dlr-storage = mysql , SMSBOX throws error , Connection Refused to Bearerbox

If you post your bearerbox log files, maybe it will give a hint about why it doesn’t want to start.

 

== Rene

 

Van: users <[email protected]> Namens Arun
Verzonden: donderdag 23 april 2020 16:39
Aan: [email protected]
Onderwerp: Re: Adding dlr-storage = mysql , SMSBOX throws error , Connection Refused to Bearerbox

 

Another observation

when dlr-storage =mysql

 

netstat -lnptu  doesnt show up  bearerbox ports

 

kindly enlighten me please

 

On Thu, Apr 23, 2020 at 12:31 PM Arun <[email protected] <mailto:[email protected]> > wrote:

hi all 

 

Below is my Kannel.conf

I want to store Dlr Messages in MySql

When I add  dlr-storage = mysql  to core Group and start smsbox I get the following error ( Without dlr-storage=mysql works fine)

 

0:02:34 [7000] [0] ERROR: connect to <127.0.0.1> failed
2020-04-23 10:02:34 [7000] [0] ERROR: System error 111: Connection refused
2020-04-23 10:02:34 [7000] [0] ERROR: error connecting to server `localhost' at port `13001'
2020-04-23 10:02:34 [7000] [0] PANIC: Couldn't connect to the bearerbox.
2020-04-23 10:02:34 [7000] [0] PANIC: smsbox(gw_backtrace+0xf0) [0x560fad58c250]
2020-04-23 10:02:34 [7000] [0] PANIC: smsbox(gw_panic+0x167) [0x560fad58c3c7]
2020-04-23 10:02:34 [7000] [0] PANIC: smsbox(main+0xea7) [0x560fad557c07]
2020-04-23 10:02:34 [7000] [0] PANIC: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f90da4341e3]
2020-04-23 10:02:34 [7000] [0] PANIC: smsbox(_start+0x2e) [0x560fad55868e]


  **********  ********** ********** ********** ********** ********** ******** 
*********KANNEL.conf *****************************************
group = core
admin-port = 13000
admin-password = test
admin-deny-ip = “*.*.*.*”
admin-allow-ip = “127.0.0.1”
smsbox-port = 13001
box-deny-ip = “*.*.*.*”
box-allow-ip = “127.0.0.1”
dlr-storage = mysql
log-level = 0
log-file=/home/arun/bearer.log


group = smsbox
smsbox-id = mysmsbox
bearerbox-host = localhost
sendsms-port = 13013
log-level = 1
log-file =/home/arun/smsbox.log

group =mysql-connection
id=mydlr
host=localhost
username=root
password =123
database=dlr
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

group = sendsms-user
username = simple
password = simple123

group = smsc
smsc = fake
smsc-id = FAKE
port = 10000
log-level = 0

group = smsbox-route
smsbox-id = mysmsbox
smsc-id = FAKE

group = sms-service
keyword = default

text = “hi how are you”

 

-- 

- Thanks

  Arun

  Mobile : 9448420662

 




 

-- 

- Thanks

  Arun

  Mobile : 9448420662