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 >>> >> >> >> >
