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?