[asterisk-users] Where are stored the CDR's?

[Thorsten Göllner]

Am 21.01.2011 12:21, schrieb Vitor Carlos Flausino:
>>> Hello all.
>>>
>>> Can you help me find where the CDR's are being stored?
>>>
>>> The result of "cdr show status" is:
>>>
>>> Call Detail Record (CDR) settings
>>> ----------------------------------
>>>     Logging: Enabled
>>>     Mode: Simple
>>>     Log unanswered calls: No
>>>
>>> * Registered Backends
>>>     -------------------
>>>       (none)
>> /var/log/asterisk/cdr/
>>
> That directory does not exist. In fact there are two directories named cdr-csv and cdr-custom, but both are empty.
> Also, file /etc/asterisk/cdr.conf is empty and file cdr_mysql.conf contains:
>
> [global]
> hostname = localhost
> dbname=asteriskcdrdb
> password = fpbx
> user = freepbx
> userfield=1
>
> However the database is empty.
>
>
> But... how can I find (which command inside asterisk), where the cdr are stored?
Does the DB exist? If not, so try to create it:

mysql -e "CREATE DATABASE asteriskcdrdb"
mysql -e "GRANT select, insert ON asteriskcdrd.* TO 
'freepbx'@'localhost' IDENTIFIED BY 'fpbx'"

-Thorsten-