<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'Noto Sans'; font-size:9pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Hi everybody;</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I'm trying to use db_cluster to connect my kamailio installation to a mariadb galera cluster, and it's driving me crazy.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">In my lab it works without issues, but when I try the setup in the production node, I get some strange errors:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">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)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Apr 11 14:21:31 ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">This is my configuration:</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("db_cluster", "connection","con1=>mysql://openser:PASSWD@X.X.X.30/openser")</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("db_cluster", "connection","con2=>mysql://openser:PASSWD@X.X.X.31/openser")</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("db_cluster", "connection","con3=>mysql://openser:PASSWD@X.X.X.32/openser")</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("db_cluster", "cluster", "cls1=>con1=9r8r;con2=9r8r;con3=9r8r")</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">#!define DBURL "cluster://cls1"</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">#!define SQLOPSURL "database=>cluster://cls1"</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("dispatcher", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("acc", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("usrloc", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("auth_db", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("permissions", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam("alias_db", "db_url", DBURL)</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">modparam( "sqlops", "sqlcon", SQLOPSURL )</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I'm using version 5.1.4 of kamailio, freshly compiled from source on a debian 9.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Any ideas?</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br />-- </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; font-weight:600; color:#777777;">Simone Lazzaris</span><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"><br />Responsabile datacenter<br /><br /></span><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; font-weight:600; color:#777777;">Qcom S.p.A.</span><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"><br />Via Roggia Vignola, 9 | 24047 Treviglio (BG)<br />T +39036347905 | D +3903631970352| M +393938111237<br /></span><a href="mailto:simone.lazzaris@qcom.it"><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; text-decoration: underline; color:#2980b9;">simone.lazzaris@qcom.it</span></a><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"> | </span><a href="https://www.qcom.it"><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; text-decoration: underline; color:#2980b9;">www.qcom.it</span></a><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"><br /><br />Qcom Official Pages</span><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; font-weight:600; color:#777777;"> </span><a href="https://www.linkedin.com/company/qcom-spa"><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; font-weight:600; text-decoration: underline; color:#2980b9;">LinkedIn</span></a><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"> | </span><a href="http://www.facebook.com/qcomspa"><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; font-weight:600; text-decoration: underline; color:#2980b9;">Facebook</span></a><span style=" font-family:'Helvetica,Arial,sans-serif'; font-size:small; color:#777777;"><br /><br /></span><img src="https://www.qcom.it/includes/email-banner.gif" height="60" /> <br /><br /><br /><br /></p></body></html>