<!DOCTYPE html><html><head><title></title><style type="text/css">#qt p,#qt li{white-space:pre-wrap;}
p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi Simone,<br></div><div>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.<br></div><div><br></div><div>On Thu, 11 Apr 2019, at 10:31 PM, Simone Lazzaris wrote:<br></div><blockquote type="cite" id="qt"><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">Hi everybody;<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">I'm trying to use db_cluster to connect my kamailio installation to a mariadb galera cluster, and it's driving me crazy.<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">In my lab it works without issues, but when I try the setup in the production node, I get some strange errors:<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">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)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">Apr 11 14:21:31 ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">This is my configuration:<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("db_cluster", "connection","con1=>mysql://openser:PASSWD@X.X.X.30/openser")<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("db_cluster", "connection","con2=>mysql://openser:PASSWD@X.X.X.31/openser")<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("db_cluster", "connection","con3=>mysql://openser:PASSWD@X.X.X.32/openser")<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("db_cluster", "cluster", "cls1=>con1=9r8r;con2=9r8r;con3=9r8r")<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">#!define DBURL "cluster://cls1"<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">#!define SQLOPSURL "database=>cluster://cls1"<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("dispatcher", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("acc", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("usrloc", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("auth_db", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("permissions", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam("alias_db", "db_url", DBURL)<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">modparam( "sqlops", "sqlcon", SQLOPSURL )<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">I'm using version 5.1.4 of kamailio, freshly compiled from source on a debian 9.<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"> <br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;">Any ideas?<br></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"></p><div><br></div><div>--<br></div><p></p><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px;"></p><div><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size">Simone Lazzaris</span></span></span><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><br>Responsabile datacenter<br><br></span></span></span><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size">Qcom S.p.A.</span></span></span><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><br>Via Roggia Vignola, 9 | 24047 Treviglio (BG)<br>T +39036347905 | D +3903631970352| M +393938111237<br></span></span></span><a href="mailto:simone.lazzaris@qcom.it"><span style="color:rgb(41, 128, 185)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><u>simone.lazzaris@qcom.it</u></span></span></span></a><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"> | </span></span></span><a href="https://www.qcom.it"><span style="color:rgb(41, 128, 185)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><u>www.qcom.it</u></span></span></span></a><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><br><br>Qcom Official Pages</span></span></span><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"> </span></span></span><a href="https://www.linkedin.com/company/qcom-spa"><span style="color:rgb(41, 128, 185)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><u>LinkedIn</u></span></span></span></a><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"> | </span></span></span><a href="http://www.facebook.com/qcomspa"><span style="color:rgb(41, 128, 185)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><u>Facebook</u></span></span></span></a><span style="color:rgb(119, 119, 119)" class="colour"><span style="font-family:"Helvetica,Arial,sans-serif"" class="font"><span style="font-size:small" class="size"><br><br></span></span></span><img src="https://www.qcom.it/includes/email-banner.gif" height="60"> </div><div><br></div><div><br></div><p></p><div>_______________________________________________<br></div><div>Kamailio (SER) - Users Mailing List<br></div><div>sr-users@lists.kamailio.org<br></div><div>https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users<br></div><div><br></div></blockquote><div><br></div></body></html>