CDR-Stats will be configured to attach to the asteriskcdrdb database in MySQL installed by the FreePBX installation routine, which contains all the call data records. A connector is installed that takes the CDR from MySQL and imports them into MongoDB in realtime. The web interface for CDR-Stats will be installed on port 8008. Before commencing, a back up of FreePBX, in particular asteriskcdrdb, is recommended.

Also have a note of the FreePBX username and password for MySQL. In later versions of FreePBX, this can be found in /etc/freepbx.conf Run the following commands at the console: cd /usr/src/ wget --no-check-certificate -O install-cdr-stats-asterisk.sh bash install-cdr-stats-asterisk.sh The install routine will ask a number of questions, all of which are self explanatory. Select “Install all” which is option 1 in the CDR-Stats Installation Menu. When completed, move onto is a Registered Trademark of.

The advanced setting module lets you set the location of your. Install a database server on a. Egr Remover Keygen Idm. Now that the cdr database is no longer on the FreePBX.

Test that the ODBC driver is working odbcinst -s -q should result in [MySQL-asteriskcdrdb]. Check the asterisk odbc file, which Asterisk uses to connect to the CDR DB, contains the follow. Nano /etc/asterisk/res_odbc_additional.conf [asteriskcdrdb] enabled=>yes dsn=>MySQL-asteriskcdrdb pooling=>no limit=>1 pre-connect=>yes username=>asteriskuser password=>amp109 Using the above information, test that it can can connect to the DB via odbc isql -v MySQL-asteriskcdrdb asteriskuser amp109 should result in: +---------------------------------------+ Connected! sql-statement help [tablename] quit +---------------------------------------+.

Lastly create or add the following. Note connection=asteriskcdrdb matches [asteriskcdrdb] in res_odbc_additional.conf. Calldate does not exist any more in cdr_adaptive_odbc.so. To have the behaviour the same as standard cdr functions we add the alias start line. Nano /etc/asterisk/cdr_adaptive_odbc.conf [first] connection=asteriskcdrdb table=cdr alias start =>calldate If cdr-mysql module is enabled at the same time as the cdr odbc you will get double entries in the CDR DB. Therefore we need to disable cdr-mysql.