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'. >>>>>>>>>>>>> >>>>>>>>>>>>>
