Call recording and CDR reports not working

This is from a fresh install of FreePBX.

Here is what asterisk is doing from using the asterisk -vvvrrrrrr cmd

[[email protected] ~]# asterisk -vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
Asterisk 1.8.11-cert1, Copyright © 1999 - 2012 Digium, Inc. and others.
Created by Mark Spencer [email protected]
Asterisk comes with ABSOLUTELY NO WARRANTY; type ‘core show warranty’ for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type ‘core show license’ for details.

== Parsing ‘/etc/asterisk/asterisk.conf’: == Found
Connected to Asterisk 1.8.11-cert1 currently running on localhost (pid = 4227)
Verbosity was 14 and is now 59
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
== Extension Changed 004[ext-local] new state InUse for Notify User 002
– Executing [[email protected]:1] Macro(“SIP/004-00000182”, “user-callerid,LIMIT,”) in new stack
== Extension Changed 004[ext-local] new state InUse for Notify User 003
== Extension Changed 004[ext-local] new state InUse for Notify User 001
– Executing [[email protected]:1] Set(“SIP/004-00000182”, “AMPUSER=004”) in new stack
– Executing [[email protected]:2] GotoIf(“SIP/004-00000182”, “0?report”) in new stack
– Executing [[email protected]:3] ExecIf(“SIP/004-00000182”, “1?Set(REALCALLERIDNUM=004)”) in new stack
– Executing [[email protected]:4] Set(“SIP/004-00000182”, “AMPUSER=004”) in new stack
– Executing [[email protected]:5] Set(“SIP/004-00000182”, “AMPUSERCIDNAME=Robert”) in new stack
– Executing [[email protected]:6] GotoIf(“SIP/004-00000182”, “0?report”) in new stack
– Executing [[email protected]:7] Set(“SIP/004-00000182”, “AMPUSERCID=004”) in new stack
– Executing [[email protected]:8] Set(“SIP/004-00000182”, “CALLERID(all)=“Robert” <004>”) in new stack
– Executing [[email protected]:9] GotoIf(“SIP/004-00000182”, “0?limit”) in new stack
– Executing [[email protected]:10] ExecIf(“SIP/004-00000182”, “1?Set(GROUP(concurrency_limit)=004)”) in new stack
– Executing [[email protected]:11] GosubIf(“SIP/004-00000182”, “7?sub-ccss,s,1(from-internal,4012850696)”) in new stack
– Executing [[email protected]:1] ExecIf(“SIP/004-00000182”, “0?Return()”) in new stack
– Executing [[email protected]:2] Set(“SIP/004-00000182”, “CCSS_SETUP=TRUE”) in new stack
– Executing [[email protected]:3] GosubIf(“SIP/004-00000182”, “0?monitor_config,1(from-internal,4012850696):monitor_default,1(from-internal,4012850696)”) in new stack
– Executing [[email protected]:1] GotoIf(“SIP/004-00000182”, “0?is_exten”) in new stack
– Executing [[email protected]:2] StackPop(“SIP/004-00000182”, “”) in new stack
– Executing [[email protected]:3] Return(“SIP/004-00000182”, “FALSE”) in new stack
– Executing [[email protected]:12] GotoIf(“SIP/004-00000182”, “1?continue”) in new stack
– Goto (macro-user-callerid,s,25)
– Executing [[email protected]:25] Set(“SIP/004-00000182”, “CALLERID(number)=004”) in new stack
– Executing [[email protected]:26] Set(“SIP/004-00000182”, “CALLERID(name)=Robert”) in new stack
– Executing [[email protected]:27] Set(“SIP/004-00000182”, “CHANNEL(language)=en”) in new stack
– Executing [[email protected]:2] Set(“SIP/004-00000182”, “MOHCLASS=default”) in new stack
– Executing [[email protected]:3] Set(“SIP/004-00000182”, “_NODEST=”) in new stack
– Executing [[email protected]:4] Gosub(“SIP/004-00000182”, “sub-record-check,s,1(out,4012850696,)”) in new stack
– Executing [[email protected]:1] GotoIf(“SIP/004-00000182”, “1?check”) in new stack
– Goto (sub-record-check,s,6)
– Executing [[email protected]:6] Set(“SIP/004-00000182”, “__MON_FMT=wav”) in new stack
– Executing [[email protected]:7] GotoIf(“SIP/004-00000182”, “1?next”) in new stack
– Goto (sub-record-check,s,10)
– Executing [[email protected]:10] ExecIf(“SIP/004-00000182”, “0?Return()”) in new stack
– Executing [[email protected]:11] GotoIf(“SIP/004-00000182”, “0?out,1”) in new stack
– Executing [[email protected]:12] Set(“SIP/004-00000182”, “__REC_STATUS=INITIALIZED”) in new stack
– Executing [[email protected]:13] ExecIf(“SIP/004-00000182”, “0?Set(__REC_POLICY_MODE=)”) in new stack
– Executing [[email protected]:14] Set(“SIP/004-00000182”, “NOW=1347475913”) in new stack
– Executing [[email protected]:15] Set(“SIP/004-00000182”, “__DAY=12”) in new stack
– Executing [[email protected]:16] Set(“SIP/004-00000182”, “__MONTH=09”) in new stack
– Executing [[email protected]:17] Set(“SIP/004-00000182”, “__YEAR=2012”) in new stack
– Executing [[email protected]:18] Set(“SIP/004-00000182”, “__TIMESTR=20120912-145153”) in new stack
– Executing [[email protected]:19] Set(“SIP/004-00000182”, “__FROMEXTEN=004”) in new stack
– Executing [[email protected]:20] Set(“SIP/004-00000182”, “__CALLFILENAME=out-4012850696-004-20120912-145153-1347475913.562”) in new stack
– Executing [[email protected]:21] Goto(“SIP/004-00000182”, “out,1”) in new stack
– Goto (sub-record-check,out,1)
– Executing [[email protected]:1] ExecIf(“SIP/004-00000182”, “1?Set(__REC_POLICY_MODE=always)”) in new stack
– Executing [[email protected]:2] GosubIf(“SIP/004-00000182”, “1?record,1(exten,4012850696,004)”) in new stack
– Executing [[email protected]:1] Set(“SIP/004-00000182”, “AUDIOHOOK_INHERIT(MixMonitor)=yes”) in new stack
– Executing [[email protected]:2] MixMonitor(“SIP/004-00000182”, “2012/09/12/out-4012850696-004-20120912-145153-1347475913.562.wav,”) in new stack
– Executing [[email protected]:3] Set(“SIP/004-00000182”, “__REC_STATUS=RECORDING”) in new stack
– Executing [[email protected]:4] Set(“SIP/004-00000182”, “CDR(recordingfile)=out-4012850696-004-20120912-145153-1347475913.562.wav”) in new stack
– Executing [[email protected]:5] Return(“SIP/004-00000182”, “”) in new stack
– Executing [[email protected]:3] Return(“SIP/004-00000182”, “”) in new stack
– Executing [[email protected]:5] Macro(“SIP/004-00000182”, “dialout-trunk,1,4012850696,”) in new stack
– Executing [[email protected]:1] Set(“SIP/004-00000182”, “DIAL_TRUNK=1”) in new stack
– Executing [[email protected]:2] GosubIf(“SIP/004-00000182”, “0?sub-pincheck,s,1()”) in new stack
– Executing [[email protected]:3] GotoIf(“SIP/004-00000182”, “0?disabletrunk,1”) in new stack
– Executing [[email protected]:4] Set(“SIP/004-00000182”, “DIAL_NUMBER=4012850696”) in new stack
– Executing [[email protected]:5] Set(“SIP/004-00000182”, “DIAL_TRUNK_OPTIONS=tr”) in new stack
– Executing [[email protected]:6] Set(“SIP/004-00000182”, “OUTBOUND_GROUP=OUT_1”) in new stack
== Begin MixMonitor Recording SIP/004-00000182
– Executing [[email protected]:7] GotoIf(“SIP/004-00000182”, “0?nomax”) in new stack
– Executing [[email protected]:8] GotoIf(“SIP/004-00000182”, “0?chanfull”) in new stack
– Executing [[email protected]:9] GotoIf(“SIP/004-00000182”, “0?skipoutcid”) in new stack
– Executing [[email protected]:10] Set(“SIP/004-00000182”, “DIAL_TRUNK_OPTIONS=”) in new stack
– Executing [[email protected]:11] Macro(“SIP/004-00000182”, “outbound-callerid,1”) in new stack
– Executing [[email protected]:1] ExecIf(“SIP/004-00000182”, “0?Set(CALLERPRES()=)”) in new stack
– Executing [[email protected]:2] ExecIf(“SIP/004-00000182”, “0?Set(REALCALLERIDNUM=004)”) in new stack
– Executing [[email protected]:3] GotoIf(“SIP/004-00000182”, “1?normcid”) in new stack
– Goto (macro-outbound-callerid,s,6)
– Executing [[email protected]:6] Set(“SIP/004-00000182”, “USEROUTCID=<9549610113>”) in new stack
– Executing [[email protected]nd-callerid:7] Set(“SIP/004-00000182”, “EMERGENCYCID=”) in new stack
– Executing [[email protected]:8] Set(“SIP/004-00000182”, “TRUNKOUTCID=<9549610113>”) in new stack
– Executing [[email protected]:9] GotoIf(“SIP/004-00000182”, “1?trunkcid”) in new stack
– Goto (macro-outbound-callerid,s,12)
– Executing [[email protected]:12] ExecIf(“SIP/004-00000182”, “1?Set(CALLERID(all)=<9549610113>)”) in new stack
– Executing [[email protected]:13] ExecIf(“SIP/004-00000182”, “1?Set(CALLERID(all)=<9549610113>)”) in new stack
– Executing [[email protected]:14] ExecIf(“SIP/004-00000182”, “0?Set(CALLERID(all)=)”) in new stack
– Executing [[email protected]:15] ExecIf(“SIP/004-00000182”, “0?Set(CALLERPRES()=prohib_passed_screen)”) in new stack
– Executing [[email protected]:12] GosubIf(“SIP/004-00000182”, “1?sub-flp-1,s,1()”) in new stack
– Executing [[email protected]:1] ExecIf(“SIP/004-00000182”, “1?Set(TARGET_FLP_1=14012850696)”) in new stack
– Executing [[email protected]:2] GotoIf(“SIP/004-00000182”, “1?match”) in new stack
– Goto (sub-flp-1,s,4)
– Executing [[email protected]:4] Set(“SIP/004-00000182”, “DIAL_NUMBER=14012850696”) in new stack
– Executing [[email protected]:5] Return(“SIP/004-00000182”, “”) in new stack
– Executing [[email protected]:13] Set(“SIP/004-00000182”, “OUTNUM=14012850696”) in new stack
– Executing [[email protected]:14] Set(“SIP/004-00000182”, “custom=SIP/voisip”) in new stack
– Executing [[email protected]:15] ExecIf(“SIP/004-00000182”, “0?Set(DIAL_TRUNK_OPTIONS=M(setmusic^default))”) in new stack
– Executing [[email protected]:16] ExecIf(“SIP/004-00000182”, “0?Set(DIAL_TRUNK_OPTIONS=M(confirm))”) in new stack
– Executing [[email protected]:17] Macro(“SIP/004-00000182”, “dialout-trunk-predial-hook,”) in new stack
– Executing [[email protected]:1] MacroExit(“SIP/004-00000182”, “”) in new stack
– Executing [[email protected]:18] GotoIf(“SIP/004-00000182”, “0?bypass,1”) in new stack
– Executing [[email protected]:19] ExecIf(“SIP/004-00000182”, “1?Set(CONNECTEDLINE(num,i)=14012850696)”) in new stack
– Executing [[email protected]:20] ExecIf(“SIP/004-00000182”, “1?Set(CONNECTEDLINE(name,i)=CID:9549610113)”) in new stack
– Executing [[email protected]:21] GotoIf(“SIP/004-00000182”, “0?customtrunk”) in new stack
– Executing [[email protected]:22] Dial(“SIP/004-00000182”, “SIP/voisip/14012850696,300,”) in new stack
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
– Called SIP/voisip/14012850696
– SIP/voisip-00000183 is ringing
– SIP/voisip-00000183 is ringing
– SIP/voisip-00000183 is making progress passing it to SIP/004-00000182
– SIP/voisip-00000183 answered SIP/004-00000182
– Executing [[email protected]:1] Macro(“SIP/004-00000182”, “hangupcall,”) in new stack
– Executing [[email protected]:1] GotoIf(“SIP/004-00000182”, “1?theend”) in new stack
– Goto (macro-hangupcall,s,3)
– Executing [[email protected]:3] ExecIf(“SIP/004-00000182”, “0?Set(CDR(recordingfile)=)”) in new stack
– Executing [[email protected]:4] Hangup(“SIP/004-00000182”, “”) in new stack
== Spawn extension (macro-hangupcall, s, 4) exited non-zero on ‘SIP/004-00000182’ in macro ‘hangupcall’
== Spawn extension (macro-dialout-trunk, h, 1) exited non-zero on ‘SIP/004-00000182’
== Spawn extension (macro-dialout-trunk, s, 22) exited non-zero on ‘SIP/004-00000182’ in macro ‘dialout-trunk’
== Spawn extension (from-internal, 4012850696, 5) exited non-zero on ‘SIP/004-00000182’
== MixMonitor close filestream
== End MixMonitor Recording SIP/004-00000182
== Extension Changed 004[ext-local] new state Idle for Notify User 002
== Extension Changed 004[ext-local] new state Idle for Notify User 003
== Extension Changed 004[ext-local] new state Idle for Notify User 001
localhost*CLI>


