SOLVED No Call detail or recordings in GUI after update

[timerider]

Two servers here, one of them gave an error (due to me stupidly not checking disc space!) This sent me on a troubleshooting evening.
The other server is however exhibiting the same behaviour after recent update (and had plenty space!)

Actually, I'll edit to say that call logs are there, but only up to the 24th when I updated, same on other server.
Call recordings also show up to the same date, they are however in the filesystem when I look manually.

I'll detail the *failed* apt update log here just in case, but I suspect it's not at all relevant as the other server is showing the same behaviours.

Setting up postgresql-17 (17.0-1.pgdg110+1) ...
Creating new PostgreSQL cluster 17/main ...
/usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/17/main ... ok
initdb: error: could not create directory "/var/lib/postgresql/17/main/pg_wal": No space left on device
initdb: removing contents of data directory "/var/lib/postgresql/17/main"
Error: initdb failed
Error: could not create default cluster. Please create it manually with

pg_createcluster 17 main --start

or a similar command (see 'man pg_createcluster').
Setting up postgresql-16 (16.4-1.pgdg110+2) ...
Setting up postgresql (17+264.pgdg110+1) ...

5.3.3
Git Information	Branch: master Commit: fbb254c3db6e45159e484470e047ccc2b1b8f29e Origin: https://github.com/fusionpbx/fusionpbx Status: Your branch is up to date with 'origin/master'. +0 days ago
Project Path	/var/www/fusionpbx
Switch Version	1.10.9 (64bit)
Switch Git Information	unknown
PHP Version	7.4.33

 

[markjcrane]

First off make sure you upgrade schema or upgrade.php.

Then use this link to enable CDR
- https://www.pbxforums.com/threads/crd-logs-and-recordings-not-showing-in-portal.8078/post-32553

 

[timerider]

No difference, xml_cdr had the updated URL already, though my crobtab didn't have the job mentioned. Reloaded and restarted, and now rebooting..

Call counts from the gui show as zero, almost certainly a database issue.

These things always come around when we've got too much on already!

 

[timerider]

I'm seeing call logs, and recordings, but nothing new since I updated on the 24th

 

[markjcrane]

Check if you see call detail record XML files in this directory.

ls -lh /var/log/freeswitch/xml_cdr

 

[timerider]

Check if you see call detail record XML files in this directory.

Nothing in there..

 

[markjcrane]

FreeSWITCH first writes a call detail record to the file system. FusionPBX then reads it using the cron job or service and loads it into the database. So use crontab to disable that service then make a phone call. If you make a call then you don't see a call detail record written to the file system then you have a problem with mod_xml_cdr.

crontab -e

FusionPBX itself doesn't create this file it only reads it and imports the details into the database.

 

[timerider]

Interesting it's happening on both systems. I ran apt-update as well as fusion upgrades, but no update to freeswitch in there. Fusion says xml-cdr is running. I'll take a closer look at xml-cdr.conf.xml. strange I'm not seeing others with the same issue.

Can you post your XML.conf so I can compare?

 

[timerider]

After much messing on, and lots of confusion with xml_cdr Vs cdr_xml, it's working,

I realised that the 'edit XML to look like' in the referred post would have been better worded as 'comment out'.

Commented and shortly after, new calls are now showing.

I'd commented the original, then added the same, without the comment!

No way I can pull in the other calls that are in the filesystem recordings?

Consider this solved and a misunderstanding on my behalf!