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]> 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> failed2020-04-23
> 10:02:34 [7000] [0] ERROR: System error 111: Connection refused2020-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 =
> coreadmin-port = 13000admin-password = testadmin-deny-ip =
> “*.*.*.*”admin-allow-ip = “127.0.0.1”smsbox-port = 13001box-deny-ip =
> “*.*.*.*”box-allow-ip = “127.0.0.1”dlr-storage = mysqllog-level =
> 0log-file=/home/arun/bearer.loggroup = smsboxsmsbox-id =
> mysmsboxbearerbox-host = localhostsendsms-port = 13013log-level = 1log-file
> =/home/arun/smsbox.loggroup
> =mysql-connectionid=mydlrhost=localhostusername=rootpassword
> =123database=dlrmax-connections=1group=dlr-dbid=mydlrtable=dlrfield-smsc
> =smscfield-timestamp=tsfield-destination =destinationfield-source
> =sourcefield-service=servicefield-url=urlfield-mask=maskfield-status
> =statusfield-boxc-id=boxcgroup = sendsms-userusername = simplepassword =
> simple123group = smscsmsc = fakesmsc-id = FAKEport = 10000log-level =
> 0group = smsbox-routesmsbox-id = mysmsboxsmsc-id = FAKEgroup =
> sms-servicekeyword = default*
> *text = “hi how are you”*
>
> --
> *- Thanks*
> *  Arun*
> *  Mobile : 9448420662*
>
>

-- 
*- Thanks*
*  Arun*
*  Mobile : 9448420662*