ShoreTel PBX

...

...

By default, the ShoreTel phone system writes its CDR data to a MySQL Database,  database called

The following information is required for TIM Plus to connect successfully to the Shoretel ShoreWareCDR database:

• IP /DNS address or hostname of the MySQL Database which is located on the ShoreWare Server where the MySQL database resides.
• Username and Password to connect to of the 

  Referencemacro
  Label ShoreWareCDR

   database.

The default credentials for the ShoreWareCDR database

...

are shown below:

<a id="Set up a DSN connection"></a>

...

To enable TIM Plus to work with your ShoreTel phone system, you first need to set up a DSN connection . For instructions on how to do this, follow the instructions by following the steps below:

1. Click on Windows Start.
2. Click on Control panel.
3. Double click on Administrative tools icon.
4. Double click on Open Windows Control Panel and select the

   Buttonmacro
   Label Administrative Tools

    icon

5. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window

   Info
   For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

6. Click on the System DSN tab.
7. Click on the Add button.
8. Select MySQL ODBC 3.51 Driver from the driver list and click Finish. If you cannot see the MySQL ODBC 3.51 Driver option in the drop-down list, you can download this it from http://www.mysql.com.
9. In the Name field, enter shoretel.
10. In the Description field, enter TIM Plus link to ShoreTel.
11. In the Server field, enter the IP address or hostname of the your ShoreWare Server.
12. In the Username field, enter the username for your ShoreWareCDR database.
13. In the Password field, enter the password for your ShoreWareCDR database.
14. In the Database drop-down list, select ShoreWareCDR.
15. Click on the Test button to confirm the information you entered is correct and that the connection is successful.
16. Click on the OK button to close the window.
    
    

An example of an ODBC setup entry is shown below:

...

Once the DSN connection has been setupset up, log in to TIM Plus and perform the steps below:

1. Click on the Directory tab.
2. Choose the site you want to configure and click on Properties.
   

   Screenshotmacro
   Border false URL /download/attachments/4817113/shoretel_2.png

3. In the Site Properties window, select ShoreTel from the PBX model drop-down list.
4. In the Connection method field, select Connect to a system DSN from the drop-down list.
5. In the DSN name field, select ShoreTel from the drop-down list.
6. In the Frequency field, enter 5.
7. In the DB script field, select ShoreTel from the drop-down list.
8. Click on the Save button to apply the settings.