What version do you use? Also how do you initiate the SQLBox? 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 Mon, Oct 15, 2018 at 10:38 AM Cedar Jet <mecedar...@gmail.com> wrote: > I tried what Willy Suggest with the same result. I saw some posts saying > that we should compile sqlbox with mysql, for that reason I'm running now > on server that containing apache2, phpmyadmin php5.6 and mysql on Ubuntu > 16.4 only. I had followed the below link > > > https://stackoverflow.com/questions/45980691/sqlbox-looking-for-mysql-instead-of-mssql/46727135#46727135 > > Still getting the below > > 2018-10-14 23:30:45 [2701] [0] INFO: Starting to log to file > /var/log/kannel/sqlbox.log level 0 > 2018-10-14 23:30:45 [2701] [0] INFO: Added logfile > `/var/log/kannel/sqlbox.log' with level `0'. > 2018-10-14 23:30:45 [2701] [0] PANIC: SQLBOX: MSSql: connection settings > for id 'sqlbox-db' are not specified! > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(gw_backtrace+0xe0) > [0x5575862ad990] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(gw_panic+0x167) > [0x5575862adb07] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_mssql+0x139) > [0x557586299729] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_sql+0x9) > [0x55758629ede9] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(main+0x361) [0x557586297791] > 2018-10-14 23:30:45 [2701] [0] PANIC: > /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7) [0x7f5dd3777b97] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(_start+0x2a) [0x557586297a2a] > > It could bebecasue it initiate the mssql before the mysql database as the > below lines > > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_mssql+0x139) > [0x557586299729] > 2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_sql+0x9) > [0x55758629ede9] > > Any Idea? > > On Mon, Oct 15, 2018 at 5:01 AM Willy Mularto <sangpr...@gmail.com> wrote: > >> 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'. >>>>> >>>>>
