Recording

Sneil

I am having a issue. The recording function works. It records in and out. I get two separate audio files.

Issue 1: They are not compiled into 1 mix. Can this be solved from within fop2 or should I solve this from within asterisk?
Do you have any tips helping me in the right direction?

Issue 2: The recording won't show up in the tab. I can see the recording tab but nothing shows up. Also the database table is there but there a 0 rows in it. I guess this has to do with configuration of FOP2, do you have any directions for setting this?

I am using Asterisk 11.0.1.. I enabled the fop 2 config like this (for readability all explanation has been removed):

[general]
; AMI definitions
manager_host=192.168.1.4
manager_port=5038
manager_user=user1
manager_secret=secret10
;event_mask=agent,call,command,system,user,dialplan

;listen_port      = 4445
;restrict_host    = www.asternic.org
web_dir            = /var/www/fop2

poll_interval      = 86400
poll_voicemail     = 1
monitor_ipaddress  = 0

blind_transfer     = 1
; supervised_transfer = 1

; force_parameter_delimiter = ","

; use_agentlogin = 0

;master_key = 5678

spy_options="bq"

;persistent_spy=0

; monitor_filename=g${DEST_EXTENSION}-${UNIQUEID}

monitor_filename=/var/spool/asterisk/monitor/${ORIG_EXTENSION}_${DEST_EXTENSION}_%h%i%s_${UNIQUEID}
monitor_format=wav
monitor_mix=true
monitor_exec=/usr/local/fop2/recording_fop2.pl

; monitor_exec=/var/lib/asterisk/bin/postrecording-script.sh

; notify_on_ringing = 1
; notify_on_connect = 1

; no_pickupmark=1

; use_pickupchan=1

voicemail_path=/var/spool/asterisk/voicemail

;voicemail_path=dbi:ODBC:asterisk!voicemessages

; save_chat_log=1

; khomp_gsm=Khomp/b0

; dongle_gsm=dongle01

; sms_api_url=http://GATEWAY_ADDRESS/cgi-bin/exec?cmd=api_queue_sms&username=USER&password=PASSWORD&content=${MESSAGE}&destination=${NUMBER}&api_version=0.05&channel=1
; sms_api_method=GET
; sms_api_user=USER
; sms_api_password=PASSWORD

; sms_api_url=http://api.smsified.com/v1/smsmessaging/outbound/SERVICENUMBER/requests?address=${NUMBER}&message=${MESSAGE}
; sms_api_method=POST
; sms_api_user=USER
; sms_api_password=PASSWORD
; sms_api_response_error=error

user=1001:secret1:all
user=1005:secret2:all
user=5000:secret3:all
user=5005:secret2:all
user=9000:secret3:all
user=9001:secret1:all
buttonfile=buttons.cfg

;ssl_certificate_file=/etc/pki/tls/certs/localhost.crt
;ssl_certificate_key_file=/etc/pki/tls/private/localhost.key

;#exec autoconfig-users-freepbx.sh

[EDIT] I am not using FreePBX. I am on a Asterisk only server. Setup from Tarball. So maybe it goes wrong when calling the amportal.conf because that's not availble for me. I am now going to adapt the recording_fop2.pl to make this work [/EDIT]

If you need anything else, please let me know!

Sneil

I cannot get it to work. I deleted all the amportal.conf references in the recording_fop2.pl and I made sure that the config knows all the database variables. Still it records perfect. Only it won't combine the recordings and it won't show up in the fop2 interface.

Can you please help me? I don't know where to continu.

Below is my current recording_fop2.pl (I have the original file in backup)

#!/usr/bin/perl -w

# Script to store recordings initiated by FOP2 inside a mysql table
# and move it to a destination folder. Together with the recordings.php
# aplication users will be allowed to browse/search/listen to recordings
# initiated by themselves or by administrators (all or queuemanager
# permission)

