RE: start up error with SQLbox

"Sixto Santos" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]> 
Joy,

 

You need to compile the thing with MySql support.

 

–with-mysql=  is incorrect and does not get interpreted as a parameter.

 

The correct parameter for ./configure is either 

 

–with-mysql 

 

to have Autoconf try to determine the library location by itself or

 

--with-mysql-dir=/path/to/lib

 

to explicitly tell the script where to look for the library.

 

Cheers,

Sixto

 

 

 

From: devel [mailto:[email protected]] On Behalf Of Joy Larnyoh
Sent: Friday, June 13, 2014 9:39 AM
To: Hanh Le Bich
Cc: kannel_dev_mailinglist devel@kannel. org
Subject: Re: start up error with SQLbox

 

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

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

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

 <mailto:[email protected]> E: [email protected], W:  <http://www.nalosol.com/> www.nalosolutions.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 <http://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 <http://www.nalosolutions.com/>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.