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