Specifications

Call Detail Record Reports
C – 8 ShoreTel, Inc.
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
tmp_table_size = 30M
key_buffer_size=2M
read_buffer_size=2M
read_rnd_buffer_size=2M
sort_buffer_size=2M
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=5M
innodb_buffer_pool_size=150M
innodb_log_file_size=24M
default-storage-engine=INNODB
Step 9 Delete the file ib_logfile* from the Secondary server directory
(c:\Program Files\MySQL\MySQL Server 5.0\Data).
Step 10 Check that innodb_flush_log_at_trx_commit=0 on Secondary server
c:\windows\my.ini file. If the value is not zero, archiving write
operations will be more than 20 times slower.
Step 11 Select Start->Administrative Tools->Services->MySQL
Step 12 Click “Restart the service” and verify that MySQL service comes back
up
To convert the Secondary server database into an archive database, perform the
following procedure
Step 1 Verify the following files are placed in an equivalent location on the
Secondary Server to that on the Main servers (default location is
\\Shoreline Communications \\ Shoreware Server)
• MakeCDR.dll
• MakeCDR.sql
• MakeCDR_sp.sql
• MackCDRArchive.exe
Step 2 Run MakeCDRArchive –d databasename, where databasename is the
name of the archive database to be created.
Access the Reporting Options panel in ShoreWare Director (Reporting | Options from
the Menu panel) to configure the name of the archive database within ShoreWare.
Importing Access Database Files into MySQL Format
When an existing system is upgraded to ShoreTel 7 from a prior release, CDR data is
stored in the MySQL format. However, CDR data that was saved prior to the upgrade is
stored in the Microsoft Access database files created by the JET database management
system. This preexisting data will not appear in the web-based reports generated by
Director unless the older data is imported from Microsoft Access to MySQL format.