Fusionpbx with Postgresql but nibblebill with mariadb

babak

New Member
Dec 4, 2016
22
3
3
46
Hi
I want to try nibblebill with mariadb Galera but do not change fusionpbx internal postgresql database.
I already worked with nibblebill + native postgrsql support but regarding recent changes in FreeSWITCH database connection not sure how to use mariadb just for nibblebill.

Appreciate any comment.

Regards
Babak
 

DigitalDaz

Administrator
Staff member
Sep 29, 2016
2,302
359
83
Use ODBC in:

/etc/freeswitch/autoload_configs/nibblebill.conf.xml

Code:
<param name="odbc-dsn" value="odbc://freeswitch"/>
 

DigitalDaz

Administrator
Staff member
Sep 29, 2016
2,302
359
83
He may want active/active replication and certainly BDR can cause you some problems with that.
 

andycol

New Member
Jun 18, 2020
9
6
3
32
yea that is true i just dont like the idea of running 2 different db's on one host
 

babak

New Member
Dec 4, 2016
22
3
3
46
@DigitalDaz @andycol
Hi
Result of my experiments:
-No need to ODBC now Freeswitch supports native mariadb
-db-dsn should match
<param name="db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" />
- Only works on Debian 10 ( it seems a Freeswitch bug fix only applied to Debian 10 packages)

Regards
 
Last edited:
  • Like
Reactions: DigitalDaz