CustomizeAudioTAPI DevicesTelephonyJournalLicense InterworkingHistoryOutlookWord Document TemplatesLocal Profiles / Terminal ServerNotes
Up

read Asterisk CDR

Page Index

With these settings, you can transfer offline calls from the Asterisk CDRs in the CTI Client journal.

Requirements
1. You need access to the MySQL-Server in Asterisk PBX.
Log in to the Unix command line in MySQL:
mysql -u root -ppassword db
Hints: Between-p and password must be no space. The database 'db' contains the table 'cdr'.

Create a MySQL user with network access rights:

mysql> GRANT SELECT ON db.cdr TO USERNAME@IP IDENTIFIED BY 'PASSWORD';
Example (192.168.1.200 is the IP of your PC):
<font face="Courier New">mysql> GRANT SELECT ON db.cdr TO cticlient@'192.168.1.0/255.255.255.0' IDENTIFIED BY “123456”;
mysql> GRANT SELECT ON db.cdr TO cticlient@192.168.1.200 IDENTIFIED BY '123456';</font>
2. On your computer a MySQL ODBC driver must be installed. See:http://www.google.de/search?q=mysql+odbc+driver ; Tested with the driver version 3.51.28.

3. In [Control Panel / ODBC] You should create an ODBC link in advance (DSN) for your MySQL server.

Select Data Source
Select the previously created ODBC DSN or create a new DSN for the MySQL server.

Upon successful selection the table "cdr" should be displayed below.