I navigated to /var/spool/asterisk/monitor and it is recording, but how to I access the recordings from the FreePBX GUI?

Am I supposed to see a link for the recorded calls under CDR reports? CDR reports does not work so is there another way to access it from the GUI?

That is your problem, what happened to the module?

Sounds like somehow you installed an old Asterisk add-ons package.

I removed the module list from your message, way too much irrelevant info that was not even formatted to make easy to read.

When we say use the [code]tags[/code] we mean it, makes helping a lot easier.

UPDATE: Call monitor under voicemail and recordigs also does not show any call history or recordings even though /var/spoo/asterisk/monitor/ shows recorded calls.

Also, not sure if this matters but I changed the default root password.

Here are all the modules running.

localhost*CLI> module show
Module Description Use Count

Truncated.

188 modules loaded


I read somewhere that cdr_mysql not working might be the cause the problem so I tried to turn it on.

localhost*CLI> module load cdr_mysql.so
Unable to load module cdr_mysql.so
Command ‘module load cdr_mysql.so’ failed.
[2012-09-12 16:54:05] WARNING[19444]: loader.c:398 load_dynamic_module: Error loading m odule ‘cdr_mysql.so’: /usr/lib/asterisk/modules/cdr_mysql.so: cannot open shared object file: No such file or directory
[2012-09-12 16:54:05] WARNING[19444]: loader.c:850 load_resource: Module ‘cdr_mysql.so’ could not be loaded.

