| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- ; The point of this module is to allow you log whatever you like in terms of
- ; the CDR variables. Do you want to log uniqueid? Then simply ensure that
- ; your table has that column. If you don't want the column, ensure that it
- ; does not exist in the table structure. If you'd like to call uniqueid
- ; something else in your table, simply provide an alias in the configuration
- ; file that maps the standard CDR field name (uniqueid) to whatever column
- ; name you like. Perhaps you'd like some extra CDR values logged that aren't
- ; in the standard repertoire of CDR variables (some that come to mind are
- ; certain values used for LCR: route, per_minute_cost, and per_minute_price).
- ; Simply set those CDR variables in your dialplan, i.e. Set(CDR(route)=27),
- ; ensure that a corresponding column exists in your table, and cdr_adaptive_odbc
- ; will do the rest.
- ;
- ; This configuration defines the connections and tables for which CDRs may
- ; be populated. Each context specifies a different CDR table to be used.
- ;
- ; The columns in the tables should match up word-for-word (case-insensitive)
- ; to the CDR variables set in the dialplan. The natural advantage to this
- ; system is that beyond setting up the configuration file to tell you what
- ; tables to look at, there isn't anything more to do beyond creating the
- ; columns for the fields that you want, and populating the corresponding
- ; CDR variables in the dialplan. For the builtin variables only, you may
- ; create aliases for the real column name.
- ;
- ; Please note that after adding columns to the database, it is necessary to
- ; reload this module to get the new column names and types read.
- ;
- ; Warning: if you specify two contexts with exactly the same connection and
- ; table names, you will get duplicate records in that table. So be careful.
- ;
- ;[first]
- ;connection=mysql1
- ;table=cdr
- ;[second]
- ;connection=mysql1
- ;table=extracdr
- ;[third]
- ;connection=sqlserver
- ;table=AsteriskCDR
- ;schema=public ; for databases which support schemas
- ;usegmtime=yes ; defaults to no
- ;alias src => source
- ;alias channel => source_channel
- ;alias dst => dest
- ;alias dstchannel => dest_channel
- ;
- ; Any filter specified MUST match exactly or the CDR will be discarded
- ;filter accountcode => somename
- ;filter src => 123
- ; Negative filters are also now available
- ;filter src != 456
- ;
- ; Additionally, we now support setting static values per column. The reason
- ; for this is to allow different sections to specify different values for
- ; a certain named column, presumably separated by filters.
- ;static "Some Special Value" => identifier_code
|
