Hello good evening,
I have installed Debian 8 with Asterisk 11.21.2. After that I have installed FreePBX 12.0.76.2.
In this moment I have installed the FreePBX module CDR Reports and if I press the “search” button the system doesnt find anything.
In the fist place, from what place takes the info the CDR Reports module? .csv? mysql?
I have check it and it looks like the system takes the info from:
mysql --> asteriskcdrdb --> cdr
I have configured this files and now the module “CDR Reports” show the info related with the calls:
/etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1
odbc.ini
[MySQL-asteriskcdrdb]
Description=MySQL connection to ‘asteriskcdrdb’ database
driver=MySQL
server=localhost
database=asteriskcdrdb
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3
[MySQL-asterisk]
Description=MySQL connection to ‘asterisk’ database
driver=MySQL
server=localhost
database=asterisk
Port=3306
Socket=/var/run/mysqld/mysqld.sock
option=3
res_odbc.conf
[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
pooling=>no
limit=>1
pre-connect=>yes
username=>asteriskuser
password=>xxxxxxxx
cdr_odbc.conf:
[global]
dsn=asteriskcdrdb
loguniqueid=yes
table=cdr
dispositionstring=yes
usegmtime=no
hrtime=yes
cdr_adaptive_odbc.conf
[asteriskcdr]
connection=asteriskcdrdb
table=cdr
alias start=calldate
By the way, if does have sense to have cdr_odbc.conf and cdr_adaptive_odbc.conf at the same time?
What are the differences between both?