ideas?

Whoops, sorry skyking. Will do in the future.

I attempted to install the sql module manually but it failed , I used this command: yum install asterisk-addons-mysql :

Processing Dependency: asterisk-addons-core = 1.8.11-0.cert7.1_cento s5 for package: asterisk-addons-mysql --> Running transaction check ---> Package asterisk-addons-core.x86_64 0:1.8.11-0.cert7.1_centos5 set to be updated --> Processing Conflict: asterisk-res_digium_phone conflicts asterisk-gp lonly --> Finished Dependency Resolution asterisk-res_digium_phone-1.8.11_1.2.0-1_centos5.x86_64 from installed h as depsolving problems --> asterisk-res_digium_phone conflicts with asterisk-addons-core Error: asterisk-res_digium_phone conflicts with asterisk-addons-core You could try using --skip-broken to work around the problem You could try running: package-cleanup --problems package-cleanup --dupes rpm -Va --nofiles --nodigest The program package-cleanup is found in the yum-utils package.

Ideas?

Are you using AsteriskNow? If so they do not support MySQL for CDRs and require some hacking to get it to work

How was this system installed. Asterisk add-ons is not used with 1.8 so you have 1.6 module installed on a 1.8 system.

Whose repo’s are you using?

yum is not a manual install, downloading source and using make is a manual install.

