Re: start up error with SQLbox

Hi Alvaro,

Mysql option is there and the mysql libraries are installed.

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

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 5:06 PM, Alvaro Cornejo <[email protected]>
wrote:

> Hi
>
> you are missing --with-mysq option in configure. Also you need to have
> mysql-devel libs installed
>
> 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 Fri, Jun 13, 2014 at 12:02 PM, Joy Larnyoh
> <[email protected]> wrote:
> > 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], W: www.nalosolutions.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], W: www.nalosolutions.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], W: www.nalosolutions.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], W: www.nalosolutions.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
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>