Re: sqlbox looking for mssql connection although mysql installed

Try to put the database connection before the sqlbox group. Thanks

Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <[email protected]>
menulis:

> 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'.
>>>
>>>