Chapter 27 Call Detail Record (CDR)
X2002 User’s Guide
394
Another way to deal with the limited capacity on the local CDR database of the
X2002 is to actively manage the CDR database. This requires you to create
backups of the CDR database and send them to an administrator via e-mail.
Viewing Aged Files
An “Aged File” is a compressed file with the extension “.tgz”. “.tgz” files can be
decompressed with data compression utilities for example WinRAR or WinZIP. The
result of decompressing this file are three files which can then be managed via a
MySQL Database Management System (DBMS). The three files are:
•
cdr.MYD
- a MySQL data file.
•
cdr.MYI
- a MySQL index file.
•
cdr.frm
- a MySQL format file.
CDR Database Management via MySQL
MySQL is a database management system based on SQL (Structured Query
Language). You can configure a MySQL server to collect CDRs from the X2002 and
expand the capacity of telephone records you can collect and review.
27.2 The Configuration Screen
Use this screen to set up an external server to collect CDR information. You can
also configure an administration e-mail address to which to send alerts and CDR
files for later viewing.
Note: You should use a MySQL server 5.0 or above for the remote server.
You must execute the SQL script downloaded from this screen on your MySQL
server before the X2002 starts to work with the remote server. See
for information on configuring your remote server.
Summary of Contents for X2002
Page 2: ......
Page 24: ...Table of Contents X2002 User s Guide 24...
Page 25: ...25 PART I User s Guide...
Page 26: ...26...
Page 40: ...Chapter 2 How It Works X2002 User s Guide 40...
Page 99: ...99 PART II Technical Reference...
Page 100: ...100...
Page 124: ...Chapter 5 Network Deployment X2002 User s Guide 124...
Page 166: ...Chapter 7 Auto Provision X2002 User s Guide 166...
Page 170: ...Chapter 8 QoS X2002 User s Guide 170...
Page 248: ...Chapter 16 Click To Talk Group X2002 User s Guide 248...
Page 252: ...Chapter 17 Group Access Code X2002 User s Guide 252...
Page 304: ...Chapter 19 Auto Attendant X2002 User s Guide 304...
Page 312: ...Chapter 20 LCR X2002 User s Guide 312...
Page 346: ...Chapter 22 Call Services X2002 User s Guide 346...
Page 380: ...Chapter 25 Status Observation X2002 User s Guide 380...
Page 402: ...Chapter 27 Call Detail Record CDR X2002 User s Guide 402...
Page 410: ...Chapter 28 ACD Logs X2002 User s Guide 410...
Page 416: ...Chapter 29 Administrator Accounts X2002 User s Guide 416...
Page 424: ...Chapter 30 Diagnostics X2002 User s Guide 424...
Page 426: ...Chapter 31 X2002 User s Guide 426...
Page 446: ...Chapter 32 Remote Management X2002 User s Guide 446...
Page 448: ...Chapter 33 TFTP Management X2002 User s Guide 448...
Page 462: ...Chapter 35 License Control X2002 User s Guide 462...
Page 482: ...Chapter 36 Web Portal X2002 User s Guide 482...
Page 508: ...Chapter 39 Product Specifications X2002 User s Guide 508...
Page 548: ...Appendix C Legal Information X2002 User s Guide 548...
Page 562: ...Index X2002 User s Guide 562...