[SR-Users] how you make Kamailio with mariadb

[ANTHONY HESNAUX]

thank you for this informations Rainer 

best regards

Anthony HESNAUX

> Le 5 nov. 2014 à 14:46, Rainer Piper <rainer.piper at soho-piper.de> a écrit :
> 
> You should take a look at the mariaDB Galera Cluster for
> Master-Master-Master... as many as you like DB-Nodes.
> 
> You can run a mariaDB Galera Cluster with 2x Nodes and add Nodes on the fly if you need more DB-Performance.
> 
> and the kamailio module db_cluster
> http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html <http://kamailio.org/docs/modules/4.2.x/modules/db_cluster.html>
> 
> Regards
> Rainer
>  
> 
> Am 05.11.2014 um 14:33 schrieb ANTHONY HESNAUX:
>> Hi Rainer,
>> I test this configuration:
>> 
>> All host with CENTOS 7 and MARIADB
>> 
>> - 1 host -> Proxy SIP KAMAILIO with mariadb for load balancing front end 2 host asterisk
>> 
>> - 2 hosts -> provisioning with mariadb with MASTER-MASTER replication 
>>  
>> - 2 hosts -> Asterisk realtime with Mariadb and replicate configuration Slave to provisionning hosts
>> 
>> Regards
>> 
>> Anthony 
>> 
>> 
>>> Le 5 nov. 2014 à 14:21, Rainer Piper <rainer.piper at soho-piper.de <mailto:rainer.piper at soho-piper.de>> a écrit :
>>> 
>>> Hi Anthony,
>>> 
>>> are you planing to run a mariaDB Multimaster Galera Cluster?
>>> 
>>> Regards 
>>> Rainer
>>> 
>>> 
>>> Am 05.11.2014 um 14:04 schrieb ANTHONY HESNAUX:
>>>> Ok thank you I find my problem I forgot one dependance mariadb-devel and mariadb (complete functions)
>>>> thank you for the kamailio 4.2.0 no problem with sql script 
>>>> 
>>>> Regards
>>>> Anthony HSNAUX
>>>> 
>>>> 
>>>>> Le 5 nov. 2014 à 13:47, Rainer Piper <rainer.piper at soho-piper.de <mailto:rainer.piper at soho-piper.de>> a écrit :
>>>>> 
>>>>> Hi all,
>>>>> 
>>>>> I can confirm that db_mysql is compatible to mariaDB.
>>>>> 
>>>>> I'm running Debian 7 + Kamailio 4.1.6  + mariaDB 10.0.13 Galera DB-Cluster on 12x Nodes.
>>>>> 
>>>>> Regards
>>>>> Rainer
>>>>> 
>>>>> 
>>>>> 
>>>>> Am 05.11.2014 um 13:24 schrieb Daniel-Constantin Mierla:
>>>>>> Hello,
>>>>>> 
>>>>>> 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.
>>>>>> 
>>>>>> If you get troubles connecting with db_mysql to mariadb server, send here the logs with debug=3 in kamailio.cfg
>>>>>> 
>>>>>> Cheers,
>>>>>> Daniel
>>>>>> 
>>>>>> On 05/11/14 13:10, ANTHONY HESNAUX wrote:
>>>>>>> hello Daniel
>>>>>>> I want to install Kamailio with mariadb on CENTOS 7 
>>>>>>> I already install Kamailio on CENTOS 6.5 without error 
>>>>>>> but on CENTOS 7 with mariadb, What modules do you include for make cfg:
>>>>>>> 
>>>>>>> 
>>>>>>> make include_modules="db_mysql" cfg
>>>>>>> 
>>>>>>> thank you 
>>>>>>> 
>>>>>>> best regard
>>>>>>> 
>>>>>>> Anthony HESNAUX
>>>>>>> 
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>>>>> 
>>>>>> -- 
>>>>>> Daniel-Constantin Mierla
>>>>>> http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>
>>>>>> Kamailio Advanced Training, Nov 24-27, Berlin - http://www.asipto.com <http://www.asipto.com/>
>>>>>> 
>>>>>> _______________________________________________
>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>>>> 
>>>>> 
>>>>> -- 
>>>>> Rainer Piper 
>>>>> Integration engineer 
>>>>> Koeslinstr. 56 
>>>>> 53123 BONN 
>>>>> GERMANY 
>>>>> Phone: +49 228 97167161 
>>>>> P2P: sip:rainer at sip.soho-piper.de:5072 <sip:rainer at sip.soho-piper.de:5072> (pjsip-test) 
>>>>> XMPP: rainer at xmpp.soho-piper.de <mailto:rainer at xmpp.soho-piper.de>_______________________________________________
>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>>> 
>>> 
>>> -- 
>>> Rainer Piper 
>>> Integration engineer 
>>> Koeslinstr. 56 
>>> 53123 BONN 
>>> GERMANY 
>>> Phone: +49 228 97167161 
>>> P2P: sip:rainer at sip.soho-piper.de:5072 <sip:rainer at sip.soho-piper.de:5072> (pjsip-test) 
>>> XMPP: rainer at xmpp.soho-piper.de <mailto:rainer at xmpp.soho-piper.de>_______________________________________________
>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
>> 
>> 
>> 
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users <http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>
> 
> 
> -- 
> Rainer Piper 
> Integration engineer 
> Koeslinstr. 56 
> 53123 BONN 
> GERMANY 
> Phone: +49 228 97167161 
> P2P: sip:rainer at sip.soho-piper.de:5072 <sip:rainer at sip.soho-piper.de:5072> (pjsip-test) 
> XMPP: rainer at xmpp.soho-piper.de <mailto:rainer at xmpp.soho-piper.de>_______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141105/e08d29e0/attachment.html>