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?
