Die Gesprächsdatensätze (Call Detaild Records) wollen wir uns nicht in eine Textdatei schreiben lassen, sondern gleich direkt in unsere MySQL-Datenbank. Somit können wir bei der späteren Bearbeitung und Auswertung der CDRs direkt die Datenbanktabelle befragen und müssen diese nicht erst noch extra in den Speicher laden. Hierzu haben wir uns im Kapitel mysql-datenbankdefinitionen eine Datenbanktabelle cdr bereits angelegt.

Die wichtigen Parameter stehen unter dem Kontext [mysql]:

  • usegmtime
  • loguniqueid=yes
  • loguserfield=yes

Da wir die Datensätze mit den Zeitstemplen der „lokalen Zeit“ schreiben lasasen wollen setzen wir den Parameter GMT auf no. Die einzelnen Datensätze sollen eine eindeutige Kennung bekommen. Hierzu haben wir bei der Installation von den asterisk-addons das Makefile entsprechend angepasst. Siehe hierzu mysql_cdr-anpassung)

Im Detail beinhaltet dann die Konfigurationsdatei folgende Werte:

; Asterisk Call Detail Record engine configuration
; CDR is Call Detail Record, which provides logging services via a variety of
; pluggable backend modules.  Detailed call information can be recorded to
; databases, files, etc.  Useful for billing, fraud prevention, compliance with
; Sarbanes-Oxley aka The Enron Act, QOS evaluations, and more.


; Define whether or not to use CDR logging.  Setting this to "no" will override
; any loading of backend CDR modules.  Default is "yes".

; Define whether or not to log unanswered calls. Setting this to "yes" will
; report every attempt to ring a phone in dialing attempts, when it was not 
; answered. For example, if you try to dial 3 extensions, and this option is "yes",
; you will get 3 CDR's, one for each phone that was rung. Default is "no". Some
; find this information horribly useless. Others find it very valuable. Note, in "yes"
; mode, you will see one CDR, with one of the call targets on one side, and the originating
; channel on the other, and then one CDR for each channel attempted. This may seem 
; redundant, but cannot be helped.
;unanswered = no

; Define the CDR batch mode, where instead of posting the CDR at the end of
; every call, the data will be stored in a buffer to help alleviate load on the
; asterisk server.  Default is "no".
; Use of batch mode may result in data loss after unsafe asterisk termination
; ie. software crash, power failure, kill -9, etc.

; Define the maximum number of CDRs to accumulate in the buffer before posting
; them to the backend engines.  'batch' must be set to 'yes'.  Default is 100.

; Define the maximum time to accumulate CDRs in the buffer before posting them
; to the backend engines.  If this time limit is reached, then it will post the
; records, regardless of the value defined for 'size'.  'batch' must be set to
; 'yes'.  Note that time is in seconds.  Default is 300 (5 minutes).

; The CDR engine uses the internal asterisk scheduler to determine when to post
; records.  Posting can either occur inside the scheduler thread, or a new
; thread can be spawned for the submission of every batch.  For small batches,
; it might be acceptable to just use the scheduler thread, so set this to "yes".
; For large batches, say anything over size=10, a new thread is recommended, so
; set this to "no".  Default is "no".

; When shutting down asterisk, you can block until the CDRs are submitted.  If
; you don't, then data will likely be lost.  You can always check the size of
; the CDR batch buffer with the CLI "cdr status" command.  To enable blocking on
; submission of CDR data during asterisk shutdown, set this to "yes".  Default
; is "yes".

; Normally, CDR's are not closed out until after all extensions are finished
; executing.  By enabling this option, the CDR will be ended before executing
; the "h" extension so that CDR values such as "end" and "billsec" may be
; retrieved inside of of this extension.

