Hi everybody;
I'm trying to use db_cluster to connect my kamailio installation to a mariadb galera
cluster,
and it's driving me crazy.
In my lab it works without issues, but when I try the setup in the production node, I get
some strange errors:
Apr 11 14:21:31 ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver
error on query: Commands out of sync; you can't run this command now (2014)
Apr 11 14:21:31 ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while
submitting query
This is my configuration:
modparam("db_cluster",
"connection","con1=>mysql://openser:PASSWD@X.X.X.30/
openser")
modparam("db_cluster",
"connection","con2=>mysql://openser:PASSWD@X.X.X.31/
openser")
modparam("db_cluster",
"connection","con3=>mysql://openser:PASSWD@X.X.X.32/
openser")
modparam("db_cluster", "cluster",
"cls1=>con1=9r8r;con2=9r8r;con3=9r8r")
#!define DBURL "cluster://cls1"
#!define SQLOPSURL "database=>cluster://cls1"
modparam("dispatcher", "db_url", DBURL)
modparam("acc", "db_url", DBURL)
modparam("usrloc", "db_url", DBURL)
modparam("auth_db", "db_url", DBURL)
modparam("permissions", "db_url", DBURL)
modparam("alias_db", "db_url", DBURL)
modparam( "sqlops", "sqlcon", SQLOPSURL )
I'm using version 5.1.4 of kamailio, freshly compiled from source on a debian 9.
Any ideas?
*Simone Lazzaris*
*Qcom S.p.A.*
simone.lazzaris(a)qcom.it[1] |
www.qcom.it[2]
* LinkedIn[3]* | *Facebook[4]*
[5]
--------
[1] mailto:simone.lazzaris@qcom.it
[2]
https://www.qcom.it
[3]
https://www.linkedin.com/company/qcom-spa
[4]
http://www.facebook.com/qcomspa
[5]
https://www.qcom.it/includes/email-banner.gif