1 You need access to the MySQL server of your 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):
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';
2. A MySQL ODBC driver must be installed on your computer. 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.