# In order for this script to work it must be owned by the same user
# asterisk is running as.
#
# You also have to check the locations of both sox and soxmix and
# the fop2.cfg file
#
# In fop2.cfg you MUST set the monitor filename and configurations to be:
#
# monitor_filename=/var/spool/asterisk/monitor/${ORIG_EXTENSION}_${DEST_EXTENSION}_%h%i%s_${UNIQUEID}
# monitor_format=wav
# monitor_mix=true
# monitor_exec=/usr/local/fop2/recording_fop2.pl
#
# The script must run on the same machine asterisk is installed. Be
# sure the DESTFOLDER exists and it is owned by the asterisk user.
#
# The script will insert records to the fop2recordings table in the
# fop2 database.
#
#CREATE TABLE `fop2recordings` (
#  `id` int(11) NOT NULL auto_increment,
#  `uniqueid` varchar(50) default NULL,
#  `datetime` datetime default NULL,
#  `ownerextension` varchar(20) default NULL,
#  `targetextension` varchar(20) default NULL,
#  `filename` tinytext,
#  `duration` int(11) default '0',
#  `context` varchar(200) default NULL,
#  PRIMARY KEY  (`id`),
#  UNIQUE KEY `uni` (`uniqueid`)
#)

use strict;
use Fcntl;
use File::Copy;
use File::Basename;
use File::Path qw(mkpath);
use DBI;

# database connection
my $MYSQLUSER   = "root";
my $MYSQLPASS   = "Teij6boh";
my $MYSQLDBNAME = "fop2";
my $MYSQLTABLE  = "fop2recordings";
my $MYSQLHOST   = "192.168.1.4";

# configurable variables
my $DESTFOLDER = "/var/spool/asterisk/monitor/fop2";
my $SOX        = `which sox`;
my $SOXMIX     = `which soxmix`;

chomp($SOX);
chomp($SOXMIX);

my $plainmix = 0;

if($SOXMIX eq "") { $SOXMIX = "$SOX -m "; $plainmix=1; }

my $dbh;

# Remove trailing slash
$DESTFOLDER =~ s|/\z||;

if( $#ARGV < 2 ){
    die("Not enough arguments\n\nUsage: recording_fop2.pl sound-in.wav sound-out.wav sound.wav\n");
}

sub connect_db() {
    my $return = 0;
    my %attr   = (
        PrintError => 0,
        RaiseError => 0,
    );

    my $dsn = "DBI:mysql:database=$MYSQLDBNAME;host=$MYSQLHOST";
    $dbh->disconnect if $dbh;
    $dbh = DBI->connect( $dsn, $MYSQLUSER, $MYSQLPASS, \%attr ) or $return = 1;
    return $return;
}

# command line variables
my $LEFT  = shift(@ARGV);
my $RIGHT = shift(@ARGV);
my $OUT   = shift(@ARGV);

# do not edit below this line
if ( !-f $SOX ) {
    die("No sox found $SOX");
    exit 1;
}

my $SOXVERSION =  `$SOX -h 2>&1  | head -n 1 | cut -d\. -f1 | awk '{print \$3}' | sed 's/[A-Za-z]//g'`;

if ( !-f $LEFT ) {
    die("No left sound file found");
    exit 1;
}

if ( !-f $RIGHT ) {
    die("No right sound file found");
    exit 1;
}
my $time = localtime(time);
my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)=localtime(time);
my $newtime = sprintf ("%4d-%02d-%02d",$year+1900,$mon+1,$mday);

if($SOXVERSION>12) {
    # New SOX
    system("$SOX $LEFT -c 2 $LEFT-tmp.wav remix 1 0");
    system("$SOX $RIGHT -c 2 $RIGHT-tmp.wav remix 0 1");
} else {
    # Old SOX
    system("$SOX $LEFT -c 2 $LEFT-tmp.wav pan -1");
    system("$SOX $RIGHT -c 2 $RIGHT-tmp.wav pan 1");
}

