eMbeejay, you're not alone. I have the same issue and have gone through every tip/trick to get it running that I found in these forums. I'm running AsteriskNow 1.7 out of the "cd" and the call reports do not work.

When I ran trixbox ce, the call reports worked, but it didn't like my T1 span card.

yep that is what I going to say. And if that doesn't work since yum kept complaining to me, just download the asterisk and asterisk-addons from http://www.asterisk.org/downloads.

Unpack each.
run ./configure to make sure you have all the dependencies
make clean
make
make install

After I did that, the CDR worked!

In Putty I ran yum install mysql-devel, yum install asterisk-addons-mysql and yum install asterisk-addons, this activated the CDR Mysql database. Do an amportal restart when you have completed the yum updates just to be sure everything is running normally.

Built from the same ISO, I had to [yum] install asterisk16-addons-mysql-1.6.2.1-1_centos5

The reason it's not included in the ISO was due, if I recall correctly, to licensing.

[root@insula ~]# yum -y install asterisk16-addons-mysql-1.6.2.1-1_centos5
Loaded plugins: fastestmirror, kmod
Loading mirror speeds from cached hostfile
 * addons: mirror.team-cymru.org
 * base: mirror.sanctuaryhost.com
 * epel: mirrors.xmission.com
 * extras: styx.biochem.wfubmc.edu
 * updates: mirror.team-cymru.org
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package asterisk16-addons-mysql.x86_64 0:1.6.2.1-1_centos5 set to be updated
--> Processing Dependency: asterisk16-addons-core = 1.6.2.1-1_centos5 for package: asterisk16-addons-mysql
--> Running transaction check
---> Package asterisk16-addons-core.x86_64 0:1.6.2.1-1_centos5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                  Arch    Version               Repository         Size
================================================================================
Installing:
 asterisk16-addons-mysql  x86_64  1.6.2.1-1_centos5     asterisk-current   47 k
Installing for dependencies:
 asterisk16-addons-core   x86_64  1.6.2.1-1_centos5     asterisk-current   32 k

Transaction Summary
================================================================================
Install       2 Package(s)
Upgrade       0 Package(s)

Total download size: 80 k
Downloading Packages:
(1/2): asterisk16-addons-core-1.6.2.1-1_centos5.x86_64.r |  32 kB     00:00     
(2/2): asterisk16-addons-mysql-1.6.2.1-1_centos5.x86_64. |  47 kB     00:00     
--------------------------------------------------------------------------------
Total                                            85 kB/s |  80 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : asterisk16-addons-core                                   1/2 
  Installing     : asterisk16-addons-mysql                                  2/2 

Installed:
  asterisk16-addons-mysql.x86_64 0:1.6.2.1-1_centos5                            

Dependency Installed:
  asterisk16-addons-core.x86_64 0:1.6.2.1-1_centos5                             

Complete!
[root@insula ~]# 

It should be just that easy.

Well I thought the answer was in Peter's suggestion, but alas- I've gone through the process exactly as described, and still no CDR data!

Asterisk 1.6.2.11 (64-bit), FreePBX 2.8.0.4

Peter-

I'm sorry to report I can't recall the exact edition of AsteriskNow I installed, but I am able to supply you with almost everything else you'd need to know...

Asterisk 1.6.2.11, FreePBX 2.8.0.4.

I followed your instructions exactly, and amportal stop/restarted to no avail. In fact a warm reboot (# shutdown -r now) didn't fix it, either.

I thought perhaps something had gone awry (though I realize it's unlikely) with the installation, so I went to re-yum it, but yum explained there was nothing to do after checking to make sure the files were there. (Meaning the installation was complete, I presume.)

I'm running a 64-bit version of the software; I can't imagine this would have any bearing on the situation, as it looks like your instructions indicated you were as well, but it's about all I can think of that may be causing an issue.

I can virtually guarantee you it's not the server it's installed on; I built a monstrosity for this installation and have resources galore.

I would be delighted to hear any and all suggestions you may have: I'm pretty new to Asterisk (4 installations, this being the most complex) but know my way around marginally well in the installation.

Thank you for your patience and advice!

When I first did the install of the addons with yum, Asterisk failed to start. I found that it was necessary to modify the /etc/asterisk/res_mysql.conf. The configuarion file seems to be in the old format containing:

dbuser=asteriskuser
dbpass=amp109

Changing it to :

[asteriskuser]
dbpass=the-right-pwd

resolves the issue for me.

Just for reference this was for the AsteriskNow 1.7 CD, Asterisk 1.6 and FreePBX 2.8.

M

Much easier:

So, I first did:
yum update asterisk16

Then did:
yum install asterisk16-addons
yum install asterisk16-addons-mysql
yum install asterisk16-addons-core

amportal restart

now CDR's are working!

Thanks Alvaro!

thanks all for this post
but every time iam trying to run
[root@localmachine ~]# yum update asterisk1.6
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: mirrors.prometeus.net
* base: mirrors.prometeus.net
* elastix-base: repo-es.elastix.org
* elastix-extras: repo-es.elastix.org
* elastix-updates: repo-es.elastix.org
* epel: mirror.yandex.ru
* extras: mirrors.prometeus.net
* updates: mirrors.prometeus.net
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 Update Process
No Match for argument: asterisk1.6
No package asterisk1.6 available.
No Packages marked for Update

i got these errors , iam runnig Asterisk 1.6.2.13
so what i shall do now ?

what is it that controls whether the cdr actually get written at all? i'm not trying to run freepbx reporting (yet!), just looking for the cdr in cdr-csv directory. the directory exists, but is empty.

i completely agree that distributions make for inept PBX administrators. However, At the risk of starting a flame war... i got my cdr working, and they are most assuredly NOT database driven. they sit nicely in /var/log/asterisk/cdr-csv/Master.csv.

i had to create a cdr.conf in /etc/asterisk (as mentioned above, it's missing from the distribution, for whatever reason).

i added a section as shown below, restarted asterisk, and cdrs started happening

[csv]
usegmtime=yes ; log date/time in GMT. Default is "no"
loguniqueid=yes ; log uniqueid. Default is "no"
loguserfield=yes ; log user field. Default is "no"
accountlogs=yes ; create separate log file for each account code. Default is "yes"

no database required.