Migrating Sonata Records from VPBX 3.2 to 4.5

Sonata Suite
1

Is there a procedure for manually migrating Sonata Recordings? Due to some errors on a VPBX 3.2 installation I am having to move a client from Centos7 + VPBX 3.2 to a new Debian 12 +4.5 install, but despite all my efforts none of the records are appearing in the GUI.

Update: figured it out. It was an involved process but it’s now working.

2

Can you please share with everyone what the problem was and how you solved it? Thanks

3

You can take backup from v3 and restore to v4 without including the recording

Then scp them manually from /var/spool/asterisk/monitor

4

My problem was that something broke after I interrupted a software update, and I did not want to use the available backup because of some weirdness in not being able to delete a stubbornly undeletable extension because VPBX thought it was in use by a time condition (it wasn’t). I saw it as an opportunity to start fresh, but this client had years of recordings. The whole process was less complicated than I thought it might be.

  • On the old server, did a mysqldump of the asterisk cdr > cdr.sql
  • Moved an external virtual volume of the recordings to a new server, created a symlink to “monitor” on the volume
  • On the new server, imported the cdr.sql file into asterisk mysql -u root -p asterisk < /tmp/cdr.sql

The client wasn’t rating calls or attaching notes, so there was really nothing in rec_recordings.

1 Like
5

Fortunately, monitor was on an external volume attached to the VPS. Just needed to reset the top level permissions after I moved the volume to the new server.

Sometimes I love diving in and doing things manually. Other times I wish I could sell this business and relax a little more!