#7 Problem while starting sqlb

[Ben]

Hi,

After installing sqlb on my server with the option 'mysql',
I configured sqlb.conf as follow :
##
# 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=/var/lib/mysql.sock
DB_LOGIN=root
DB_PWD=XXXX
DB_NAME=XXXX
</mysql@tmpl>

When I start /usr/local/bin/sqlb, the server response
this message :
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Starting all connection...
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Sqlblog is operational.
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Error during initialization of database...Exiting
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Error during initialization of database...Exiting
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Error during initialization of database...Exiting
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Error during initialization of database...Exiting
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
erreur !
Error during initialization of database...Exiting
Error: sqlb (pid = 28735) launch failed for connection
mysql@tmpl
No valid database connection information available
Check that you specified database connection
information in the config file correctly

I also tried to start /usr/local/bin/sqlbquery and I have
the following answer :
'Error during config init...Exiting'

Could somebody give me some advices ?

Thanks a lot

Ben

[Frédéric RUAUDEL]

Logged In: YES
user_id=226667

Hi,

Try to choose just one of the following options

DB_HOST=127.0.0.1
DB_PORT=3082

or

DB_UNIX_SOCK=/var/lib/mysql.sock

and comment the other one.

If it doesn't work, feel free to ask again here or by email
if you prefer (grumz at users dot sf dot net)

Regards,

GrumZ