Multi PBXs 1 DB one recordings location?

I would like like to have multiple PBXs (2-5) That all use the same table for CDRs and the same storage for recordings. This will make it a lot easier to integrate into my software.

Can this be done?
Any ideas on how to do it?


Yes, edit /etc/asterisk/cdr_mysql.conf to suit, set up users access and tables to suit on the remote machine.

For recordings either edit /etc/asterisk/asterisk.conf adjust

astspooldir => /var/spool/asterisk

to suite or mount a commonly availabe file system over astspooldir, be careful what you mount, as the io can quite intense and samba type mounts will throw-up quite often and spoil your whole day :slight_smile:

Will it cause any issues with multiple systems using the same table for the CDRs and all the systems recordings going to the same share in the same directory?

Would NFS work well for the share?

I modify the cdr table in asteriskcdr to add a field “client” that defaults to “this system” on create row, yes NFS works ok, iscsi is preferable though IMHO.

Ok that mod to CDRs would just be to tell what server that CDR came from?

I there any API or anything to add and remove incoming routes?

A ) Yes
B ) Sorry, I don’t understand you, for that sort of stuff FreePBX is your API, You need to start with the wiki :wink:

Thank you for your help.

Thank you for your help.