CDRs are not created

General Help
1

FreePBX v12.0.76.6
Asterisk v13.6.0

No CDRs are being generated on this system. Any guidance to fixing this would be greatly appreciated.

Thank you.

2

I’m having the same problem right now. It seems it started after upgrade. Do you write to .csv or mariadb or where?

3

quite honestly I am not sure, I am just using a default install. But it should be writing to mysql correct? I don’t think my odbc connection is working correctly, see below…

Call Detail Record (CDR) settings

Logging: Enabled
Mode: Simple
Log unanswered calls: No

  • Registered Backends

    ODBC
    Adaptive ODBC
    cdr-custom

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2019-01-24 14:21:47

4

Yep. That’s exactly what I’m struggling with.

if you see this in asterisk -x “odbc show”, then you have the same problem.
Last fail connection attempt: 2019-01-22 17:38:43
Number of active connections: 0 (out of 5)

I found in other post that mysql might be deprecated, but didn’t find other solution yet. Would you be able to send /etc/odbcinst.ini and /etc/odbc.ini? - CHANGE/REMOVE credentials before sending it here.

I was also using command isql -v asteriskcdrdb cdruser password to check if I can connect.

This could also help asterisk -x “module show like mysql”

I’m using odbc and it is loaded.
module show like cdr_odbc.so
Module Description Use Count Status Support Level
cdr_odbc.so ODBC CDR Backend 0 Running extended
1 modules loaded

5

MySQL is deprecated and has been replaced with MariaDB. This normally doesn’t have an effect on the system - MySQL and MariaDB can use the same drivers.

There was a maria-db connector thing posted a couple of days ago (look for posts from @lgaetz or @tm1000) that might help.

6

Try from Asterisk cdr

module load cdr_manager

post the response

7

here you go, thanks.

*CLI> module load cdr manager
Usage: module load
Loads the specified module into Asterisk.

8

This is talking about FreePBX 12. Has nothing to do with MariaDB

9

you missed the _

but then try

cdr show status

10

I did indeed, good call.

*CLI> module load cdr_manager
Unable to load module cdr_manager
Command ‘module load cdr_manager’ failed.
[2019-01-24 21:12:09] WARNING[3250]: cdr_manager.c:214 load_config: Failed to load configuration file. Module not activated.
== Unregistered ‘cdr_manager’ CDR backend

11

Then you would need to post the contents of your

/etc/asterisk/cdr_manager.conf

12

Well it appears that you are on to something here… /etc/asterisk/cdr_manager.conf does not exist???

13

Put

[general]
enabled = yes

In it

14

Ok, so I just got back and had the opportunity to do this. Is this all that goes in /etc/asterisk/cdr_manager.conf? The file did not exist, so I created it and added
[general]
enabled = yes

but still no love. Also, I don’t think my ODBC is connected.

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2019-01-28 20:40:48

Call Detail Record (CDR) settings

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

  • Registered Backends

    cdr_manager
    Adaptive ODBC
    cdr-custom

Thank you.