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