AsteriskNOW 2.0.2 FreePBX CDR

[cameronconner]

On AsteriskNOW 2.0.2, CDRs aren't showing up in FreePBX. Looks like the cdr_adaptive_odbc.so module isn't installed. How do I install it?

Thanks in advance

[mutineer612]

In previous versions installing the add-on for mysql, and running amportal restart did the trick. In AsteriskNOW 2.0 there seems to be a conflict with asterisk-res_digium_phone package. If anyone from the community has any suggestions I'm all ears.

Code: Select all

[root@localhost ~]# yum -y install asterisk-addons-mysql.i386
Loaded plugins: fastestmirror, kmod, security
Loading mirror speeds from cached hostfile
* base: centos.vipernetworksystems.com
* extras: pubmirrors.reflected.net
* updates: mirrors.serveraxis.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package asterisk-addons-mysql.i386 0:1.8.11-0.cert1.2_centos5 set to be updated
--> Processing Dependency: asterisk-addons-core = 1.8.11-0.cert1.2_centos5 for package: asterisk-addons-mysql
--> Running transaction check
---> Package asterisk-addons-core.i386 0:1.8.11-0.cert1.2_centos5 set to be updated
--> Processing Conflict: asterisk-res_digium_phone conflicts asterisk-gplonly
--> Finished Dependency Resolution
asterisk-res_digium_phone-1.8.11_1.0.1-1_centos5.i386 from installed has 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.

[mutineer612]

Well since I don't use the Digium phones yet, the easiest way to solve this problem was to remove the conflicting package and install mysql addons. After performing the following commands, make a test call and re-check your report.

1.) Remove the conflicting Digium phone package

Code: Select all

[root@myhost ~]# yum -y erase asterisk-res_digium_phone.i386

2.) Install mysql asterisk addons

Code: Select all

[root@myhost ~]# yum -y install asterisk-addons-mysql.i386

3.) Restart asterisk

Code: Select all

[root@myhost ~]# amportal restart

*You don't need to but I also disabled the Diguim module from within Module Admin via the GUI.

I hope Diguim considers fixing the conflict in the future as at somepoint having CDR and Digium phone provisioning would be nice.

[rlyoxthimer]

Seems it also conflicts with the fax module. Removing the conflicting modules isn't a useful workaround for me since I use both Digium phones and the fax module.

Code: Select all

[root@localhost ~]# yum -y install asterisk-addons-mysql.x86_64
Loaded plugins: fastestmirror, kmod, security
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* extras: yum.singlehop.com
* updates: mirror.cisp.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package asterisk-addons-mysql.x86_64 0:1.8.11-0.cert1.2_centos5 set to be updated
--> Processing Dependency: asterisk-addons-core = 1.8.11-0.cert1.2_centos5 for package: asterisk-addons-mysql
--> Running transaction check
---> Package asterisk-addons-core.x86_64 0:1.8.11-0.cert1.2_centos5 set to be updated
--> Processing Conflict: asterisk-res_digium_phone conflicts asterisk-gplonly
--> Processing Conflict: asterisk18-res_fax_digium conflicts asterisk-gplonly
--> Finished Dependency Resolution
1:asterisk18-res_fax_digium-1.8.4_1.3.0-1_centos5.x86_64 from installed has depsolving problems
  --> asterisk18-res_fax_digium conflicts with asterisk-addons-core
asterisk-res_digium_phone-1.8.11_1.0.1-1_centos5.x86_64 from installed has depsolving problems
  --> asterisk-res_digium_phone conflicts with asterisk-addons-core
Error: asterisk-res_digium_phone conflicts with asterisk-addons-core
Error: asterisk18-res_fax_digium 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.


[mlerley]

This is a problem for me as well. I want the CDR reports but I have Digium phones and the fax modules. What's the deal? Note that it also mentions a conflict with asterisk-gplonly, which implies there may be some additional license issues at work here. I really do need this to work, though.

[jeffl]

yum -y erase asterisk-res_digium_phone
yum install asterisk-addons-mysql
amportal restart

This brought my CDR up. I needed an excuse not to buy fax licenses anyhow

[theBigSmoke]

I've been trawling this same issue for a while and there seems to be no resolution anywhere that anyone has found besides having to choose between either asterisk-addons OR asterisk-res_digium_phone.

