Re: sqlbox looking for mssql connection although mysql installed

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 fastest
>
> https://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'.
>>
>>