Com.X Administrator Guide
Page 177
on each extension to an appropriate value. The account code is then stored in the
CDR, while the upstream telco is presented with the CID as configured on the trunk.
A results summary is displayed at the bottom of the list, where navigation of the list is
also facilitated. CDR records are stored in a database on the Com.X and can be
backed up. Please see 2.2.1.1.4 for more detail on backing up the CDR database.
Call reports can also be exported to Portable Document Format (PDF) or in Comma
Separated Values (CSV) format for further processing.
Figure 99: CDRs can be exported in CSV or PDF format.
5.3.2 Enabling logging to CSV
To enable logging of all CDRs to /var/log/asterisk/cdr-csv/Master.csv, uncomment the
'enable=yes' line in /etc/asterisk/cdr.conf. Please see section 6.1.2.3 for details re:
editing system files.
5.3.3 Accessing the CDR database
To access the records in the MySQL CDR database remotely, the Com.X needs to be
configured to allow an external user access.
1. Configure the Com.X to allow remote connections to the MySQL server by
editing /etc/mysql/my.cnf and changing the
bind-address
field to 0.0.0.0
Note: This poses a security risk and remote access should be restricted by a proper
firewall.
2. Restart the MySQL server:
sudo /etc/init.d/mysql restart
3. Restart the comma-gui service:
sudo /etc/init.d/commagui restart
4. Log into the mysql server as root from the Com.X console:
mysql u root
5. Configure a cdruser with read access to the CDR database:
GNT SELECT ON asteriskcdrdb.* TO cdruser@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
6. ConfigurX your SQL client to point to the server, with username cdruser and
the password as configured, on the default port 3306, and with database
schema asteriskcdrdb.
5.4 Monitoring of remaining capacity on the unit
©2010 –
2016
Far South Networks
