#8 Problem while starting sqlb...again...

[Ben]

Hi Grumz,

Thanks for your answer. I followed your instruction but
it does'nt work. The answer is now :
[sqlb@192 init.d]$ /usr/local/bin/sqlb start
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Syntax error in configuration file for "sqlbquery_max"
param in group optionsSyntax error in configuration file
for "sqlbquery_min" param in group optionsSyntax error
in configuration file for "max_job" param in group
optionsSyntax error in configuration file for "log_level"
param in group optionsSyntax error in configuration file
for "time_before_reconnect" param in group
optionsSyntax error in configuration file
for "integrity_check_interval" param in group
optionsSyntax error in configuration file
for "load_check_limit" param in group optionsStarting all
connection...
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Syntax error in configuration file for "sqlbquery_max"
param in group optionsSyntax error in configuration file
for "sqlbquery_min" param in group optionsSyntax error
in configuration file for "max_job" param in group
optionsSyntax error in configuration file for "log_level"
param in group optionsSyntax error in configuration file
for "time_before_reconnect" param in group
optionsSyntax error in configuration file
for "integrity_check_interval" param in group
optionsSyntax error in configuration file
for "load_check_limit" param in group optionserreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Syntax error in configuration file for "sqlbquery_max"
param in group optionsSyntax error in configuration file
for "sqlbquery_min" param in group optionsSyntax error
in configuration file for "max_job" param in group
optionsSyntax error in configuration file for "log_level"
param in group optionsSyntax error in configuration file
for "time_before_reconnect" param in group
optionsSyntax error in configuration file
for "integrity_check_interval" param in group
optionsSyntax error in configuration file
for "load_check_limit" param in group optionsSqlb already
running on this connection (pid 28735)...Exiting
Error: sqlb (pid = 29643) launch failed for connection
mysql@tmpl
No valid database connection information available
Check that you specified database connection
information in the config file correctly.

The sqlb.conf file is :
##
# General options :
##
<options>
sqlbquery_max=20
sqlbquery_min=1
max_job=512
log_level=4
integrity_check=on
load_managment=on
nb_query_btwn_test=5
time_before_reconnect=300
integrity_check_interval=5
load_check_limit=5
</options>

##
# MySQL configuration template :
##
<mysql@tmpl>
# sqlbquery_max=10
# sqlbquery_min=4
DB_HOST=127.0.0.1
DB_PORT=3082
# DB_UNIX_SOCK=/tmp/mysql.sock
DB_LOGIN=andu
DB_PWD=andu
DB_NAME=andu
</mysql@tmpl>

When I want to see the processes, I can see that sqlb
is launched.

Thanks a lot for your help.

Ben

[Frédéric RUAUDEL]

Logged In: YES
user_id=226667

Do you try with the unix socket ?
In general, it works best when you connect on localhost.
You should check that the mysql.sock really exist before
launching sqlb (it must have been created by MySQL server).
This file is in /tmp when you install mysql manually but
could be somewhere else depending on your distro (ex: on
redhat/fedora system it is in /var/lib/mysql/mysql.sock)

then, you must launch sqlb with the command :

sqlb start

Once it works, you should change the tmpl string in
mysql@tmpl to something more representative like the name of
your database for example. it will be used to reference the
connexion in your script and program.

hope it will help,

GrumZ