Re: sqlbox looking for mssql connection although mysql installed

Finally, I got the below result:

2018-10-15 15:10:49 [25046] [0] INFO: Starting to log to file
/var/log/kannel/sqlbox.log level 0
2018-10-15 15:10:49 [25046] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2018-10-15 15:10:49 [25046] [0] INFO: MYSQL: Connected to server at
localhost.
2018-10-15 15:10:49 [25046] [0] INFO: MYSQL: server version
5.7.23-0ubuntu0.18.04.1, client version 5.7.23.
2018-10-15 15:10:49 [25046] [0] DEBUG: Started thread 1
(sqlbox.c:sql_to_bearerbox)
2018-10-15 15:10:49 [25046] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox)
maps to pid 25046.
2018-10-15 15:10:49 [25046] [1] DEBUG: Connecting to <127.0.0.1>
2018-10-15 15:10:49 [25046] [1] INFO: Connected to bearerbox at localhost
port 13001.
2018-10-15 15:10:49 [25046] [1] DEBUG: Started thread 2
(sqlbox.c:bearerbox_to_sql)
2018-10-15 15:10:49 [25046] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql)
maps to pid 25046.


On Mon, Oct 15, 2018 at 1:06 PM Cedar Jet <[email protected]> wrote:

> Thanks a lot for your replies.
>
> I joined the mail lists of kannel after I completed all topics in :)
>
> Some of the posts are new for me and some of them are old for me.
>
> For this purpose I decided to join and post a fresh thread
>
> Regards
>
> On Mon, Oct 15, 2018 at 12:46 PM Willy Mularto <[email protected]>
> wrote:
>
>> You may check the archives of this mailing list. 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 4:20 PM Cedar Jet <[email protected]> wrote:
>>
>>> Thanks for the tip! Can you share them?
>>>
>>> On Mon, Oct 15, 2018 at 12:11 PM Willy Mularto <[email protected]>
>>> wrote:
>>>
>>>> BTW there are some threads with Ubuntu installation topic. 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 3:41 PM Cedar Jet <[email protected]> wrote:
>>>>
>>>>> heheh I'm following since 3 days :)
>>>>>
>>>>> On Mon, Oct 15, 2018 at 11:33 AM Willy Mularto <[email protected]>
>>>>> wrote:
>>>>>
>>>>>> Follow the error message to install required package. 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 3:31 PM Cedar Jet <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Ok, I will do that. but how?
>>>>>>>
>>>>>>> If via repository it wont compile with mysql and if from the source
>>>>>>> we have a problem with the compilation and installation on Ubuntu 18.4 LTS
>>>>>>>
>>>>>>> Regards
>>>>>>>
>>>>>>> On Mon, Oct 15, 2018 at 11:23 AM Willy Mularto <[email protected]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I prefer you to use source based installation rather than distro
>>>>>>>> package. 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 11:56 AM Cedar Jet <[email protected]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Look, After investigation, I noticed that the kannel install is
>>>>>>>>> working well via source, but the sqlbox was installed via repository
>>>>>>>>> kannel-sqlbox, so for this reason I couldn't compile it.
>>>>>>>>>
>>>>>>>>> I ran apt-get remove kannel-sqlbox
>>>>>>>>>
>>>>>>>>> I went to kannel source code folder then addons/sqlbox and
>>>>>>>>> ran ./bootstrap I got the below
>>>>>>>>>
>>>>>>>>> + set -e
>>>>>>>>> + amvers=no
>>>>>>>>> + automake-1.11 --version
>>>>>>>>> + automake-1.10 --version
>>>>>>>>> + automake-1.9 --version
>>>>>>>>> + automake-1.8 --version
>>>>>>>>> + automake-1.7 --version
>>>>>>>>> + automake-1.6 --version
>>>>>>>>> + automake-1.5 --version
>>>>>>>>> + automake --version
>>>>>>>>> + automake+ sed -e 1s/[^0-9]*// -e q
>>>>>>>>>  --version
>>>>>>>>> + amvers=1.15.1
>>>>>>>>> + expr 1.15.1 < 1.5
>>>>>>>>> + amvers=no
>>>>>>>>> + test no = no
>>>>>>>>> + set +x
>>>>>>>>> ./bootstrap: you need automake version 1.5 or later
>>>>>>>>>
>>>>>>>>> I uninstalled the automake then downloaded
>>>>>>>>> ftp://ftp.gnu.org/gnu/automake/automake-1.15.1.tar.gz then
>>>>>>>>>
>>>>>>>>> ./configure
>>>>>>>>> ./make && ./make install
>>>>>>>>>
>>>>>>>>> now getting
>>>>>>>>>
>>>>>>>>> + set -e
>>>>>>>>> + amvers=no
>>>>>>>>> + automake-1.15 --version
>>>>>>>>> + amvers=-1.15
>>>>>>>>> + test -1.15 = no
>>>>>>>>> + libtoolize=no
>>>>>>>>> + glibtoolize --version
>>>>>>>>> + libtoolize --version
>>>>>>>>> + libtoolize=libtoolize
>>>>>>>>> + test libtoolize = no
>>>>>>>>> + set +x
>>>>>>>>> + test ! -d autotools
>>>>>>>>> + libtoolize --copy --force
>>>>>>>>> libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR,
>>>>>>>>> 'autotools'.
>>>>>>>>> libtoolize: copying file 'autotools/ltmain.sh'
>>>>>>>>> libtoolize: You should add the contents of the following files to
>>>>>>>>> 'aclocal.m4':
>>>>>>>>> libtoolize:   '/usr/share/aclocal/libtool.m4'
>>>>>>>>> libtoolize:   '/usr/share/aclocal/ltoptions.m4'
>>>>>>>>> libtoolize:   '/usr/share/aclocal/ltsugar.m4'
>>>>>>>>> libtoolize:   '/usr/share/aclocal/ltversion.m4'
>>>>>>>>> libtoolize:   '/usr/share/aclocal/lt~obsolete.m4'
>>>>>>>>> libtoolize: Consider adding 'AC_CONFIG_MACRO_DIRS([m4])' to
>>>>>>>>> configure.ac,
>>>>>>>>> libtoolize: and rerunning libtoolize and aclocal.
>>>>>>>>> libtoolize: Consider adding '-I m4' to ACLOCAL_AMFLAGS in
>>>>>>>>> Makefile.am.
>>>>>>>>> + test -f ltmain.sh
>>>>>>>>> + aclocal-1.15 -I autotools
>>>>>>>>> + autoconf
>>>>>>>>> configure.ac:99: error: possibly undefined macro: AC_PROG_LIBTOOL
>>>>>>>>>       If this token and others are legitimate, please use
>>>>>>>>> m4_pattern_allow.
>>>>>>>>>       See the Autoconf documentation.
>>>>>>>>>
>>>>>>>>> so I'm not able to run the bootstrap to re-compiling with mysql
>>>>>>>>>
>>>>>>>>> Regards
>>>>>>>>>
>>>>>>>>> On Mon, Oct 15, 2018 at 7:48 AM Willy Mularto <[email protected]>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> 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'.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>