; CHOOSING A CDR "BACKEND"  (what kind of output to generate)
; To choose a backend, you have to make sure either the right category is 
; defined in this file, or that the appropriate config file exists, and has the 
; proper definitions in it. If there are any problems, usually, the entry will
; silently ignored, and you get no output.
; Also, please note that you can generate CDR records in as many formats as you 
; wish. If you configure 5 different CDR formats, then each event will be logged
; in 5 different places! In the example config files, all formats are commented
; out except for the cdr-csv format.
; Here are all the possible back ends:
;   csv, custom, manager, odbc, pgsql, radius, sqlite, tds 
;    (also, mysql is available via the asterisk-addons, due to licensing
;     requirements)
;   (please note, also, that other backends can be created, by creating
;    a new backend module in the source cdr/ directory!)
; Some of the modules required to provide these backends will not build or install
; unless some dependency requirements are met. Examples of this are pgsql, odbc,
; etc. If you are not getting output as you would expect, the first thing to do
; is to run the command "make menuselect", and check what modules are available,
; by looking in the "2. Call Detail Recording" option in the main menu. If your
; backend is marked with XXX, you know that the "configure" command could not find
; the required libraries for that option.
; To get CDRs to be logged to the plain-jane /var/log/asterisk/cdr-csv/Master.csv 
; file, define the [csv] category in this file. No database necessary. The example
; config files are set up to provide this kind of output by default.
; To get custom csv CDR records, make sure the cdr_custom.conf file
; is present, and contains the proper [mappings] section. The advantage to
; using this backend, is that you can define which fields to output, and in
; what order. By default, the example configs are set up to mimic the cdr-csv
; output. If you don't make any changes to the mappings, you are basically generating
; the same thing as cdr-csv, but expending more CPU cycles to do so!
; To get manager events generated, make sure the cdr_manager.conf file exists,
; and the [general] section is defined, with the single variable 'enabled = yes'.
; For odbc, make sure all the proper libs are installed, that "make menuselect"
; shows that the modules are available, and the cdr_odbc.conf file exists, and
; has a [global] section with the proper variables defined.
; For pgsql, make sure all the proper libs are installed, that "make menuselect"
; shows that the modules are available, and the cdr_pgsql.conf file exists, and
; has a [global] section with the proper variables defined.
; For logging to radius databases, make sure all the proper libs are installed, that 
; "make menuselect" shows that the modules are available, and the [radius]
; category is defined in this file, and in that section, make sure the 'radiuscfg'
; variable is properly pointing to an existing radiusclient.conf file.
; For logging to sqlite databases, make sure the 'cdr.db' file exists in the log directory,
; which is usually /var/log/asterisk. Of course, the proper libraries should be available
; during the 'configure' operation.
; For tds logging, make sure the proper libraries are available during the 'configure' 
; phase, and that cdr_tds.conf exists and is properly set up with a [global] category.
; Also, remember, that if you wish to log CDR info to a database, you will have to define
; a specific table in that databse to make things work! See the doc directory for more details
; on how to create this table in each database.

;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

;usegmtime=yes    ; log date/time in GMT
;loguniqueid=yes  ; log uniqueid
;loguserfield=yes ; log user field
; Set this to the location of the radiusclient-ng configuration file
; The default is /etc/radiusclient-ng/radiusclient.conf
;radiuscfg => /usr/local/etc/radiusclient-ng/radiusclient.conf

usegmtime=no     ; log date/time in GMT.  Default is "no"                                                                                                                   
loguniqueid=yes  ; log uniqueid.  Default is "no                                                                                                                            
loguserfield=yes ; log user field.  Default is "no

Zurück zum Inhaltsverzeichnis Asterisk (Konfiguration)konfiguration_asterisk
Zurück zum Inhaltsverzeichnis Asterisk (Installation)asterisk

Cookies helfen bei der Bereitstellung von Inhalten. Durch die Nutzung dieser Seiten erklären Sie sich damit einverstanden, dass Cookies auf Ihrem Rechner gespeichert werden. Weitere Information
  • voip/asterisk/cdr-konfiguration_cdr.conf.txt
  • Zuletzt geändert: 20.04.2008 22:00.
  • (Externe Bearbeitung)