ShoreTel PBX

...

...

Configuring your SMDR output

By default, the CDRs are written to the MySQL Database.The database that TIM Plus will connect to is called 'ShoreWareCDR'. You will ShoreTel phone system writes its CDR data to a MySQL 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 will first need to set up a DSN connection . Below you will find instructions on how to do this within Microsoft Windows:

...

by following the steps below:

1. Open Windows Control Panel and select the

   Buttonmacro
   Label Administrative Tools

    icon

2. 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

3. Click on the System DSN tab.
4. Click on the Add button.
5. 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.
6. In the Name field, enter the following: shoretel.
7. In the Description field, enter the following: TIM Plus link to ShoreTel.
8. In the Server field, enter the IP Address address or hostname of the your ShoreWare Server.
9. In the Username field, enter the username for your ShoreWareCDR database.
10. In the Password field, enter the password for your ShoreWareCDR database.
11. In the Database drop-down list, select ShoreWareCDR.
12. Now, click Click on the Test button to confirm the information you entered is correct and whether that the connection is successful.
13. Click on the OK button and then again to close the window.
    

The 

An example of an ODBC setup entry is shown below:

...

Once the DSN connection has been setupset up, log on in to TIM Plus as usual and apply perform the following settingssteps below:

1. Click on the Directory tab.
2. Select Choose the site configured during the setup wizard you want to configure and click on Properties.
   

   Screenshotmacro
   Border false URL http://docs.tri-line.com:8090/download/attachments/4817113/shoretel_2.png

3. Within 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 in 5.
7. In the DB script field, select ShoreTel from the drop-down list.
8. Finally, click Click on the Save button to apply the settings.