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