Congratulations brother!
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 Tue, Oct 16, 2018 at 2:17 AM Cedar Jet <mecedar...@gmail.com> wrote: > Finally, I got the below result: > > 2018-10-15 15:10:49 [25046] [0] INFO: Starting to log to file > /var/log/kannel/sqlbox.log level 0 > 2018-10-15 15:10:49 [25046] [0] INFO: Added logfile > `/var/log/kannel/sqlbox.log' with level `0'. > 2018-10-15 15:10:49 [25046] [0] INFO: MYSQL: Connected to server at > localhost. > 2018-10-15 15:10:49 [25046] [0] INFO: MYSQL: server version > 5.7.23-0ubuntu0.18.04.1, client version 5.7.23. > 2018-10-15 15:10:49 [25046] [0] DEBUG: Started thread 1 > (sqlbox.c:sql_to_bearerbox) > 2018-10-15 15:10:49 [25046] [1] DEBUG: Thread 1 > (sqlbox.c:sql_to_bearerbox) maps to pid 25046. > 2018-10-15 15:10:49 [25046] [1] DEBUG: Connecting to <127.0.0.1> > 2018-10-15 15:10:49 [25046] [1] INFO: Connected to bearerbox at localhost > port 13001. > 2018-10-15 15:10:49 [25046] [1] DEBUG: Started thread 2 > (sqlbox.c:bearerbox_to_sql) > 2018-10-15 15:10:49 [25046] [2] DEBUG: Thread 2 > (sqlbox.c:bearerbox_to_sql) maps to pid 25046. > > > On Mon, Oct 15, 2018 at 1:06 PM Cedar Jet <mecedar...@gmail.com> wrote: > >> Thanks a lot for your replies. >> >> I joined the mail lists of kannel after I completed all topics in :) >> >> Some of the posts are new for me and some of them are old for me. >> >> For this purpose I decided to join and post a fresh thread >> >> Regards >> >> On Mon, Oct 15, 2018 at 12:46 PM Willy Mularto <sangpr...@gmail.com> >> wrote: >> >>> 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 <mecedar...@gmail.com> wrote: >>> >>>> 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'. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>