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.
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.
I’m having the same problem right now. It seems it started after upgrade. Do you write to .csv or mariadb or where?
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…
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2019-01-24 14:21:47
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
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.
Try from Asterisk cdr
module load cdr_manager
post the response
here you go, thanks.
*CLI> module load cdr manager
Usage: module load
Loads the specified module into Asterisk.
This is talking about FreePBX 12. Has nothing to do with MariaDB
you missed the _
but then try
cdr show status
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
Then you would need to post the contents of your
/etc/asterisk/cdr_manager.conf
Well it appears that you are on to something here… /etc/asterisk/cdr_manager.conf does not exist???
Put
[general]
enabled = yes
In it
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.
Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2019-01-28 20:40:48
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No
Thank you.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.