Re: start up error with SQLbox

Hi Sixto,

Kindly check below and advice why i got the errors i market red below:

[root@vps-1155147-20951 gateway-1.5.0]# ./configure
--prefix=/usr/local/SMSGW/ --enable-start-stop-daemon
--with-mysql-dir=/usr/lib/mysql

Configuring for Kannel gateway version 1.5.0 ...

Running system checks ...
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for gcc option to accept ISO C99... -std=gnu99
checking for a BSD-compatible install... /usr/bin/install -c
checking for ranlib... ranlib
checking for bison... bison -y
checking for flex... flex
checking lex output file root... lex.yy
checking lex library... -lfl
checking whether yytext is a pointer... yes
checking for ar... ar
checking for convert... no
checking for perl... /usr/bin/perl
checking for inline... inline
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking how to run the C preprocessor... gcc -std=gnu99 -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking size of short... 2
checking size of int... 4
checking size of long... 8
checking size of long long... 8
checking for log in -lm... yes
checking for accept in -lsocket... no
checking for inet_ntoa in -lnsl... yes
checking for inet_ntop in -lresolv... yes
checking for inet_ntop in -lbind... no
checking for pthread_exit in -lpthread... yes
checking for ANSI C header files... (cached) yes
checking sys/ioctl.h usability... yes
checking sys/ioctl.h presence... yes
checking for sys/ioctl.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for sys/types.h... (cached) yes
checking for unistd.h... (cached) yes
checking sys/poll.h usability... yes
checking sys/poll.h presence... yes
checking for sys/poll.h... yes
checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
checking getopt.h usability... yes
checking getopt.h presence... yes
checking for getopt.h... yes
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking zlib.h usability... yes
checking zlib.h presence... yes
checking for zlib.h... yes
checking execinfo.h usability... yes
checking execinfo.h presence... yes
checking for execinfo.h... yes
checking for stdlib.h... (cached) yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/sockio.h usability... no
checking sys/sockio.h presence... no
checking for sys/sockio.h... no
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking for net/if.h... yes
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for shared library run path origin... done
checking for iconv... yes
checking for working iconv... yes
checking for iconv declaration...
         extern size_t iconv (iconv_t cd, char * *inbuf, size_t
*inbytesleft, char * *outbuf, size_t *outbytesleft);
checking for gettimeofday... yes
checking for select... yes
checking for socket... yes
checking for strdup... yes
checking for getopt_long... yes
checking for localtime_r... yes
checking for gmtime_r... yes
checking for backtrace... yes
checking for srandom... yes
checking for getopt... yes
checking for gethostbyname_r... yes
checking for which type of gethostbyname_r... 6
checking for socklen_t in <sys/socket.h>... yes
checking for getopt in <stdio.h>... no
checking for getopt in <unistd.h>... yes
checking regex.h usability... yes
checking regex.h presence... yes
checking for regex.h... yes
checking for regcomp... yes

Checking for POSIX threads support ...
checking for working pthreads... yes
checking for pthread_spinlock support... yes
checking for pthread_rwlock support... yes
checking for sem_init in -lrt... yes
checking for semaphore support... yes

Checking for libxml2 support ...
checking for xml2-config... /usr/bin/xml2-config
checking libxml version... 2.7.6

Configuring for PCRE support ...
checking whether to compile with PCRE support... disabled

