Hi, I have been using freepbx 15 for a long time and now I want to switch to version 17. Please tell me how I can do this with minimal downtime? Restoring from backup takes more than an hour, during which time calls can still be received on the old freepbx 15. I am interested in how to transfer the recordings of these calls and cdr so that the new server does not lag behind the old one. Unfortunately, there is no way to turn off the old server while restoring from backup.
You can use MySQL to dump the cdr and cel tables with a where clause to grab those records after the restore, and copy the recordings over with rsync.
Thanks for your answer, it turns out that the logs are stored only in the cdr and cel tables? And what is the transient_cdr table for then, I noticed that it appeared in freepbx 17, in 15 there was no such table. After restoring from backup, this table contains records, apparently matching the records in the cdr table.
The transient_cdr table is a poor work around to not having proper CDR retention logic in FreePBX. It holds the last 60 days of CDR records so the API and other queries don’t get bogged down by a massive CDR table.
Of course, if you need more than 60 days…you still have to do with a massive CDR table.
Thank you, please tell me how the transient_cdr table is cleared? I didn’t find it in the cron.
Don’t know. Would have to look closer at the code.
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.