Tariscope 4.5.x. Administrator's guide
Chapter 4 Tariscope configuration
4.13. Tariscope Observer
4.13.6. MySQL database
If you select the MySQL database data source and click on the Data source configuration button (Figure 4.13.2), the Data source configuration window appears as shown in Figure 4.13.6.1.
Figure 4.13.6.1
Now this setting is applied only to receive the CDR data from Asterisk.
Click on the Click here to change the server connection link. The Data source configuration window will expand. The new part of window appears as shown in Figure 4.13.6.2.
Figure 4.13.6.2
In the MySQL Server box, type a name of MySQL Server or its IP address to which the Tariscope Observer service will be connected.
In the Database name box, type the database name. For Asterisk it is asteriskcdrdb.
In the User and Password boxes, type a username and password which are used to connect to MySQL Server.
Click Save. The additional part of the window will be hidden.
In the Table name box, type the table name with CDR data. For Asterisk it is cdr.
In the ID Field name box, type a name of the field used in the table as a unique identifier. Use the uniqueid name for Asterisk.
In the Date Field name box, type a name of the date field in the table of calls stored in the MySQL database. It is calldate for Asterisk.
In the Date of last ID calendar box, the appropriate date and time will be displayed.
In the From date calendar box, select the time and date from which the data will be taken in handling.
In the Interval box, set the interval time through that Tariscope Observer will be connected to MySQL server to check new CDR. The default value is 600 seconds: 00:10:00
Click Done to keep settings.
