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