Child pages
  • Upgrading from sipFoundry Canary to sipXcom

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Install a server with sipXcom ISO
  2. Create a backup of the sipFoundry Canary system through the UI
  3. Restore that backup to the new sipXcom server through the UI.  Note that although the restore should work, there will still be issues with the DB due to incompatible table names and columns related to the E911/Emergency Dialing functionality.  This DB incompatibility will need to be manual corrected as show in step 4.
  4. Correct DB compatibility issues relating to E911/Emergency Dialing as follows:
  • Code Block
    languagesql
    psql -U postgres
    SIPXCONFIGalter table e911 rename to
     SIPXCONFIG
    alter table e911 rename to e911_erl;
    
    ALTER TABLE e911_erl RENAME COLUMN e911_id TO erl_id;
    
    create sequence erl_seq;
    
    
    ALTER TABLE e911_erl
    ADD (ip_addr_start character varying, ip_addr_end character varying);ALTER TABLE e911_erl ADD column
     ADD column ip_addr_start character varying;
    
    ALTER TABLE e911_erl ADD column ip_addr_end character varying;
    
    \q
    
    service sipxconfig restart

At this point you're installation will have the corrected DB structure for sipXcom and therefore be functioning normally.  To confirm that the installation is now functioning correctly from a DB perspective, log into the sipXcom system UI and send profiles to the server.  Ensure that this completes without error in the Job Status page.

...