ZyXEL Communications IP PBX X6004 - Manual (Page 420)

Chapter 28 Call Detail Record (CDR)
X6004 User’s Guide
420
28.2.1 Configure your remote server
The procedure to configure your remote server is as follows:
1
Fill in all fields in the Report > LOGS > CDR > Configuration screen and then
click Download.
2
Save the cdr.sql file to your computer.
3
Make sure the MySQL service is ready on the remote server.
4
Upload the cdr.sql file to your remote server (in the same directory of your
installed MySQL server) and execute the file using the command shown in the first
line of the cdr.sql file. For example, “
mysql -u sqlzyxel -p123456 < cdr.sql”
where
sqlzyxel
is the username and
123456
is the password
.
5
After the script is successfully applied, your MySQL server can work with the
X6004.
Use remote
server Select this to have the X6004 send a record of each call to the remote
MySQL server you specify in the Server field.
Server Type the IP address or the domain name of the server to which you
want to send your CDR files. Then type the port number on which the
remote server receives records of telephone calls from the X6004.
Username Type the username of the account set up on a remote server to which
you want to send your CDR files.
Password Type the password of the account set up on a remote server to which
you want to send your CDR files.
Schema script Click Download to download a SQL script (cdr.sql). Execute the script
in your external database server to establish a database to work with
your X6004.
Apply Click the Apply button to save your changes.
Table 160 CDR > Configuration (continued)
LABEL DESCRIPTION