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 <sangpr...@gmail.com> 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 <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'. >>>>>> >>>>>>
