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 <jilarn...@nalosolutions.com> 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 <hanhmi...@gmail.com> 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 <jilarn...@nalosolutions.com >> > 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: jilarn...@nalosolutions.com <jilarn...@nalosolutions.com>, W: >>> www.nalosolutions.com <http://www.nalosol.com/> >>> >>> >>> On Fri, Jun 13, 2014 at 2:20 AM, Willy Mularto <sangpr...@gmail.com> >>> 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 <jilarn...@nalosolutions.com> >>>> 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: jilarn...@nalosolutions.com <jilarn...@nalosolutions.com>, W: >>>> www.nalosolutions.com <http://www.nalosol.com/> >>>> >>>> >>>> On Thu, Jun 12, 2014 at 6:48 PM, Alvaro Cornejo < >>>> cornejo.alv...@gmail.com> 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 >>>>> <jilarn...@nalosolutions.com> 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: jilarn...@nalosolutions.com, W: www.nalosolutions.com >>>>> >>>> >>>> >>>> >>> >> >