; ; 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 ; By default CDRs are logged in the system's time zone ;cdrzone=UTC ; log CDRs with UTC ;usegmtime=yes ;log date/time in GMT. Default is "no" ;cdrzone=America/New_York ; or use a specific time zone ; ; 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= ;ssl_cert= ;ssl_key= ; ; You may also configure the field names used in the CDR table. ; [columns] ;static "" => ;alias => alias start => calldate ;alias clid => ;alias src => ;alias dst => ;alias dcontext => ;alias channel => ;alias dstchannel => ;alias lastapp => ;alias lastdata => ;alias duration => ;alias billsec => ;alias disposition => ;alias amaflags => ;alias accountcode => ;alias userfield => ;alias uniqueid =>