Missing CDR Information

[mc6650]

Hello

I posted this earlier and received some limited help, so I'm re-posting hoping that someone could kindly point me in the right direction regarding how I can correct this. Thanks.

Weirdly the CDR has stopped updating since Nov 27, 2024. When I refresh the report, I don't see any calls after Nov 27, 2024. Could someone please advise me of how I can see the number? If I look at the log file (Status > Log Viewer) I see the following entry:

bc85eed8-e969-40f9-bdde-6fd5eb704a92 2025-01-21 16:50:59.881036 97.57% [DEBUG] mod_dptools.c:1685 SET sofia/internal/202@azlan.fusionpbx.ca [caller_destination]=[7057346363]

However if I look at the GUI CDR:

From Advanced > Default Settings > CDR

How can I correct this? Thanks in advance for any help that can be provided.

 

[MrObscured]

Hi,

What method are you using for the CDR's?

If you are not running the xml cdr service I advice you to take a look in xml_cdr.conf.xml to see if the HTTP POST might be disabled.

Commented out line for disabling HTTP POST:
<!-- <param name="url" value="http://127.0.0.1/app/xml_cdr/v_xml_cdr_import.php"/> -->

Remove <!-- and --> to have it enabled.

Restart XML CDR:
fs_cli -x 'reload mod_xml_cdr'

Best of luck!

 

[mc6650]

It looks like I'm running the xml cdr service?

pbx2@FushionPBX:~$ fs_cli -x 'show modules' | grep xml_cdr
generic,mod_xml_cdr,mod_xml_cdr,/usr/lib/freeswitch/mod/mod_xml_cdr.so

 

[markjcrane]

If you do have this commented out

<!-- <param name="url" value="http://127.0.0.1/app/xml_cdr/v_xml_cdr_import.php"/> -->

Then the call detail records should be saved to the following directory.

cd /var/log/freeswitch/xml_cdr
ls -lh

If you see files in the directory they are waiting to be imported into the database. If there are none then you need to look at the following file and comment out the URL line as shown above and also mentioned by @MrObscured. After that you need to run reloadacl this can be done from the Menu -> Status -> SIP Status then restart the xml cdr module. This can be done from Advanced modules or the command line reload mod_xml_cdr

/etc/freeswitch/autoload_configs/xml_cdr.conf.xml

 

[mc6650]

Hello. Thanks for the help and sorry for the delay in posting a response.

Here is what I now have in /etc/freeswitch/autoload_configs/xml_cdr.conf.xml

   <!-- <param name="url" value="http://127.0.0.1/app/xml_cdr/xml_cdr_import.php"/> -->

I restarted the mod_xml_cdr in Advanced > Modules > XML Interfaces > XML CDR > Stop then Advanced > Modules > XML Interfaces > XML CDR > Start

There are calls showing in the log:

pbx2@FushionPBX:/var/log/freeswitch/xml_cdr$ ls -lh
total 196K
-rw-rw---- 1 www-data www-data 23K Feb 12 09:39 a_4166ab44-cdff-43cf-851f-cb7cd6e92c2f.cdr.xml
-rw-rw---- 1 www-data www-data 23K Feb 8 09:31 a_4efa5162-4b06-4f34-9387-66ccdb0f637e.cdr.xml
-rw-rw---- 1 www-data www-data 23K Feb 8 09:31 a_53dfab2d-f1dc-495e-b2c0-676cf2e01573.cdr.xml
-rw-rw---- 1 www-data www-data 23K Feb 12 09:49 a_5dfee895-bf7a-46f7-90a7-2212d928d833.cdr.xml
-rw-rw---- 1 www-data www-data 23K Feb 12 09:53 a_6e3aac80-9041-4d6f-9b85-39e242258b9c.cdr.xml
-rw-rw---- 1 www-data www-data 23K Feb 12 09:38 a_78592737-c029-40d4-a7f5-6e5422dc2c20.cdr.xml
-rw-rw---- 1 www-data www-data 24K Feb 12 09:53 a_d58190dc-b620-47d8-865d-521e88d8fac8.cdr.xml
-rw-rw---- 1 www-data www-data 24K Feb 12 09:54 a_f69139fc-0005-46d3-a824-36532bd6e1d3.cdr.xml
drw-r----- 2 www-data www-data 4.0K Nov 8 2023 failed

However I'm still seeing the old records in my user profile:



Any advice you can give me would be helpfull. Thanks.

 

[markjcrane]

Install the xml_cdr service here using the following commands.

cp /var/www/fusionpbx/app/xml_cdr/resources/service/debian.service /etc/systemd/system/xml_cdr.service
systemctl enable xml_cdr
systemctl start xml_cdr
systemctl daemon-reload

This is documented in more detail in the upgrade instructions for 5.1 to 5.2.
https://docs.fusionpbx.com/en/latest/advanced/version_upgrade.html#version-5-1-to-5-2

 

[mc6650]

Excellent. Thanks Mark & MrObscured. It's now working. Thanks very much for the help.

Michael