Restore CDRs

Hi,

Freepbx 2.10.0.4 on Asterisk 10.3.0. I have used backup and restore to restore a configuration from an identical freepbx version server.

the configuration was copied over perfectly, except the CDRs. There are CDRs in the Master.csv but i cannot see them under the CDR reports of the GUI.

Also, the CDRS in the Master.csv are not the ones from the ‘other’ server i restored but CDRs i have generated myself now through testing.

Any ideas why the CDRs aren’t showing up on the GUI & why the Master.csv was not restored if i did i full system restore and ticked ‘CDRS’?

Notes:

  1. I have made sure MySQL password is /etc/freepbx.conf and is the same password in your cdr_mysql.conf

  2. module show like cdr gives:
    app_cdr.so
    app_forkcdr.so
    cdr_csv.so
    cdr_custom.so
    cdr_manager.so
    cdr_sqlite3_custom.so
    cdr_syslog.so
    func_cdr.so

  3. this is the restore log:

Intialized!!
Intializing Restore…
Running pre-restore hooks, if any…
Restoring files…
/bin/tar: ./etc/dahdi: Cannot mkdir: Permission denied
/bin/tar: ./etc/dahdi/xpp.conf: Cannot open: No such file or directory
/bin/tar: ./etc/dahdi/system.conf: Cannot open: No such file or directory
/bin/tar: ./etc/dahdi/modules: Cannot open: No such file or directory
/bin/tar: ./etc/freepbx.conf: Cannot open: File exists
/bin/tar: Exiting with failure status due to previous errors
File restore complete!
Restoring CDR’s…
Getting CDR size…
Processed 100% of CDR’s!
Restoring CDR’s complete
Restoring settings…
Getting Settings size…
Processed 100% of Settings’s!
Restoring astDB…
Restoring Settings’s complete
Running post-restore hooks, if any…
Cleaning up…
Restore complete!
Reloading…
Done!