Configuring DocBook support ...
checking for jade... no
checking for openjade... no
checking for jadetex... no
checking for pdfjadetex... no
checking for dvips... no
checking for fig2dev... no
checking for convert... no
checking for
/usr/lib/sgml/stylesheet/dsssl/docbook/nwalsh/html/docbook.dsl... no
checking for /usr/lib/sgml/stylesheets/nwalsh-modular/html/docbook.dsl... no
checking for
/usr/share/sgml/docbook/dsssl-stylesheets-1.*/html/docbook.dsl... no
checking for /usr/share/sgml/docbook/dsssl-stylesheets/html/docbook.dsl...
no
checking for
/usr/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl... no
checking for /usr/share/sgml/docbook/dsssl/modular/html/docbook.dsl... no
checking for /usr/share/sgml/dsssl/docbook-dsssl-nwalsh/html/docbook.dsl...
no
checking for /usr/share/dsssl/docbook-dsssl/html/docbook.dsl... no
checking for
/usr/local/lib/sgml/stylesheet/dsssl/docbook/nwalsh/html/docbook.dsl... no
checking for
/usr/local/lib/sgml/stylesheets/nwalsh-modular/html/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/dsssl-stylesheets-1.*/html/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/dsssl-stylesheets/html/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl...
no
checking for
/usr/local/share/sgml/docbook/dsssl/modular/html/docbook.dsl... no
checking for
/usr/local/share/sgml/dsssl/docbook-dsssl-nwalsh/html/docbook.dsl... no
checking for /usr/local/share/dsssl/docbook-dsssl/html/docbook.dsl... no
checking for
/sw/lib/sgml/stylesheet/dsssl/docbook/nwalsh/html/docbook.dsl... no
checking for /sw/lib/sgml/stylesheets/nwalsh-modular/html/docbook.dsl... no
checking for
/sw/share/sgml/docbook/dsssl-stylesheets-1.*/html/docbook.dsl... no
checking for /sw/share/sgml/docbook/dsssl-stylesheets/html/docbook.dsl... no
checking for
/sw/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl... no
checking for /sw/share/sgml/docbook/dsssl/modular/html/docbook.dsl... no
checking for /sw/share/sgml/dsssl/docbook-dsssl-nwalsh/html/docbook.dsl...
no
checking for /sw/share/dsssl/docbook-dsssl/html/docbook.dsl... no
checking for
/opt/local/lib/sgml/stylesheet/dsssl/docbook/nwalsh/html/docbook.dsl... no
checking for
/opt/local/lib/sgml/stylesheets/nwalsh-modular/html/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/dsssl-stylesheets-1.*/html/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/dsssl-stylesheets/html/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/stylesheet/dsssl/modular/html/docbook.dsl...
no
checking for
/opt/local/share/sgml/docbook/dsssl/modular/html/docbook.dsl... no
checking for
/opt/local/share/sgml/dsssl/docbook-dsssl-nwalsh/html/docbook.dsl... no
checking for /opt/local/share/dsssl/docbook-dsssl/html/docbook.dsl... no
checking for
/usr/lib/sgml/stylesheet/dsssl/docbook/nwalsh/print/docbook.dsl... no
checking for /usr/lib/sgml/stylesheets/nwalsh-modular/print/docbook.dsl...
no
checking for
/usr/share/sgml/docbook/dsssl-stylesheets-1.*/print/docbook.dsl... no
checking for /usr/share/sgml/docbook/dsssl-stylesheets/print/docbook.dsl...
no
checking for
/usr/share/sgml/docbook/stylesheet/dsssl/modular/print/docbook.dsl... no
checking for /usr/share/sgml/docbook/dsssl/modular/print/docbook.dsl... no
checking for
/usr/share/sgml/dsssl/docbook-dsssl-nwalsh/print/docbook.dsl... no
checking for /usr/share/dsssl/docbook-dsssl/print/docbook.dsl... no
checking for
/usr/local/lib/sgml/stylesheet/dsssl/docbook/nwalsh/print/docbook.dsl... no
checking for
/usr/local/lib/sgml/stylesheets/nwalsh-modular/print/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/dsssl-stylesheets-1.*/print/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/dsssl-stylesheets/print/docbook.dsl... no
checking for
/usr/local/share/sgml/docbook/stylesheet/dsssl/modular/print/docbook.dsl...
no
checking for
/usr/local/share/sgml/docbook/dsssl/modular/print/docbook.dsl... no
checking for
/usr/local/share/sgml/dsssl/docbook-dsssl-nwalsh/print/docbook.dsl... no
checking for /usr/local/share/dsssl/docbook-dsssl/print/docbook.dsl... no
checking for
/sw/lib/sgml/stylesheet/dsssl/docbook/nwalsh/print/docbook.dsl... no
checking for /sw/lib/sgml/stylesheets/nwalsh-modular/print/docbook.dsl... no
checking for
/sw/share/sgml/docbook/dsssl-stylesheets-1.*/print/docbook.dsl... no
checking for /sw/share/sgml/docbook/dsssl-stylesheets/print/docbook.dsl...
no
checking for
/sw/share/sgml/docbook/stylesheet/dsssl/modular/print/docbook.dsl... no
checking for /sw/share/sgml/docbook/dsssl/modular/print/docbook.dsl... no
checking for /sw/share/sgml/dsssl/docbook-dsssl-nwalsh/print/docbook.dsl...
no
checking for /sw/share/dsssl/docbook-dsssl/print/docbook.dsl... no
checking for
/opt/local/lib/sgml/stylesheet/dsssl/docbook/nwalsh/print/docbook.dsl... no
checking for
/opt/local/lib/sgml/stylesheets/nwalsh-modular/print/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/dsssl-stylesheets-1.*/print/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/dsssl-stylesheets/print/docbook.dsl... no
checking for
/opt/local/share/sgml/docbook/stylesheet/dsssl/modular/print/docbook.dsl...
no
checking for
/opt/local/share/sgml/docbook/dsssl/modular/print/docbook.dsl... no
checking for
/opt/local/share/sgml/dsssl/docbook-dsssl-nwalsh/print/docbook.dsl... no
checking for /opt/local/share/dsssl/docbook-dsssl/print/docbook.dsl... no
Not building documentation.

