diff options
Diffstat (limited to 'configs/samples/cdr_mysql.conf.sample')
-rw-r--r-- | configs/samples/cdr_mysql.conf.sample | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/configs/samples/cdr_mysql.conf.sample b/configs/samples/cdr_mysql.conf.sample new file mode 100644 index 000000000..04b70493b --- /dev/null +++ b/configs/samples/cdr_mysql.conf.sample @@ -0,0 +1,60 @@ +; +; 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 +;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 +; +; 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] +;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> + |