<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body style='font-family: Verdana,Geneva,sans-serif'>
<p>Carsten,</p>
<p>Indeed my bad, typical case of RTFM ;)</p>
<p>Jan</p>
<p> </p>
<p>Carsten Bock schreef op 2016-08-09 10:24:</p>
<blockquote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margin-left:5px"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div dir="ltr">Hi,<br /><br />please check your cluster definition:<br />You requested parallel operations "8p" on the the connection, so it will write into con1 AND con2. What did you expect? ;-)<br /><br />"Command mode is a character among s, r and p. s is for doing serial operations (try first and if fails, try next); r is for doing round robin operations; p - is for doing parallel operations (this is valid only for write operations)."<br /><a href="http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection">http://www.kamailio.org/docs/modules/devel/modules/db_cluster#db_cluster.p.connection</a><br /><br />Thanks,<br />Carsten<br />
<div>
<div> </div>
<p style="font-family: Helvetica,Arial; font-size: 12px; text-align: justify; color: #000000;"> </p>
</div>
<img style="display: none;" src="http://t.sidekickopen62.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4LGF6VcW1262m64hLW3xdLSP72TN_3d7C-zj01?si=6230090009280512&pi=639698f8-cdea-473e-b760-d2fb9126d93b" alt="" width="1" height="1" /></div>
<div class="gmail_extra"><br />
<div class="gmail_quote">2016-08-09 9:54 GMT+02:00 Jan Hazenberg <span><<a href="mailto:jenus@cyberchaos.nl">jenus@cyberchaos.nl</a>></span>:<br />
<blockquote class="gmail_quote" style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">Hi,<br /><br /> I have a issue with the db_cluster module. All works fine but when i enable ACC records to the database i get duplicate entry's in the acc table. I have 2 nodes enabled:<br /><br /> # ----- db_cluster params -----<br /> modparam("db_cluster", "connection",<br /> "con1=>mysql://<a href="http://kamailio:password@10.1.1.1/kamailio" rel="noreferrer">kamailio:password@10.1.1.1/kamailio</a>")<br /> modparam("db_cluster", "connection",<br /> "con2=>mysql://<a href="http://kamailio:password@10.1.1.2/kamailio" rel="noreferrer">kamailio:password@10.1.1.2/kamailio</a>")<br /><br /> modparam("db_cluster", "cluster", "cls1=>con1=9s8p;con2=9s8p")<br /><br /> When i remove one node from the pool the acc records look fine. Could this be a bug? Or should i bypass the db_cluster for accounting?<br /><br /> I'm running kamailio 4.4.2.<br /><br /> Thanks,<br /><br /> Jan Hazenberg<br /><br /> _______________________________________________<br /> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br /><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br /><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></blockquote>
</div>
<br /><br clear="all" />
<div> </div>
-- <br />
<div class="gmail_signature">Carsten Bock<br />CEO (Geschäftsführer)<br /><br />ng-voice GmbH<br />Millerntorplatz 1<br />20359 Hamburg / Germany<br /><br /><a href="http://www.ng-voice.com">http://www.ng-voice.com</a><br />mailto:<a href="mailto:carsten@ng-voice.com">carsten@ng-voice.com</a><br /><br />Office +49 40 5247593-40<br />Fax +49 40 5247593-99<br /><br />Sitz der Gesellschaft: Hamburg<br />Registergericht: Amtsgericht Hamburg, HRB 120189<br />Geschäftsführer: Carsten Bock<br />Ust-ID: DE279344284<br /><br />Hier finden Sie unsere handelsrechtlichen Pflichtangaben:<br /><a href="http://www.ng-voice.com/imprint/">http://www.ng-voice.com/imprint/</a></div>
</div>
<br />
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<p> </p>
<div> </div>
</body></html>