[SR-Users] command out of sync with db_cluster and db_mysql
Boden Garman
bpgarman at fastmail.fm
Fri Apr 12 05:31:35 CEST 2019
Hi Simone,
Not really an answer to the db_cluster issue but I use MariaDB's Maxscale for managing connections to the a Galera cluster, maybe you can try that instead if you can't solve the problem.
On Thu, 11 Apr 2019, at 10:31 PM, Simone Lazzaris wrote:
> 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
> Responsabile datacenter
>
> Qcom S.p.A.
> Via Roggia Vignola, 9 | 24047 Treviglio (BG)
> T +39036347905 | D +3903631970352| M +393938111237
> _simone.lazzaris at qcom.it_ | _www.qcom.it_
>
> Qcom Official Pages _LinkedIn_ <https://www.linkedin.com/company/qcom-spa> | _Facebook_ <http://www.facebook.com/qcomspa>
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190411/be9406b8/attachment.html>
More information about the sr-users
mailing list