SAIL Community Supported PBX

OK, well, we'll keep it under review but it's a great deal of work to provide a general purpose stats pack. There's a lot of other work going on in the background at the moment with the whole back-end of the product being decoupled into a formal API.  This will allow us more flexibility in the presentation layer so you may see something mid-term.    Glad you like the V6 layout.  Did you try running it on a tablet or smartphone yet?  It's pretty cool in the way it adapts to differing screen sizes and layouts.

wow!  You did a lot of work. 

OK, let's see.   Which release of 6 are you running?  I wasn't aware of issues with internal calls not showing up.  I'm assuming you are talking about the recordings browser component, not the underlying data.  Yes?

In terms of conference rooms and call recording, we took a slightly different path to you.  To be fair, it's quite rare we get asked for conference recording so it hasn't been a high priority but here's how we do it when asked.  We use a custom app and we record the conferences to a different directory to the regular recordings.  This makes it somewhat easier to deal with them when it comes to offloading to the final recordings directory which in our customer base is usually some kind of LAN addressed storage.

Bear in mind, customers don't always want recording to be turned on for a particular conference room so we wanted to give them the choice.   So, what we did was to come up with a conference room prefix which the customer could dial to start a conference with call recording enabled.  Here's an example from a customer who has 6 conference rooms; 2894, 2895, 2896, 2897, 2898 and 2899.   What we have is an app which uses a prefix (in this case 2) to invoke the conference with recording enabled, e.g. 22894, 22895 and so on. Here it is


exten=>_2289[4-9],1,SET(CONFBRIDGE(bridge,record_conference)=yes)
exten=>_2289[4-9],n,SET(CONFBRIDGE(bridge,record_file)=/var/spool/asterisk/confrecordings/${STRFTIME(${EPOCH},,%s)}-confcall-${CALLERID(num)}-${EXTEN:1}.wav)
exten=>_2289[4-9],n,ConfBridge(${EXTEN:1},,sark_hosted_user)
exten=>_2289[4-9],n,HangUp


You can see we invoke the bridge with record_conference=yes which is enough to get call recording done.  However, we also point the recording at a new folder in /var/spool/asterisk called confrecordings and give the file a name the recording browser software will understand.   And that's it for the invocation.  As it turns out, as long as at least one conference attendee uses the prefix, then call recording will work as advertised.

So, now we have a bunch of recordings in our new folder confrecordings.  To deal with them we use a new cron mover to ship them off to the final recordings directory.   You can run it as often as you like but we tend to run it once an hour.  Here is how it looks


#!/bin/bash
logger "checking share..."
if ! mount | grep "on /mnt/callrecordings" > /dev/null; then
        logger "share not mounted - Mounting share at /mnt/callrecordings"
        mount -t cifs //some.share/callrecordings -o username=xxxx,password=xxxxx /mnt/callrecordings
        if ! mount | grep "on /mnt/callrecordings" > /dev/null; then
                logger "offload_recordings couldn't mount share - ending"
                exit 8
        fi
fi
# check if there are any files to move...
if find /var/spool/asterisk/confrecordings -maxdepth 0 -empty | read v; then
        logger "no recordings to copy - ending"
        exit 4
fi

