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