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

See also

• Asterisk cdr mysql: More information on Asterisk and Mysql for billing
• Asterisk billing
• Asterisk config files