Asterisk config cdr_mysql.conf

Configuration of database for billing with CDR records

Sample cdr_mysql.conf

This is a sample configuration that assumes the SQL server is local.

;
; 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”, 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=localhost
dbname=asteriskcdrdb
password=password
user=asteriskcdruser
table=cdr
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

Enable the last option if you wish to use SetCDRUserField
The file mysql.sock is only present while the mysql server is up and running. Here’s how to find it:
Either check your mysql configuration, or do

locate mysql | grep sock