Thanks for the tip! Can you share them? On Mon, Oct 15, 2018 at 12:11 PM Willy Mularto <sangpr...@gmail.com> 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 <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'. >>>>>>>>>>>> >>>>>>>>>>>>