This is kind of a rough choice given an office set up entirely with new Digium phones (which are really excellent other than this bizarre "Sophies Choice").

It's so weird to me (given what I'd presume the market for AsteriskNOW) is that the only snags I've had with NOW are involving Digium products (the other being that digium analog adapter cards need manual re-writing of the stock config files to properly assign to a channel).

If nothing else I would have thought that a goal of NOW would be to work without major tinkering in an all-digium product environment (and it may be, as mentioned above this could be a licensing issue more than anything).

Anyway - if anyone has any new insights or suggestions to resolve the conflict between the phone/fax modules and the mysql addons module (beyond deleting the conflicting phone and fax modules) - it would be *greatly* appreciated.

[mustardman]

Just install the module manually. That's how I got around it. Instructions are here.
http://downloads.digium.com/pub/telepho ... one/README

[theBigSmoke]

Thanks for that suggestion mustardman, very much appreciated.

In your case did you just manually install the DPMA on an already working asterisk-addons install or were you actually in this specific case of having to uninstall the DPMA, add the addons, and then re-install the DMPA manually?

I only ask because my only concern with trying that would be breaking the DPMA control from the FreePBX GUI. That's a bit of a deal-breaker in my specific case since the PBX is in an environment where the handsets are reconfigured daily (sometimes more than once daily) - and the staff who have to set them up and reconfigure them aren't comfortable with the CLI (the very fact that non-technical staff can provision the new Digium phones is a bit of a testament in and of itself).

[mustardman]

You can do whatever you want. When you install manually you are no longer a slave to yum rules. All that rpm is doing as far as I can tell is taking that module and putting it in a directory. You are doing the same thing with manual install. Worst that could happen is it doesn't work but I have a working system that proves it does.

[levimill]

I have already installed and use the Digium Phones add-on. Is it possible to get CDR working in this scenario? Any help is appreciated.

[mustardman]

There was a problem with the asterisk-addons-mysql rpm at one time but I don't think it was anything related to the digium phones module. Try yum update and see if it updates the mysql rpm. If that doesn't work try uninstall asterisk-addons-mysql and then re-install. I remember having this problem and eventually got it working again by doing something like that.

[levimill]

Thanks mustardman

The asterisk-addons-mysql package isn't currently installed. When I try to install it, the dependency asterisk-addons-core tries to install, but runs into conflict issues with asterisk-res_digium_phone and asterisk-res_fax_digium.

Code: Select all

[user@hostname ~]# yum install asterisk-addons-mysql
Loaded plugins: fastestmirror, kmod, security
Loading mirror speeds from cached hostfile
* base: centos.bhs.mirrors.ovh.net
* extras: www.muug.mb.ca
* updates: less.cogeco.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package asterisk-addons-mysql.x86_64 0:1.8.15-0.cert1.1_centos5 set to be updated
--> Processing Dependency: asterisk-addons-core = 1.8.15-0.cert1.1_centos5 for package: asterisk-addons-mysql
--> Running transaction check
---> Package asterisk-addons-core.x86_64 0:1.8.15-0.cert1.1_centos5 set to be updated
--> Processing Conflict: asterisk18-res_fax_digium conflicts asterisk-gplonly
--> Processing Conflict: asterisk-res_digium_phone conflicts asterisk-gplonly
--> Finished Dependency Resolution
asterisk-res_digium_phone-1.8.11_1.4.0-1_centos5.x86_64 from installed has depsolving problems
  --> asterisk-res_digium_phone conflicts with asterisk-addons-core
1:asterisk18-res_fax_digium-1.8.4_1.3.0-1_centos5.x86_64 from installed has depsolving problems
  --> asterisk18-res_fax_digium conflicts with asterisk-addons-core
Error: asterisk-res_digium_phone conflicts with asterisk-addons-core
Error: asterisk18-res_fax_digium 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.

Any ideas?

[mustardman]

Ok now I remember. I thought they would have fixed this by now. It has been a problem for a long time.

CDR will not work without asterisk-addons and asterisk-addons-mysql. So the solution I came up with was to uninstall the conflicting digium-phone rpm and install it from source. The instructions are included in the readme file when you download the source and it is very straight forward.

Can't help you with the fax module. I don't use that. If it can also be installed from source then that would be the solution for that one as well.