Re: sqlbox looking for mssql connection although mysql installed

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 <[email protected]> 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 <[email protected]> wrote:
>
>> 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'.
>>>>>
>>>>>