sqlbox looking for mssql connection although mysql installed

Discussion:

Cedar Jet

2018-10-13 17:15:37 UTC

Hello,

I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below

***@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]
***@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'.

Willy Mularto

2018-10-13 22:48:13 UTC

Permalink

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

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Cedar Jet

2018-10-14 04:07:38 UTC

Permalink

Sure, and sorry for the late reply 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

Post by Willy Mularto
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

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Cedar Jet

2018-10-14 19:09:51 UTC

Permalink

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

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Fajar

2018-10-15 01:04:41 UTC

Permalink

i've been not play with kannel for long, i think there is problem with your kannel package, it looks for mssql(i think sql server) instead on mysql.., you could try latest stable 1.4.5..
On Monday, 15 October 2018, 2:11:59 AM GMT+7, Cedar Jet <***@gmail.com> wrote:

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 <***@gmail.com> wrote:

Share your SQLBox configuration file. Thanks

So Far Express VPN still the fastesthttps://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 <***@gmail.com> wrote:

Hello,

I'm always getting the panic SQLBOX: MSSql: connection settings for id 'sqlbox-db' are not specified! as below

***@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]
***@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'.

Willy Mularto

2018-10-15 02:00:54 UTC

Permalink

Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
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

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Cedar Jet

2018-10-15 03:38:20 UTC

Permalink

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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Willy Mularto

2018-10-15 04:48:26 UTC

Permalink

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

Post by Cedar Jet
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]
/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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for id
'sqlbox-db' are not specified! as below
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]
/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]
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'.

Cedar Jet

2018-10-15 04:55:51 UTC

Permalink

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

Post by Willy Mularto
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

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for
id 'sqlbox-db' are not specified! as below
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]
/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]
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'.

Willy Mularto

2018-10-15 08:22:46 UTC

Permalink

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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
/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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for
id 'sqlbox-db' are not specified! as below
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]
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]
/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]
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'.

Cedar Jet

2018-10-15 08:30:35 UTC

Permalink

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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
/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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings for
id 'sqlbox-db' are not specified! as below
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]
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]
/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]
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'.

Willy Mularto

2018-10-15 08:33:19 UTC

Permalink

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

Post by Cedar Jet
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
/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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings
for id 'sqlbox-db' are not specified! as below
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]
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]
/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]
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'.

Cedar Jet

2018-10-15 08:41:11 UTC

Permalink

heheh I'm following since 3 days :)

Post by Willy Mularto
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

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
/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?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings
for id 'sqlbox-db' are not specified! as below
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]
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]
/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]
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'.

Willy Mularto

2018-10-15 09:10:57 UTC

Permalink

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

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
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]
/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
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_sql+0x9)
[0x55758629ede9]
Any Idea?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings
for id 'sqlbox-db' are not specified! as below
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]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.

Cedar Jet

2018-10-15 09:20:05 UTC

Permalink

Thanks for the tip! Can you share them?

Post by Willy Mularto
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

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
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]
/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
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_sql+0x9)
[0x55758629ede9]
Any Idea?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection settings
for id 'sqlbox-db' are not specified! as below
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]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.

Willy Mularto

2018-10-15 09:46:02 UTC

Permalink

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

Post by Cedar Jet
Thanks for the tip! Can you share them?

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
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]
/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
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(sqlbox_init_sql+0x9)
[0x55758629ede9]
Any Idea?

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection
settings for id 'sqlbox-db' are not specified! as below
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'.
connection settings for id 'sqlbox-db' are not specified!
sqlbox(gw_backtrace+0xe0) [0x560fc0415990]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(gw_panic+0x167)
[0x560fc0415b07]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.

Cedar Jet

2018-10-15 10:06:06 UTC

Permalink

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

Post by Willy Mularto
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

Post by Cedar Jet
Thanks for the tip! Can you share them?

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
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]
/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
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 <

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection
settings for id 'sqlbox-db' are not specified! as below
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'.
connection settings for id 'sqlbox-db' are not specified!
sqlbox(gw_backtrace+0xe0) [0x560fc0415990]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(gw_panic+0x167)
[0x560fc0415b07]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.

Cedar Jet

2018-10-15 19:17:06 UTC

Permalink

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.

Post by Cedar Jet
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

Post by Cedar Jet
Thanks for the tip! Can you share them?

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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

Post by Cedar Jet
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]
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
sqlbox(sqlbox_init_sql+0x9) [0x55758629ede9]
2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(main+0x361)
[0x557586297791]
/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
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
sqlbox(sqlbox_init_sql+0x9) [0x55758629ede9]
Any Idea?
On Mon, Oct 15, 2018 at 5:01 AM Willy Mularto <

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection
settings for id 'sqlbox-db' are not specified! as below
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'.
connection settings for id 'sqlbox-db' are not specified!
sqlbox(gw_backtrace+0xe0) [0x560fc0415990]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(gw_panic+0x167)
[0x560fc0415b07]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.

Willy Mularto

2018-10-16 23:09:27 UTC

Permalink

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

Post by Cedar Jet
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.

Post by Cedar Jet
Thanks for the tip! Can you share them?

Post by Cedar Jet
heheh I'm following since 3 days :)

Post by Cedar Jet
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

Post by Willy Mularto
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

Post by Cedar Jet
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
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 <

Post by Cedar Jet
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]
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
sqlbox(sqlbox_init_sql+0x9) [0x55758629ede9]
2018-10-14 23:30:45 [2701] [0] PANIC: sqlbox(main+0x361)
[0x557586297791]
/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
sqlbox(sqlbox_init_mssql+0x139) [0x557586299729]
sqlbox(sqlbox_init_sql+0x9) [0x55758629ede9]
Any Idea?
On Mon, Oct 15, 2018 at 5:01 AM Willy Mularto <

Post by Willy Mularto
Try to put the database connection before the sqlbox group. Thanks
Pada tanggal Sen, 15 Okt 2018 02.10, Cedar Jet <

Post by Cedar Jet
Hello,
I'm always getting the panic SQLBOX: MSSql: connection
settings for id 'sqlbox-db' are not specified! as below
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'.
connection settings for id 'sqlbox-db' are not specified!
sqlbox(gw_backtrace+0xe0) [0x560fc0415990]
sqlbox(gw_panic+0x167) [0x560fc0415b07]
sqlbox(sqlbox_init_mssql+0x139) [0x560fc0401729]
sqlbox(sqlbox_init_sql+0x9) [0x560fc0406de9]
2018-10-13 12:47:37 [1819] [0] PANIC: sqlbox(main+0x361)
[0x560fc03ff791]
/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]
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'.