FreePBX 2.11.0.0beta2.0 + asterisk-11.1.0, CDR not shown reports

General Help
1

CDR reports continue to be written in /var/log/asterisk/cdr-csv/Master.csv
DB asteriskcdrdb tables is empty
Mysql user

[email protected]:/etc/asterisk# cat /etc/freepbx.conf

<?php $amp_conf['AMPDBUSER'] = 'asteriskuser'; $amp_conf['AMPDBPASS'] = 'amp109'; $amp_conf['AMPDBHOST'] = 'localhost'; $amp_conf['AMPDBNAME'] = 'asterisk'; $amp_conf['AMPDBENGINE'] = 'mysql'; $amp_conf['datasource'] = ''; //for sqlite3 require_once('/var/www/freepbx/admin/bootstrap.php'); [email protected]:/etc/asterisk# cat cdr_mysql.conf [global] hostname = localhost dbname=asteriskcdrdb password = amp109 user = asteriskuser userfield=1 ;port=3306 ;sock=/tmp/mysql.sock [email protected]:/var/log/asterisk# mysql -uasteriskuser -pamp109 asteriskcdrdb Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2256 Server version: 5.1.66-0+squeeze1 (Debian) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show tables; +-------------------------+ | Tables_in_asteriskcdrdb | +-------------------------+ | cdr | | cel | | example | +-------------------------+ 3 rows in set (0.00 sec) Simlinks created [email protected]:/etc/asterisk# ls -l | grep www lrwxrwxrwx 1 asterisk asterisk 42 Jan 3 13:09 bkp -> /var/www/freepbx/admin/modules/cdr/etc/bkp lrwxrwxrwx 1 asterisk asterisk 47 Jan 3 12:06 cel.conf -> /var/www/freepbx/admin/modules/cdr/etc/cel.conf lrwxrwxrwx 1 asterisk asterisk 52 Jan 3 12:07 cel_odbc.conf -> /var/www/freepbx/admin/modules/cdr/etc/cel_odbc.conf lrwxrwxrwx 1 asterisk asterisk 62 Jan 2 17:36 confbridge.conf -> /var/www/freepbx/admin/modules/conferences/etc/confbridge.conf lrwxrwxrwx 1 asterisk asterisk 55 Jan 2 17:35 extensions.conf -> /var/www/freepbx/admin/modules/core/etc/extensions.conf lrwxrwxrwx 1 asterisk asterisk 53 Jan 2 17:35 features.conf -> /var/www/freepbx/admin/modules/core/etc/features.conf lrwxrwxrwx 1 asterisk asterisk 48 Jan 2 17:35 iax.conf -> /var/www/freepbx/admin/modules/core/etc/iax.conf lrwxrwxrwx 1 asterisk asterisk 51 Jan 2 17:35 logger.conf -> /var/www/freepbx/admin/modules/core/etc/logger.conf lrwxrwxrwx 1 asterisk asterisk 53 Jan 3 12:12 res_odbc.conf -> /var/www/freepbx/admin/modules/core/etc/res_odbc.conf lrwxrwxrwx 1 asterisk asterisk 48 Jan 2 17:35 sip.conf -> /var/www/freepbx/admin/modules/core/etc/sip.conf lrwxrwxrwx 1 asterisk asterisk 55 Jan 2 17:31 sip_notify.conf -> /var/www/freepbx/admin/modules/core/etc/sip_notify.conf As i understand, in this version FreePBX - cdr_mysql.conf not using, but uses something else.. can someone help?
2

What os are you running I had to compile mine asterisk with cdr_mysql module support and enable cdr loging in cdr.conf

3

OS DEBIAN Squeese 6.0.6

4

help?

5

Have fixed.
I forgot build asterisk with app_mysql and cdr_mysql in menuselect Add-ons. Now it works

6