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 <mailto:[email protected]> E: [email protected], W: <http://www.nalosol.com/> 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 <mailto:[email protected]> E: [email protected], W: <http://www.nalosol.com/> 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 <mailto:[email protected]> E: [email protected], W: <http://www.nalosol.com/> 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 <http://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 > <http://www.nalosolutions.com/>