Configuring parameters ...
checking which malloc to use... native malloc
enabling local time
enabling cookies
enabling HTTP/1.1 keep-alive

Configuring OpenSSL support ...
checking whether to compile with SSL support... trying /usr/lib64
/usr/include/openssl
checking for openssl... /usr/bin/openssl
checking for CRYPTO_lock in -lcrypto... yes
checking for SSL_library_init in -lssl... yes
checking for SSL_connect in -lssl... yes
checking openssl/x509.h usability... yes
checking openssl/x509.h presence... yes
checking for openssl/x509.h... yes
checking openssl/rsa.h usability... yes
checking openssl/rsa.h presence... yes
checking for openssl/rsa.h... yes
checking openssl/crypto.h usability... yes
checking openssl/crypto.h presence... yes
checking for openssl/crypto.h... yes
checking openssl/pem.h usability... yes
checking openssl/pem.h presence... yes
checking for openssl/pem.h... yes
checking openssl/ssl.h usability... yes
checking openssl/ssl.h presence... yes
checking for openssl/ssl.h... yes
checking openssl/err.h usability... yes
checking openssl/err.h presence... yes
checking for openssl/err.h... yes
checking openssl/hmac.h usability... yes
checking openssl/hmac.h presence... yes
checking for openssl/hmac.h... yes
checking whether the OpenSSL library is multithread-enabled... yes
checking whether to compile with SSL support... yes

Configuring DB support ...
checking whether to compile with MySQL support... disabled
checking whether to compile with LibSDB support... disabled
checking whether to compile with SQLite2 support... disabled
checking whether to compile with SQLite3 support... disabled
checking whether to compile with Oracle support... disabled
checking whether to compile with PostgresSQL support... disabled
checking whether to compile with FreeTDS Ct-Lib support... disabled

Generating output files ...
configure: creating ./config.status
config.status: creating gwlib/gw_uuid_types.h
config.status: creating Makefile
config.status: creating gw-config.h

License information ...
+--------------------------------------------------------------------+
| License:                                                           |
| This software is subject to the Kannel Software License, available |
| in this distribution in the file LICENSE. By continuing this       |
| installation process, you are bound by the terms of this license   |
| agreement. If you do not agree with the terms of this license, you |
| must abort the installation process at this point.                 |
|                                                                    |
|                      The Kannel Group <http://www.kannel.org/>     |
+--------------------------------------------------------------------+

Thank you for using Kannel.

Best Regards

Joy Ivan Larnyoh
Chief Technical Officer
NALO Solutions Limited
House No. 1, Mahogany Close, Dansoman Last Stop

M: +233  574928710, T: +233 289311489

E: [email protected] <[email protected]>, W:
www.nalosolutions.com <http://www.nalosol.com/>


On Fri, Jun 13, 2014 at 1:54 PM, Sixto Santos <[email protected]> wrote:

