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