Fusionpbx with Postgresql but nibblebill with mariadb

[babak]

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]

Use ODBC in:

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

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

 

[andycol]

why dont you just use nibblebill in postgresql, i have done that and works well

 

[DigitalDaz]

He may want active/active replication and certainly BDR can cause you some problems with that.

 

[andycol]

yea that is true i just dont like the idea of running 2 different db's on one host

 

[babak]

why dont you just use nibblebill in postgresql, i have done that and works well

Galera cluster is synchronous replication so I hope to solve nibblebill scalability problem with it.

 

[babak]

@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