<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">thank you for this informations Rainer <div class=""><br class=""></div><div class="">best regards</div><div class=""><br class=""></div><div class="">Anthony HESNAUX</div><div class=""><br class=""></div><div class=""><div class=""><div><blockquote type="cite" class=""><div class="">Le 5 nov. 2014 à 14:46, Rainer Piper <<a href="mailto:rainer.piper@soho-piper.de" class="">rainer.piper@soho-piper.de</a>> a écrit :</div><br class="Apple-interchange-newline"><div class="">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">You should take a look at the mariaDB
Galera Cluster for<br class="">
Master-Master-Master... as many as you like DB-Nodes.<br class="">
<span id="result_box" class="short_text" lang="en"><br class="">
You can run a mariaDB Galera Cluster with 2x Nodes and add
Nodes on the fly if you need more DB-Performance.<br class="">
<br class="">
</span>and the kamailio module db_cluster<br class="">
<a class="moz-txt-link-freetext" href="http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html">http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html</a><br class="">
<br class="">
Regards<br class="">
Rainer<br class="">
<br class="">
<br class="">
Am 05.11.2014 um 14:33 schrieb ANTHONY HESNAUX:<br class="">
</div>
<blockquote cite="mid:26BECDEF-FA9B-4F25-8D43-77B95BAA02DF@gmail.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
Hi Rainer,
<div class="">I test this configuration:</div>
<div class=""><br class="">
</div>
<div class="">All host with CENTOS 7 and MARIADB</div>
<div class=""><br class="">
</div>
<div class="">- 1 host -> Proxy SIP KAMAILIO with mariadb for
load balancing front end 2 host asterisk</div>
<div class=""><br class="">
</div>
<div class="">- 2 hosts -> provisioning with mariadb with
MASTER-MASTER replication </div>
<div class=""> </div>
<div class="">- 2 hosts -> Asterisk realtime with Mariadb and
replicate configuration Slave to provisionning hosts</div>
<div class=""><br class="">
</div>
<div class="">Regards</div>
<div class=""><br class="">
</div>
<div class="">Anthony </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">Le 5 nov. 2014 à 14:21, Rainer Piper <<a moz-do-not-send="true" href="mailto:rainer.piper@soho-piper.de" class="">rainer.piper@soho-piper.de</a>>
a écrit :</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">Hi Anthony,<br class="">
<br class="">
are you planing to run a mariaDB Multimaster Galera
Cluster?<br class="">
<br class="">
Regards <br class="">
Rainer<br class="">
<br class="">
<br class="">
Am 05.11.2014 um 14:04 schrieb ANTHONY HESNAUX:<br class="">
</div>
<blockquote cite="mid:808DDEFE-B5AA-4BF3-9F61-F626907E6746@gmail.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
Ok thank you I find my problem I forgot one dependance
mariadb-devel and mariadb (complete functions)
<div class="">thank you for the kamailio 4.2.0 no
problem with sql script </div>
<div class=""><br class="">
</div>
<div class="">Regards</div>
<div class="">Anthony HSNAUX</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">Le 5 nov. 2014 à 13:47, Rainer
Piper <<a moz-do-not-send="true" href="mailto:rainer.piper@soho-piper.de" class="">rainer.piper@soho-piper.de</a>>
a écrit :</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html;
charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix"><span id="result_box" class="short_text" lang="en"><span class="hps">Hi all,<br class="">
<br class="">
I</span> <span class="hps">can</span>
<span class="hps">confirm </span></span>that
db_mysql is compatible to mariaDB.<br class="">
<br class="">
I'm running Debian 7 + Kamailio 4.1.6 +
mariaDB 10.0.13 Galera DB-Cluster on 12x
Nodes.<br class="">
<br class="">
Regards<br class="">
Rainer<br class="">
<br class="">
<br class="">
<br class="">
Am 05.11.2014 um 13:24 schrieb
Daniel-Constantin Mierla:<br class="">
</div>
<blockquote cite="mid:545A170A.808@gmail.com" type="cite" class="">
<meta content="text/html;
charset=windows-1252" http-equiv="Content-Type" class="">
Hello,<br class="">
<br class="">
I expect that db_mysql module can connect
and work with MariaDB out of the box --
afaik, the api is compatible between mysql
and mariadb.<br class="">
<br class="">
If you get troubles connecting with
db_mysql to mariadb server, send here the
logs with debug=3 in kamailio.cfg<br class="">
<br class="">
Cheers,<br class="">
Daniel<br class="">
<br class="">
<div class="moz-cite-prefix">On 05/11/14
13:10, ANTHONY HESNAUX wrote:<br class="">
</div>
<blockquote cite="mid:E2C9D856-9C7D-42E4-BF1E-4389D6519E07@gmail.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" class="">
hello Daniel
<div class="">I want to install Kamailio
with mariadb on CENTOS 7 </div>
<div class="">I already install Kamailio
on CENTOS 6.5 without error </div>
<div class="">but on CENTOS 7 with
mariadb, What modules do you include
for make cfg:</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<pre class="code" style="margin-top: 0px; margin-bottom: 1.4em; padding: 0.7em 1em; font-family: Consolas, 'Andale Mono WT', 'Andale Mono', 'Bitstream Vera Sans Mono', 'Nimbus Mono L', Monaco, 'Courier New', monospace; font-size: 14px; direction: ltr; background-color: rgb(251, 250, 249); color: rgb(51, 51, 51); box-shadow: rgb(204, 204, 204) 0px 0px 0.5em inset; border-top-left-radius: 2px; border-top-right-radius: 2px; border-bottom-right-radius: 2px; border-bottom-left-radius: 2px; overflow: auto; word-wrap: normal; border: 1px solid rgb(204, 204, 204); line-height: 19px;">make include_modules="db_mysql" cfg</pre>
<div class=""><br class="">
</div>
</div>
<div class="">thank you </div>
<div class=""><br class="">
</div>
<div class="">best regard</div>
<div class=""><br class="">
</div>
<div class="">Anthony HESNAUX</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" 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>
<br class="">
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Nov 24-27, Berlin - <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com</a></pre>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" 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>
<br class="">
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rainer Piper</b> <br class="">
Integration engineer <br class="">
Koeslinstr. 56 <br class="">
53123 BONN <br class="">
GERMANY <br class="">
Phone: +49 228 97167161 <br class="">
P2P: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a>
(pjsip-test) <br class="">
XMPP: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</div>
_______________________________________________<br class="">
SIP Express Router (SER) and Kamailio
(OpenSER) - sr-users mailing list<br class="">
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" class="">sr-users@lists.sip-router.org</a><br class="">
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" 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>
<br class="">
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rainer Piper</b> <br class="">
Integration engineer <br class="">
Koeslinstr. 56 <br class="">
53123 BONN <br class="">
GERMANY <br class="">
Phone: +49 228 97167161 <br class="">
P2P: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a>
(pjsip-test) <br class="">
XMPP: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</div>
_______________________________________________<br class="">
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br class="">
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" class="">sr-users@lists.sip-router.org</a><br class="">
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<br class="">
<pre wrap="" class="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" 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>
<br class="">
<br class="">
<div class="moz-signature">-- <br class="">
<b class="">Rainer Piper</b>
<br class="">
Integration engineer
<br class="">
Koeslinstr. 56
<br class="">
53123 BONN <br class="">
GERMANY
<br class="">
Phone: +49 228 97167161
<br class="">
P2P: <a class="moz-txt-link-freetext" href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a> (pjsip-test)
<br class="">
XMPP: <a class="moz-txt-link-abbreviated" href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</div>
_______________________________________________<br class="">SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br class=""><a href="mailto:sr-users@lists.sip-router.org" class="">sr-users@lists.sip-router.org</a><br class="">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br class=""></div></blockquote></div><br class=""></div></div></body></html>