Tariscope 4.x. Administrator's guide
Chapter 3. Tariscope configuration
3.14. Tariscope Observer
3.14.6. MySQL database
If you select the MySQL database data source, the Tariscope window will be as shown in Figure 3.14.6.1.
Figure 3.14.6.1
Now this setting is applied only to received the CDR data from Asterisk.
In the Server name box, type a name of MySQL Server to which the Tariscope Observer service will be connected.
In the User and Password boxes, type accordingly a user name and password which are used to connect to MySQL Server.
In the Database box, type a database name that contains CDR data.
In the Table name box, type a name of table with CDR data.
In the ID Field name box, type a name of the field used in the table as a unique identifier.
If necessary, in the Last ID box, type an identifier of record from which will be read the following table entries.
In the Data Field name box, type a name of the date field in the table of calls stored in the MySQL database.
In the Last Date calendar box, select the time and date from which the data will be taken in handling.
In the Fetch interval box, set the interval time in seconds through that Tariscope Observer will be connected to MySQL server to check new CDR. The default value is 600 seconds.