Try to put the database connection before the sqlbox group. Thanks Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <mecedar...@gmail.com> 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 <sangpr...@gmail.com> 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 <mecedar...@gmail.com> 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'. >>> >>>
