Re: start up error with SQLbox

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