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 <mecedar...@gmail.com> wrote: > heheh I'm following since 3 days :) > > On Mon, Oct 15, 2018 at 11:33 AM Willy Mularto <sangpr...@gmail.com> > 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 <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'. >>>>>>>>>>> >>>>>>>>>>>
