| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 |
- ;
- ; Note - if the database server is hosted on the same machine as the
- ; asterisk server, you can achieve a local Unix socket connection by
- ; setting hostname=localhost
- ;
- ; port and sock are both optional parameters. If hostname is specified
- ; and is not "localhost" (you can use address 127.0.0.1 instead), then
- ; cdr_mysql will attempt to connect to the port specified or use the
- ; default port. If hostname is not specified or if hostname is
- ; "localhost", then cdr_mysql will attempt to connect to the socket file
- ; specified by sock or otherwise use the default socket file.
- ;
- ;[global]
- ;hostname=database.host.name
- ;dbname=asteriskcdrdb
- ;table=cdr
- ;password=password
- ;user=asteriskcdruser
- ;port=3306
- ;sock=/tmp/mysql.sock
- [global]
- hostname=127.0.0.1
- dbname=coopaging_db
- table=t_pbx_cdr
- password=123456
- user=coopaging
- port=3306
- sock=/tmp/mysql.sock
- ;timezone=UTC ; Previously called usegmtime
- ;
- ; If your system's locale differs from mysql database character set,
- ; cdr_mysql can damage non-latin characters in CDR variables. Use this
- ; option to protect your data.
- ;charset=koi8r
- charset=utf8
- ;
- ; Older versions of cdr_mysql set the calldate field to whenever the
- ; record was posted, rather than the start date of the call. This flag
- ; reverts to the old (incorrect) behavior. Note that you'll also need
- ; to comment out the "start=calldate" alias, below, to use this.
- ;compat=no
- ;
- ; ssl connections (optional)
- ;ssl_ca=<path to CA cert>
- ;ssl_cert=<path to cert>
- ;ssl_key=<path to keyfile>
- ;
- ; You may also configure the field names used in the CDR table.
- ;
- [columns]
- alias end => createdAt
- alias end => updatedAt
- ;static "<value>" => <column>
- ;alias <cdrvar> => <column>
- ;alias start => calldate
- ;alias clid => <a_field_not_named_clid>
- ;alias src => <a_field_not_named_src>
- ;alias dst => <a_field_not_named_dst>
- ;alias dcontext => <a_field_not_named_dcontext>
- ;alias channel => <a_field_not_named_channel>
- ;alias dstchannel => <a_field_not_named_dstchannel>
- ;alias lastapp => <a_field_not_named_lastapp>
- ;alias lastdata => <a_field_not_named_lastdata>
- ;alias duration => <a_field_not_named_duration>
- ;alias billsec => <a_field_not_named_billsec>
- ;alias disposition => <a_field_not_named_disposition>
- ;alias amaflags => <a_field_not_named_amaflags>
- ;alias accountcode => <a_field_not_named_accountcode>
- ;alias userfield => <a_field_not_named_userfield>
- ;alias uniqueid => <a_field_not_named_uniqueid>
|
