Asterisk 14 CDR with mysql and or mariadb HELP


#1

Hello I am new here, i am Remon from Holland.
I have problems to get cdr working, to log my call data in to a database.
Long time ago i get it work with mysql with no problem. Now i have asterisk 14 running (and i am installing asterisk 15 on an other sytem, to experiment). Now i need to configure cdr with mysql an mariadb, but i can’t get it work.
I have followd this side: https://www.mikeslab.net/asterisk/linux/2015/01/19/ubuntu-14-04asterisk-13-cdr-reporting-to-mysql.html
I have a raspberrypi with debian image where i installed asterisk. Now i have i think problems with odbc…
Before i write the complete story and give al de settings information i first want to ask if there is some who want to help me to configure the cdr to store te calll details in to a database. I tried a lot but no succes.
Hope some one can help…
Thanks
Remon


#2

see CDR show status and checked for registered backends


#3

CDR show status:

Call Detail Record (CDR) settings

Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

  • Registered Backends

    cdr-custom
    Adaptive ODBC
    ODBC
    cdr_manager

When i did a call:

WARNING[1184]: res_odbc.c:962 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/odbc/libmyodbc5S.so’ : file not found

the file does exist. I tried to install libmyodbc in some otherway, download and coppy it to this directory.
Do i need this for CDR. Some time ago i only need mysql.


#4

use ODBC and please show me the configuration of odbcinst.ini file and odbc.ini and hide your credentials for your security


#5

I have this in my /etc/odbcinst.ini:

[Default]
Driver = /usr/lib/odbc/libmyodbc.so

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/odbc/libmyodbc5S.so
;Setup = /usr/lib/odbc/libodbcmyS.so
Setup = /usr/lib/arm-linux-gnueabihf/odbc/libodbcmyS.so
;FileUsage = 1

Now i find out i didn.t have cdr_mysql selected when i start make menuselect, i can’t select it. so i was google to find out what i need to install so i can select cdr_mysql in make menuselect.
After a search i installed default-libmysqlclient-dev and now i can select cdr_mysql !! i hope this wil help for cdr… i am working on it now


#6

No use of install cdr_mysql as I mentioned you use ODBC and you have the backend registered already Adaptive ODBC and you must have cdr_adaptive_odbc and cdr_odbc selected in make menusleect and whcih looks good.

Issue seems with your ODBC configuration which you pasted here and you did not send the conf of odbc.ini also which should match


#7

this is not needed, for sure you will need res_odbc.so, cdr_odbc.so


#8

well cdr_adaptive_odbc and cdr_odbc are selected in make menuselect. i don’t understand the different between mysql en odbc. before this i always used only mysql and that works fine for me. the solution what i wrote before to insall mysql worked and now the call data is written to the database without odbc, i have only de odbc errors beceause i have some settings for odbc…
I don’t know what i should do, keep using mysql what is working now (like the old way) or keep on setting up with de odbc stuff.


#9

mysql_cdr it is deprecated


#10

Ok clear! Well it is stil working in V14, i wil install V15 in the next day’s! is there a good discription how to configure CDR whith odbc?
Or i we can do it here (you help me good so far).


#11

http://asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html