Member
Last active 11 years ago
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 ;
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 ;
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
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 :(