#OK, move what we have
logger "beginning conf recordings rsync"
rsync --remove-source-files -a /var/spool/asterisk/confrecordings/* /mnt/callrecordings/`date +%F`/
logger "conf recordings rsync done"
exit 0


As you can see, we just move the file(s) as-is. They look like this, which is compatible with regular recording filenames.


xxxxxx6795-confcall-2238-2894-xxxxxx6805.wav


Now, as you've guessed, it doesn't work very well with tenants, but we are looking at that in V7.  Finally, rsync won't move files that are busy so you can run this as often as you like.

The main benefit I see for this is that it is a bolt-on which shouldn't require any changes to the SARK code itself.

I've been playing with some of the new V6 features in particular the recordings retrieval/playback (which is brilliant).
Just thought I'd post some findings that may help other users and a few questions along the way.

I couldn't get internal calls to show up and I thought maybe they weren't being recorded anymore, then after some digging I realised they were recorded but had been left out the add call portion in the recording class PHP (intended I assume)
Have very basic knowledge with coding but I added the following to catch any files with the to/from portion both being less than 4:

else if ((strlen($file_list[1+$this->offset]) <= 4) && (strlen($file_list[2+$this->offset]) <= 4))

Then added the relevant table for internal calls and then the calls showed up in the retrieval and playback.

Next I thought it would be cool if I could have the conference room calls show up in the retrieval too, I hit a few snags on this.

First thing I noticed (slightly off topic) is when I tested the conference room, the user entering/leaving sound was Alison American voice even though I have the country set to GB and the en-gb sounds installed, when I watched the Asterisk console I noted the following:


Playing 'conf-hasjoin.gsm' (language 'en')
Playing 'confbridge-leave.gsm' (language 'en')
Playing 'conf-hasleft.gsm' (language 'en')

These all had language 'en' where as everything else that was working correctly had 'en-gb' I wasn't sure how to fix this so I just copied those 3 files from the gb sounds and overwrote them in the Alison sounds, it then worked as required.
I don't know if this is a bug or whether my install just got messed up somehow?

So with that out the way I uncommented "record_conference=yes" in the confbridge, which I believe is the correct way to turn on recording for the conference rooms? (it did work)
The conference recordings started popping up in the monitor folder, but then I realised that these aren't processed/moved to the monout folder by the selmix script like the regular calls are.
To get around this I setup a script to rename and move them into the monout folder so the offload script would move them along with the other recordings:

#!/bin/bash

for file in /var/spool/asterisk/monitor/confbridge*; do
    bn=$(basename $file)
    checkifempty=${#bn}
    if [[ "$checkifempty" = 1 ]]; then exit
fi

IFS='-|\.' read var1 var2 var3 var4 <<< "$bn"

newfile="$var3-default-$var2-$var2.$var4"

mv $file /var/spool/asterisk/monout/$newfile

done
exit

This basically moved the portion of the file name around so it could be inline with the format of the other recordings:
confbridge-100-1586602936.wav
would be come
1586602936-default-100-100.wav
I added the default tenant to pass the recordings result file check and added the extra conference room number so I could match a rule when searching.

So with the conference files in a useable format matching the others I added the following into the recording class file
else if (strcmp($file_list[1+$this->offset], $file_list[2+$this->offset]) == 0)

This checks the to and from portion of the recording file name to see if they are the same, since I renamed the conference recording files to have the room number in both the to and from portion they should be the only files that ever match this rule (I couldn't think of any other circumstances)
I added the relevant table, and then conference calls now show for retreival and playback too (finished output screenshot attached)

Issues with the above from what I can see:
1. Due to me forcing default into the filename it makes the solution only for single tenant, which leads me to a quick question, is multiple tenant implemented on conferences? I couldn't see an option.
2. The script for moving the conference recordings from monitor to monout has to be run when the system isn't active because the conference file is in the monitor folder before the conference is finished so could potentially be moved before complete (I've set it to run in a cron job at 1am)

The workaround to both in an ideal situation would be the conferences given over to selmix and be processed and moved like the regular recordings and then just comment out the lines in recording class file if you don't want them to show in the retreival.
Also some sort of multi tenant could be added on the conference section of the gui to have that picked up/added in the recording name and maybe a little record yes/no option for each conference room on the gui could be cool (if conferences can have individual options like that in Asterisk)

I don't know if any of that is possible, I'm pretty limited with my knowledge and I may be misunderstanding how everything works and the limitations from what can be done within the SARK interface. Looking to learn and play with it more now.

Sorry for the long post, hopefully no one comes along and tells me there's a toggle option somewhere in the web GUI for all of this! 

I just tried installing on Debian 10 and it all seemed to go fine and the PBX is up and running, only thing that didn't "automatically" install as per the guide was the GB sounds package.

I tried to get the CDR-Stats installed but couldn't seem to get it to install properly, it looks like it hasn't been updated for a while and I broke a couple of SAIL test installs trying so I gave up on that.

The Master.csv works of course but I don't see it being a user friendly/intuitive way of searching the data compared to the simple CDR section of V5 and prior.

Hopefully some sort of basic CDR searching is considered adding in the future because the rest of V6 is spot on, looks really great I really like the new layout and additions.

Yes, the CDR is downloadable from the V6 browser.  It is in Settings->Logs
Yes, it is the raw CDR data from /var/log/asterisk/cdr-csv/Master.csv

The billing platform is developed by our sister company Brindley Data Services (www.brindleydata.co.uk). It's called, "Bd-Eye".   You can find information about it on the website.

OK, I think I can shed some light on this.   The deb for buster was missing from the repo.   When I test installed it, I grabbed the deb off the library and installed it in-line so I didn't see the error.   I've just loaded the buster deb into the repo and rehearsed an install.   It went fine so please give it another go and let me know how you get on.   I installed V6 (not V7).   As yet we have no deb for V7 buster.  I'm doing a ton of work on 7 at the moment so it's probably not a good idea to install it for now, although you can if you wish (on stretch).

Hi S
Version did not matter. It was the dependency for mysql that failed as 10 would only install mariadb. Which the sail installer did not see as mysql.

Thank you S
Yes understand. If like here everyone wants to "work from home" even if the infrastructure may not be big enough.
I will see if I can find any failed calls in the logs and also try a new VM.

I'm more just using the CDR section in V5 interface to quickly search/view the last handful or so of calls system wide, just to quickly see what recent people had been doing/calling, rather than using it for analyzing/stats etc.

Is the CDR list downloadable from the V6 interface? Is this just the CSV file with Epoch time etc?
I might fire up a new VM and take a look at V6 again this weekend.

How is the billing platform package implemented? Is this through Provu?