I have two servers up and running on identical versions of FreePBX and all modules. I used the backup and restore module to backup every module and ran a restore, and it worked for the most part. I had to reinstall a couple modules, no big deal.
What’s failing right now is the CDR database. See below:
[root@freepbx ~]# fwconsole backup --restore /var/spool/asterisk/backup/uploads/20220317-165656-1647561416-15.0.23-1340680487.tar.gz
Transaction ID is: 11859018-5ec0-46d0-acec-f13bacd0fb9e
Determining backup file type...type is current
Starting restore job with file: /var/spool/asterisk/backup/uploads/20220317-165656-1647561416-15.0.23-1340680487.tar.gz
Extracting Backup
Extracting backup...
Processing cdrResetting cdr module data
Checking if field cnum is present in cdr table..OK!
Checking if field cnam is present in cdr table..OK!
Checking if field outbound_cnum is present in cdr table..OK!
Checking if field outbound_cnam is present in cdr table..OK!
Checking if field dst_cnam is present in cdr table..OK!
Checking if field linkedid is present in cdr table..OK!
Checking if field peeraccount is present in cdr table..OK!
Checking if field sequence is present in cdr table..OK!
Generating CSS...Done
Restoring from cdr [FreePBX\modules\Cdr\Restore]
CDR table Restore Error The command "/usr/bin/mysql --host localhost --port 3306 --user freepbxuser -pjdC5iryMenUz asteriskcdrdb < /tmp/backup/11859018-5ec0-46d0-acec-f13bacd0fb9e/files/tmp/dbdump/cdr.sql" failed.
Exit Code: 1(General error)
Working directory: /root
Done
Restore processing for modules are finished successfully
Apache will Restart now... And your GUI may die if the ports are changed !!!!
Reloading...... DONERunning Post Restore Hooks.. Please note that hook will restart httpd service so please refresh your page (using new ports)
Running Post Restore Hooks DONE
Finished
Restore completed successfully
I’m not sure where it is getting that password for freepbxuser - it’s not the correct password on either of the servers. I suppose I can force the password to be that and update freepbx.conf but there has to be some problem that caused this in the first place.