Hi Nicolas,

I have fixed the problem

The issues were;

1/ Elastix FOP2 config files being in /etc/elastix/fop2 (Removed these and symlinked to /usr/local/fop2)
2/ Asterisk mysql_so not loading , fixed by uninstalling/reinstalling asterisk-add*
2a/ Incorrect line in /etc/asterisk/*cdr* files , modified to enable cdr logging
3/ Incorrect passwords in /etc/asterisk/*mysql* files - auto generated and fixed by manually changing passwords

Many thanks for all your help - finally got there and call recording is working and data is displayed in Elastix Recordings tab again.

Gavin

Hi,

Ok - there was the first problem, elastix calling the config file from /etc/asterisk/fop2 , I have moved the config files from /usr/local/fop2 into /etc/asterisk/fop2

However, now I have a problem where fop2 will start and no longer accepts connections - I will take some time to remove all the configuration and rebuild.

Hi Nicolas,

fop2.conf ;

; For elastix Monitoring Tab:
;monitor_filename=g${DEST_EXTENSION}-${UNIQUEID}

monitor_filename=/var/spool/asterisk/monitor/${ORIG_EXTENSION}_${DEST_EXTENSION}_%h%i%s_${UNIQUEID}

; For fop2 recording interface
;monitor_filename=/var/spool/asterisk/monitor/${ORIG_EXTENSION}_${DEST_EXTENSION}_%h%i%s_${UNIQUEID}

Which results in the following files being created ;

• rw-r--r-- 1 asterisk asterisk 312364 Oct 29 12:35 g7046-1383046959.12073-out.wav
• rw-r--r-- 1 asterisk asterisk 312364 Oct 29 12:35 g7046-1383046959.12073-in.wav

Hi Nicolas,

I have tried passing this
/usr/local/fop2/recording_elastix.pl g7046-1383046959.12073-in.wav g7046-1383046959.12073-out.wav 1383046959.12073.wav 1383046959.12073
Use of uninitialized value in substitution (s///) at /usr/local/fop2/recording_elastix.pl line 173.

and also

# /usr/local/fop2/recording_elastix.pl g7046-1383046959.12073-in.wav g7046-1383046959.12073-out.wav 1383046959.12073.wav 1383046959
Use of uninitialized value in substitution (s///) at /usr/local/fop2/recording_elastix.pl line 173.

and also

# /usr/local/fop2/recording_elastix.pl g7046-1383046959.12073-in.wav g7046-1383046959.12073-out.wav g7046-1383046959.12073.wav 1383046959
Use of uninitialized value in substitution (s///) at /usr/local/fop2/recording_elastix.pl line 173.

All giving the same error on line 173

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

Hi Nicolas,

If I run the script from the command line I get the following errors ;

$ /usr/local/fop2/recording_elastix.pl g7046-1383038562.8061-in.wav g7046-1383038562.8061-out.wav 1383038562.8061.wav
Use of uninitialized value in substitution (s///) at /usr/local/fop2/recording_elastix.pl line 173.
Use of uninitialized value in concatenation (.) or string at /usr/local/fop2/recording_elastix.pl line 202.

Is the script mixing the files together, then die'ing before doing the SQL work?

Many Thanks,

Hi Nicholas,

It appears that the database table isn't getting updated, the credentials work fine from the CLI, could you suggest how I could trap the error, i see from the notes in recording_elastix.pl not to modify certain lines.

Hi,

Many thanks - I've updated that now the cdrdb table can be read.

Does the filename formatting look correct ;

• rw-r--r-- 1 asterisk asterisk 210924 Oct 28 18:24 g7027-1382984590.175456.wav
• rw-r--r-- 1 asterisk asterisk 787564 Oct 28 18:33 g7027-1382985002.175481.wav

I still cannot see recorded calls via the webui/extension page logged in as the user (in above example extension 7027).

Gavin

Hi All,

I have recently built a new Elastix box (2.4.0) running FOP2 2.27 and I cannot get call recordings to display in the Elastix admin tab.

I can see that the call is being recorded -

127.0.0.1 -> Action: SetVar
127.0.0.1 -> Channel: SIP/7026-0000b975
127.0.0.1 -> Variable: MONITOR_EXEC
127.0.0.1 -> Value: /usr/local/fop2/recording_elastix.pl

127.0.0.1 -> Action: Setvar
127.0.0.1 -> Channel: SIP/7026-0000b975
127.0.0.1 -> Variable: MONITOR_EXEC_ARGS
127.0.0.1 -> Value: 1382969176.168878

127.0.0.1 -> Mix: 1
127.0.0.1 -> Action: Monitor
127.0.0.1 -> Async: 1
127.0.0.1 -> File: /var/spool/asterisk/monitor/7026_7026_140619_1382969176.168878
127.0.0.1 -> Channel: SIP/7026-0000b975
127.0.0.1 -> Format: wav
127.0.0.1 -> ActionID: 181

fop2.cfg is set to call recording_elastix.pl with the following parameters

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_elastix.pl

I presume that recording_elastix.pl is being executed as the file reported above disappears shortly after recording has stopped.

However, i think the mysql database connection fails as I do not see any data in the fop2.fop2recordings table.

I am settings the $MYSQLPASS variable in recording_elastix.pl correctly. If I connect to the mysql server with the user fop2 , I cannot access the asteriskcdrdb database.

# mysql -u fop2 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

mysql> use asteriskcdrdb;
ERROR 1044 (42000): Access denied for user 'fop2'@'localhost' to database 'asteriskcdrdb'

I cant find any reference in the setup guides to allow the fop2 access to the asteriskcdrdb database however?

Hi Nicolas,

You were correct, for some reason commercial-addons.repo was disabled. I have fixed this and installed fop2 from the repository.

The installer gave the following error, but then said the install was complete - not sure if this is a bug?

PHP Fatal error: Call to undefined function queues_list() in /var/www/html/admin/modules/fop2admin/functions.inc.php on line 1320

Many Thanks,

Gavin

This explains then why its failing ;
# yum install fop2
Loaded plugins: fastestmirror, security
Repository LowayResearch is listed more than once in the configuration
Loading mirror speeds from cached hostfile

• addons: mirror.ox.ac.uk
• base: repo.umbeehosting.com
• extras: mirror.ox.ac.uk
• updates: repo.umbeehosting.com

Excluding Packages from CentOS-5 - Addons
Finished
Excluding Packages from CentOS-5 - Base
Finished
Excluding Packages from CentOS-5 - Extras
Finished
Excluding Packages from CentOS-5 - Updates
Finished
Setting up Install Process
No package fop2 available.
Nothing to do

Looks like ive lost my elastix repos' somehow :(