Re: sqlbox looking for mssql connection although mysql installed

 i've been not play with kannel for long, i think there is problem with your kannel package, it looks for mssql(i think sql server) instead on mysql.., you could try latest stable 1.4.5..
    On Monday, 15 October 2018, 2:11:59 AM GMT+7, Cedar Jet <[email protected]> wrote:  
 
 Sure, and you can find the configuration below

group = sqlbox
id = sqlbox-db
smsbox-id = sqlbox
#global-sender = ""
bearerbox-host = localhost
bearerbox-port = 18001
smsbox-port = 18005
smsbox-port-ssl = false
sql-log-table = sent_sms
sql-insert-table = send_sms
log-level = 0
log-file = "/var/log/kannel/sqlbox.log"

# database connection
group = mysql-connection
id = sqlbox-db
host = localhost
username = root
password = root
database = kannel_db
#max-connections = 25  

On Sun, Oct 14, 2018 at 1:48 AM Willy Mularto <[email protected]> wrote:

Share your SQLBox configuration file. Thanks

So Far Express VPN still the fastesthttps://www.expressrefer.com/refer-friend?referrer_id=15939000&utm_campaign=referrals&utm_medium=copy_link&utm_source=referral_dashboard


On Sun, Oct 14, 2018 at 12:35 AM Cedar Jet <[email protected]> wrote:

Hello,

I'm always getting the panic SQLBOX: MSSql: connection settings for id 'sqlbox-db' are not specified! as below 

root@smpp:~# sqlbox -v 0 /etc/kannel/sqlbox.conf
2018-10-13 12:47:37 [1819] [0] INFO: Debug_lvl = 0, log_file = <none>, log_lvl = 0
2018-10-13 12:47:37 [1819] [0] DEBUG: Kannel sqlbox version `1.4.4'.
Compiler `7.2.0'.
System Linux, release 4.15.0-36-generic, version #39-Ubuntu SMP Mon Sep 24 16:19:09 UTC 2018, machine x86_64.
Libxml version 2.9.4.
Using OpenSSL 1.0.2g  1 Mar 2016.
Compiled with MySQL 5.7.20, using MySQL 5.7.23.
Compiled with PostgreSQL 10.0.
Using SQLite 3.20.1.
Using hiredis API 0.13.3
Using native malloc.

2018-10-13 12:47:37 [1819] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0
2018-10-13 12:47:37 [1819] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'.
2018-10-13 12:47:37 [1819] [0] PANIC: SQLBOX: MSSql: connection settings for id 'sqlbox-db' are not specified!
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(gw_backtrace+0xe0) [0x560fc0415990]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(gw_panic+0x167) [0x560fc0415b07]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361) [0x560fc03ff791]
2018-10-13 12:47:37 [1819] [0] PANIC: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7ff01014fb97]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(_start+0x2a) [0x560fc03ffa2a]
root@smpp:~# 2018-10-13 12:47:43 [1716] [1] DEBUG: Timeout for fd:65 appears.
2018-10-13 12:47:43 [1716] [1] DEBUG: HTTP: Destroying HTTPClient area 0x7f9128000d30.
2018-10-13 12:47:43 [1716] [1] DEBUG: HTTP: Destroying HTTPClient for `77.30.145.30'.