> Joy,
>
>
>
> You need to compile the thing with MySql support.
>
>
>
> –with-mysql=  is incorrect and does not get interpreted as a parameter.
>
>
>
> The correct parameter for ./configure is either
>
>
>
> –with-mysql
>
>
>
> to have Autoconf try to determine the library location by itself or
>
>
>
> --with-mysql-dir=/path/to/lib
>
>
>
> to explicitly tell the script where to look for the library.
>
>
>
> Cheers,
>
> Sixto
>
>
>
>
>
>
>
> *From:* devel [mailto:[email protected]] *On Behalf Of *Joy Larnyoh
> *Sent:* Friday, June 13, 2014 9:39 AM
> *To:* Hanh Le Bich
> *Cc:* kannel_dev_mailinglist devel@kannel. org
> *Subject:* Re: start up error with SQLbox
>
>
>
> Hi Hanh,
>
>
>
> That comment was in relation to sqlbox installation.
>
>
>
> For Kannel Status, this is a snapshot of it
>
> Kannel bearerbox version `1.5.0'. Build `Jun 6 2014 18:02:19', compiler
> `4.4.7 20120313 (Red Hat 4.4.7-4)'. System Linux, release
> 2.6.32-042stab088.4, version #1 SMP Thu Apr 3 17:41:05 MSK 2014, machine
> x86_64.
>
>  Libxml version 2.7.6. Using OpenSSL 1.0.1e-fips 11 Feb 2013. Using native
> malloc.
>
>
> Best Regards
>
> Joy Ivan Larnyoh
> Chief Technical Officer
> NALO Solutions Limited
> House No. 1, Mahogany Close, Dansoman Last Stop
>
> M: +233  574928710, T: +233 289311489
>
> E: [email protected] <[email protected]>, W:
> www.nalosolutions.com <http://www.nalosol.com/>
>
>
>
> On Fri, Jun 13, 2014 at 9:23 AM, Hanh Le Bich <[email protected]> wrote:
>
> Ho Joy,
> Cause you said "When i included "--with-mysql= ", i got an error of
> unexpected paramter "--with-mysql="."
>
> So have you compiled with it or not? Check kannel status, it shows that
> info.
>
> Regards,
>
> Hanh.
>
>
>
> On Fri, Jun 13, 2014 at 3:45 PM, Joy Larnyoh <[email protected]>
> wrote:
>
> Dear Hanh,
>
>
>
> On the contrary, my kannel was compiled with mysql (--with-mysql) and
> working fine. Only sqlbox is facing this issue.
>
>
> Best Regards
>
> Joy Ivan Larnyoh
>
>
>
> On Fri, Jun 13, 2014 at 5:11 AM, Hanh Le Bich <[email protected]> wrote:
>
> Seem you have not compiled kannel with mysql (--with-mysql) from the
> beginning.
>
> As i guest, you should install mysqlclient develop packet before compiling.
>
> In Debian the packet name is (just FYR): mysqlclient-dev
>
> In CentOS, it's something similar but i forgot, something like mysql-dev.
> Googling and you'll find the name.
>
> Regards,
>
> Hanh.
>
>
>
> On Fri, Jun 13, 2014 at 9:47 AM, Joy Larnyoh <[email protected]>
> wrote:
>
> Dear WIlly,
>
>
>
> Thanks for your response.
>
>
>
> Below is a snapshot of my config file and the output i get when i run the
> sqlbox:
>
> [root@vps-1155147-20951 ~]# cat /usr/local/SMSGW/conf/sqlbox.conf
>
> group = mysql-connection
>
> host = localhost
>
> username = usrnalo
>
> password = pssnalo
>
> database = dlr
>
>
>
> group = sqlbox
>
> id = sqlbox-db
>
> smsbox-id = sqlbox
>
> #global-sender = ""
>
> bearerbox-host = localhost
>
> bearerbox-port = 13001
>
> smsbox-port = 13005
>
> smsbox-port-ssl = false
>
> sql-log-table = send_sms_log
>
> sql-insert-table = send_sms
>
> log-file = "/data/logs/access/sqlbox.log"
>
> log-level = 0
>
>
>
> [root@vps-1155147-20951 ~]# /usr/local/SMSGW/sbin/sqlbox -v 0 --user root
> /usr/local/SMSGW/conf/sqlbox.conf
>
> 2014-06-13 02:46:09 [12306] [0] INFO: Debug_lvl = 0, log_file = <none>,
> log_lvl = 0
>
> 2014-06-13 02:46:09 [12306] [0] DEBUG: Kannel sqlbox version `1.5.0'.
>
> Build `Jun  6 2014 18:02:19', compiler `4.4.7 20120313 (Red Hat 4.4.7-4)'.
>
> System Linux, release 2.6.32-042stab088.4, version #1 SMP Thu Apr 3
> 17:41:05 MSK 2014, machine x86_64.
>
>
>
> Libxml version 2.7.6.
>
> Using OpenSSL 1.0.1e-fips 11 Feb 2013.
>
> Using native malloc.
>
>
>
> 2014-06-13 02:46:09 [12306] [0] INFO: Starting to log to file
> /data/logs/access/sqlbox.log level 0
>
> 2014-06-13 02:46:09 [12306] [0] INFO: Added logfile
> `/data/logs/access/sqlbox.log' with level `0'.
>
> 2014-06-13 02:46:09 [12306] [0] PANIC: No proper SQL server defined.
>
> 2014-06-13 02:46:09 [12306] [0] PANIC:
> /usr/local/SMSGW/sbin/sqlbox(gw_panic+0x147) [0x423387]
>
> 2014-06-13 02:46:09 [12306] [0] PANIC:
> /usr/local/SMSGW/sbin/sqlbox(main+0x502) [0x40a7f2]
>
> 2014-06-13 02:46:09 [12306] [0] PANIC:
> /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f5985681d1d]
>
> 2014-06-13 02:46:09 [12306] [0] PANIC: /usr/local/SMSGW/sbin/sqlbox()
> [0x409559]
>
> [root@vps-1155147-20951 ~]#
>
>
> Best Regards
>
> Joy Ivan Larnyoh
> Chief Technical Officer
> NALO Solutions Limited
> House No. 1, Mahogany Close, Dansoman Last Stop
>
> M: +233  574928710, T: +233 289311489
>
> E: [email protected] <[email protected]>, W:
> www.nalosolutions.com <http://www.nalosol.com/>
>
>
>
> On Fri, Jun 13, 2014 at 2:20 AM, Willy Mularto <[email protected]>
> wrote:
>
> —with-mysql parameter is not exist for SQLBox
>
>
>
> No proper SQL server error means you have not set up a configuration file.
> Please refer to the user guide how to set it up
>
>
>
>
>
> Willy Mularto
>
> SMS Gateway, Content Provider, Mobile Solution Specialist
>
> M: +62811923464, +62818923464
>
> PIN BBM: 74924429
>
>
>
>
>
>
>
> On Jun 13, 2014, at 9:15 AM, Joy Larnyoh <[email protected]>
> wrote:
>
>
>
> Hi Alvaro,
>
>
>
> While installing the sqlbox, I used below to configure
>
> ./configure --prefix=/usr/local/SMSGW/ --with-kannel-dir=/usr/local/SMSGW/
>
> When i included "--with-mysql= ", i got an error of unexpected paramter
> "--with-mysql=".
>
>
>
> Below is the error i get when I start SQLbox
>
> 2014-06-12 14:56:04 [1593] [0] INFO: Starting to log to file
> /data/logs/access/sqlbox.log level 0
>
> 2014-06-12 14:56:04 [1593] [0] INFO: Added logfile
> `/data/logs/access/sqlbox.log' with level `0'.
>
> *2014-06-12 14:56:04 [1593] [0] PANIC: No proper SQL server defined.*
>
> 2014-06-12 14:56:04 [1593] [0] PANIC:
> /usr/local/SMSGW/sbin/sqlbox(gw_panic+0x147) [0x423387]
>
> 2014-06-12 14:56:04 [1593] [0] PANIC:
> /usr/local/SMSGW/sbin/sqlbox(main+0x502) [0x40a7f2]
>
> 2014-06-12 14:56:04 [1593] [0] PANIC:
> /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f1dad015d1d]
>
> 2014-06-12 14:56:04 [1593] [0] PANIC: /usr/local/SMSGW/sbin/sqlbox()
> [0x409559]
>
>
> Best Regards
>
> Joy Ivan Larnyoh
> Chief Technical Officer
> NALO Solutions Limited
> House No. 1, Mahogany Close, Dansoman Last Stop
>
> M: +233  574928710, T: +233 289311489
>
> E: [email protected] <[email protected]>, W:
> www.nalosolutions.com <http://www.nalosol.com/>
>
>
>
> On Thu, Jun 12, 2014 at 6:48 PM, Alvaro Cornejo <[email protected]>
> wrote:
>
> Hi
>
> Seems you have not configured the database to use or compiled it
> without a database option.
>
> Check manual for details or post logs
>
> Regards
>
> Alvaro
>
> |-----------------------------------------------------------------------------------------------------------------|
> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> celular y Nextel
> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> SMS y GPRS online
>               Visitenos en www.perusms.com
>
>
>
> On Thu, Jun 12, 2014 at 11:36 AM, Joy Larnyoh
> <[email protected]> wrote:
> > Hi ,
> >
> > I have SQLbox verson 1.5 installed on CEntos 6 OS.
> >
> > I however have below error when i start the SQlbox:
> >  No proper SQL server defined.
> >
> > I would be grateful if you could advice on how to  solve this.
> >
> > Best Regards
> >
> > Joy Ivan Larnyoh
> > Chief Technical Officer
> > NALO Solutions Limited
> > House No. 1, Mahogany Close, Dansoman Last Stop
> >
> > M: +233  574928710, T: +233 289311489
> >
> > E: [email protected], W: www.nalosolutions.com
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>