AsteriskNow

Well if you do not know how or what you installed we wont be able to assist you.

Sorry, It actually is AsteriskNow,

So, can what needs to be done to get AsteriskNow to work with CDR?
Or do you think I should just download FreePBX Distro and start over.

Asterisknow has a lot of issues and no support community. I think you would better off with the distro. If you have entered a significant amount of data just back it up with the FreePBX module and restore to our distro.

Installed FreePBX Distro from freepbx.org(for real,Really) today,and imported my backup.

Sadly CDR reports still not working lol. I will work on this tommorow,too tired.

Read this thread, am pretty sure that will give you the answer

http://www.freepbx.org/forum/freepbx-distro/distro-discussion-help/distro-upgrade-script-for-1-811-210-57-2

YES THANK YOU! CDR WORKS! YEEESSSSSS!

Thanks stonet and skyking for showing a noob the way : )

thanks again.

One word of note, I also had to change the user name from “freepbx” to “freepbxuser” in addition to the password.

: )

I was having similar problem with my freepbx that I installed using the scripts to convert stock cent-os 6 into freepbx distro.

After long searching and testing a lot of things, I checked the modules.conf and discovered that the a line saying:

noload => cdr_mysql.so

I changed it to

load => cdr_mysql.so

This should be done by the script but it seems they forgot to check it.

so Pay attention to that

That would be incorrect. You should not use mysql_cdr. We use ODBC for CDRs

Some other things may be broken or weird. This script still puts you at a dated release. Please process through the updates to stable. See: http://wiki.freepbx.org/display/FD/Updating+FreePBX+Official+Distro

After apply this script FreePBX Distro 5.211.65-12, CDR no show records anymore.CDR only shows before April 30th
From May 1 2014 until today I have no records
Anything else works normal