CDR reports (do i have to setup something before?)

[Croissantisokay]

Hello ! I’m trying to understand how CDR report work.

I just did a call with my personnal phone with my Asterisk server and hangup after 20-30secondes.

I was thinking that the details/records/… of the calls will be in the “CDR reports” section, but after a general search, no calls are in the reports, did i miss something?

Hope, someone know something about my problem, cya !

[Croissantisokay]

Forgot the screen…

[Stewart1 (Stewart)]

I have no idea what may be wrong, but it’s interesting that another gentleman seems to be having the same issue:

CDR database empty

I have searched quit a bit regarding my issue. Here is my system info: Current PBX Version:14.0.13.4 Current System Version:12.7.3-1707-3.sng7 The issue I am running into is that my CDR table is no longer being updated. This started a while ago, but I don’t know when so I don’t have an event which kicked off the problem. I have confirmed that I can open the database and the cdr table from the CLI so I know I have correct credentials. It seems it’s been over a year since the last entry. As a …

However, you also have csv enabled, so I’m curious if you have files in
/var/log/asterisk/cdr-csv
and if calls are being logged to Master.csv .

That may tell us whether this is a database issue, or Asterisk failing to send CDR data at all.

[Croissantisokay]

Yes, i have somes logs in “”/var/log/asterisk/cdr-csv"" of all calls i made.

But i think my problem come from my sql server

GooPics - Album d'images

[dicko]

Maybe

CDR database empty

Got it! There were apparently two issues. My odbc.ini file was bad. The first line of my odbc.ini file was: odbc.ini[MySQL-asteriskcdrdb] I removed “odbc.ini” from that first line. and records began to appear in the cel table I didn’t actually have a file called cdr_odbc.conf I created a cdr_odbc.conf file with the following line in it #include cdr_ adaptive_odbc.conf With that change the cdr table began to populate. I never had made any changes to these files so likely some update ca…

is helpful

[Croissantisokay]

i think this was helpful because i got the same thing, but the CDR still not working, is that coming from my mysql serv? Did i miss something to load it?

“asterisk -rcvvvv” keep telling me

– Remote UNIX connection
– Remote UNIX connection disconnected
– Remote UNIX connection
– Remote UNIX connection disconnected
– Remote UNIX connection
– Remote UNIX connection disconnected

when i load my “CDR report” page

[dicko]

module show like cdr

You are looking for

cdr_adaptive_odbc.so

[Croissantisokay]

I updated many odbc folders and i thinks they are good.

But now when i’m trying to verify is my FreePBX can connect to the remote database and i got this :

[Croissantisokay]

Ok i edited some more and i got this now…

I am making some progress, or i am in the wrong way?

[Croissantisokay]

Some more progress

I tried a voice call of 7secondes and still don’t have any reports.
I don’t know what’s wrong

[Croissantisokay]

Maybe my addons aren’t okay? How can i check that?

[Croissantisokay]

Today i’m trying to do this : https://fabblog.fabaur.fr/asterisk-cdr/

But when i’m trying to make the Makefile, there is many errors (200+)

Does my .c files are broken?

I founded many logs in /var/log/asterisk/cdr-csv/Master.csv.

I’m pretty lost, how can i get calls record and thoses logs in my FreePBX GUI ??

[Croissantisokay]

I think i’m really close to it, but i need a little help for the detail i miss. Can someone have an idea please? I need this CDR reports to be on service to do WebRTC.

Hope someone know what’s wrong and have the time to help me

[Croissantisokay]

Changed some odbc files and check some modules status.

my ODBC DSN return a fail connection. The issue come from this, but my config seem good??

[Croissantisokay]

Any chance to have help ?