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