if($plainmix==1) {
    system("$SOXMIX $LEFT-tmp.wav $RIGHT-tmp.wav $OUT");
} else {
    system("$SOXMIX -v 1 $LEFT-tmp.wav -v 1 $RIGHT-tmp.wav -v 1 $OUT");
}

if ( -f $LEFT . "-tmp.wav" ) {
    unlink $LEFT . "-tmp.wav";
}

if ( -f $RIGHT . "-tmp.wav" ) {
    unlink $RIGHT . "-tmp.wav";
}
if ( -f $OUT ) {
    unlink $LEFT;
    unlink $RIGHT;
}

my $fnm      = $OUT;
my $basename = basename($OUT);
my ( $exten, $targetexten, $fullmbox, $uniqueid, $context ) = split( /_/, $basename );

if(!defined($context)) {
    $context="";
}

$uniqueid =~ s/\.wav//g;

sub wavduration {
    sysopen WAV, $fnm, O_RDONLY;
    my $riff;
    sysread WAV, $riff, 12;
    my $fmt;
    sysread WAV, $fmt, 24;
    my $data;
    sysread WAV, $data, 8;
    my ( $r1, $r2, $r3 ) = unpack "A4VA4", $riff;
    my ( $f1, $f2, $f3, $f4, $f5, $f6, $f7, $f8 ) = unpack "A4VvvVVvv", $fmt;
    my ( $d1, $d2 ) = unpack "A4V", $data;
    my $playlength = int( $d2 / $f6 );
    return $playlength;
}
## MAIN **************************************

my $seconds = 0;
my $finalrecording=$fnm;

if ( -e $fnm ) {
    $seconds = wavduration($fnm);
}

if ( -e $fnm ) {
    mkpath("$DESTFOLDER/$newtime");
    my $res = copy( $fnm, "$DESTFOLDER/$newtime" );
    if($res == 1) {
        #print "borro $fnm porque copie en  $DESTFOLDER/$newtime  $basename\n";
        $finalrecording = "$DESTFOLDER/$newtime/$basename";
        unlink $fnm;
    } else {
        #print "preservo $fnm porque no pude copiar\n";
        $finalrecording = $fnm;
    }
}

my $whorecorded  = $exten;
my $whomrecorded = $targetexten;
my $duration     = $seconds;

&connect_db();
my $query = "DESC fop2recordings";
my $res = $dbh->do($query);
if(defined($res)) {
    $query = "INSERT INTO $MYSQLTABLE VALUES ('','$uniqueid',now(),'$whorecorded','$whomrecorded','$finalrecording','$duration','$context');";
    $dbh->do($query);
    $dbh->disconnect if $dbh;
} else {
    $query="CREATE TABLE `fop2recordings` (
      `id` int(11) NOT NULL auto_increment,
      `uniqueid` varchar(50) default NULL,
      `datetime` datetime default NULL,
      `ownerextension` varchar(20) default NULL,
      `targetextension` varchar(20) default NULL,
      `filename` tinytext,
      `duration` int(11) default '0',
      `context` varchar(200) default NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `uni` (`uniqueid`)
    )
";

    $dbh->do($query);
    $query = "INSERT INTO $MYSQLTABLE VALUES ('','$uniqueid',now(),'$whorecorded','$whomrecorded','$finalrecording','$duration','$context');";
    $dbh->do($query);
    $dbh->disconnect if $dbh;

nicolas

Perhaps you need to install DBI mysql drivers or similar. The way to troubleshoot is to look at the asterisk FULL log for a line that says something like

Executing /usr/local/fop2/recording_fop2.pl blah blah blah

Where blah blah blha are the actual parameters of the command being executed. Copy the whole command, and then in the command line run that very same command, as the "asterisk" user if you run asterisk with any user other than root.

If there are errors, you will see them on the console.

My bet is that you have some missing perl modules, most probably perl DBI or DBI-mysql

Best regards,