dwilkie

<Response>
  <Say voice="Polly.Russell">Hi Jen please leave a message after the beep</Say>
  <Record action="https://somleng-recordings.free.beeceptor.com"/>
</Response>

dwilkie

Rayo Commands

Start FreeSWITCH Console

$ fs_cli -p secret

Get Rayo Status

dwilkie

sudo docker run -it --rm --net container:59da80a76475 nicolaka/netshoot # Replace 59da80a76475 with the running container ID
tcpdump -Xvv -i eth0 -s0 -w capture.pcap
curl -F "file=@capture.pcap" https://file.io

dwilkie

Build docker image

$ cd /path/to/Dockerfile
$ sudo docker build .

View running processes

dwilkie

Install the unattended-upgrades package

$ sudo apt-get install unattended-upgrades 

Edit the periodic configuration

$ sudo nano /etc/apt/apt.conf.d/10periodic

dwilkie

CallDataRecord.find_each do |cdr|
  next if cdr.file.attached?

  cdr_url = "https://s3-ap-southeast-1.amazonaws.com/cdr.somleng.org/store/#{cdr.file_id}"
  cdr.file.attach(
    io: open(cdr_url),
    filename: cdr.file_filename,
    content_type: cdr.file_content_type
  )
end

dwilkie

# On Elastic Beanstalk machine

yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-libs-11.4-1PGDG.rhel6.x86_64.rpm
yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-11.4-1PGDG.rhel6.x86_64.rpm
yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-server-11.4-1PGDG.rhel6.x86_64.rpm

pg_dump --version

EB_SUPPORT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k support_dir)
EB_SCRIPT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k script_dir)

dwilkie

## import_stories.rb

# Imports stories from the UNICEF Workplan into Pivotal Tracker from CSV file.

### CSV file format

# Export the UNICEF worklplan as CSV.

### Usage

dwilkie

## import_contacts.rb

# Imports contacts into SCFM from CSV file.

### CSV file format

# CSV File must have a `phone_number` or `telephone_number` column
# which contains the phone number of the contact. The phone number
# must be in international E.164 format. All other additional columns
# are added to the contact's metadata with the key being the column header

dwilkie

start_time = Time.new(2020, 10, 1).beginning_of_day
end_time = Time.new(2020, 12, 31).end_of_day

completed_calls = PhoneCall.completed.where(created_at: start_time..end_time).joins(:call_data_record)

number_of_unpaid_users = User.count # SCFM only for now
number_of_calls = completed_calls.count
number_of_minutes = completed_calls.sum("call_data_records.bill_sec") / 60
number_of_users = (completed_calls.pluck(:to) + completed_calls.pluck(:from)).uniq.count