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