Не работают отчеты в FreePBX

[Vlad1983]

нормальные ответы:

Код: Выделить всё

CLI> module reload cdr_addon_mysql.so
    -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend)
CLI> cdr show status

Call Detail Record (CDR) settings
----------------------------------
  Logging:                    Enabled
  Mode:                       Simple
  Log unanswered calls:       No

* Registered Backends
  -------------------
    mysql
CLI> cdr mysql status
Connected to asteriskcdrdb on socket file default using table cdr for 1 days, 5 hours, 25 minutes, 9 seconds.
  Wrote 0 records since last restart.

[Parenek]

Код: Выделить всё

asterisk*CLI> module reload cdr_addon_mysql.so
No such module 'cdr_addon_mysql.so'
asterisk*CLI> cdr show status

Call Detail Record (CDR) settings
----------------------------------
  Logging:                    Enabled
  Mode:                       Simple
  Log unanswered calls:       No

* Registered Backends
  -------------------
    (none)

asterisk*CLI>

Код: Выделить всё

asterisk*CLI> cdr mysql status
No such command 'cdr mysql status' (type 'core show help cdr mysql' for other possible commands)

Код: Выделить всё

asterisk*CLI> module show like mysql
Module                         Description                              Use Count
0 modules loaded

Код: Выделить всё

[root@asterisk ~]# cat /etc/asterisk/cdr_mysql.conf
;
; Note - if the database server is hosted on the same machine as the
; asterisk server, you can achieve a local Unix socket connection by
; setting hostname = localhost
;
; port and sock are both optional parameters.  If hostname is specified
; and is not "localhost", then cdr_mysql will attempt to connect to the
; port specified or use the default port.  If hostname is not specified
; or if hostname is "localhost", then cdr_mysql will attempt to connect
; to the socket file specified by sock or otherwise use the default socket
; file.
;
[global]
hostname = localhost
dbname=asteriskcdrdb
password = fpbx
user = freepbx
userfield=1
port=3306
sock=/tmp/mysql.sock

Код: Выделить всё

[root@asterisk ~]# rpm -qa | grep mysql
mysql-5.0.77-4.el5_6.6
mysql-server-5.0.77-4.el5_6.6
php-mysql-5.1.6-27.el5
asterisk16-addons-mysql-1.6.2.3-1_centos5
mysql-5.0.77-4.el5_6.6
mysql-devel-5.0.77-4.el5_6.6
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-devel-5.0.77-4.el5_6.6

[Vlad1983]

забей в /etc/asterisk/cdr_mysql.conf логин и пароль вы данные по

Код: Выделить всё

cat /etc/amportal.conf | grep AMPDBUSER
cat /etc/amportal.conf | grep AMPDBPASS

заодно проверь вывод

Код: Выделить всё

cat /etc/amportal.conf | grep CDR
# Set Agent Name in CDR dstchannel
QUEUES_UPDATECDR=FALSE
# --- CATEGORY: Remote CDR Database ---
# Remote CDR DB Host
CDRDBHOST=
# Remote CDR DB Name
CDRDBNAME=
# Remote CDR DB Password
CDRDBPASS=
# Remote CDR DB Port
CDRDBPORT=
# Remote CDR DB Table
CDRDBTABLENAME=
# Remote CDR DB Type
CDRDBTYPE=
# Remote CDR DB User
CDRDBUSER=

и заодно

Код: Выделить всё

mysql -uroot -p 
mysql> GRANT ALL PRIVILEGES ON asteriskcdrdb.* TO asteriskcdruser@localhost IDENTIFIED BY 'MYSQLCDRDBPASSWORD';
mysql> flush-privileges;

логин и пароль естественно свои