Migrating to SQLite mode (SpinFire Publish 2025.1.0+)

Starting with SpinFire Publish 2025.1.0, customers MUST now use an embedded SQLite database instead of ArangoDB, as ArangoDB is no longer supported.

This is called SQLite mode.

SQLite mode makes it easier to install or update SpinFire Publish as there is no need to deploy ArangoDB.

Migrating an existing installation

An existing installation of SpinFire Publish (CAD Publisher) based on ArangoDB must be migrated before it can use SQLite mode. This is a one-time operation done by running a migration program called CadPublisherArangoMigrator.exe.

The program connects to ArangoDB using the same network settings as Centro Web App.

It turns off the applications, deploys the ArangoDB database, migrates its content to an SQLite database, and sets a system environment variable CAD_PUBLISHER_SQLITE=true to toggle SQLite mode on.

Follow the steps below to perform the migration:

  1. Create a backup of the ArangoDB database.

  2. Download and extract the ZIP file CadPublisherArangoMigrator.zip.

  3. Download C7-deploy-2025.1.x.x.zip and place it next to CadPublisherArangoMigrator.exe.

    • You don’t need to extract the zip file, the migration program will do it automatically.

    Migration tool screenshot

  4. If you have installed Centro Web App in a different folder than the default C:\inetpub\wwwroot\Centro, open CadPublisherArangoMigrator.exe.config and update CentroConfigPath setting with the correct value.

  5. Open an administrator Command Prompt in the folder that contains CadPublisherArangoMigrator.exe.

    Command prompt screenshot

  6. Run CadPublisherArangoMigrator.exe from the command prompt.

    Running migration tool

  7. Enter the password for ArangoDB root user and press Enter.

    Entering ArangoDB password

  8. Wait for the migration to complete. If successful, you will see “Migration Successful!”. If an error occurs, refer to the troubleshooting section below.

    Migration successful

  9. (Optional) Turn off or uninstall the ArangoDB service.

  10. Restart the machine. This is required to make sure that the environment variable will take effect everywhere (e.g. in IIS).

  11. Install SpinFirePublish.exe.

  12. Run the installer. If prompted for ArangoDB credentials, the environment variable from step 10 has not been propagated. Ensure the variable is set then reboot the machine.

  13. Navigate to your SpinFire Publish instance to make sure it is running correctly.

    Note

    You may need to re-set the Log On As credentials for the Centro Pipeline Service (now replacing Pipeline Host and Pipeline Manager).

New installation

  1. Set CAD_PUBLISHER_SQLITE=true as a system environment variable.

  2. Restart the machine. This is required to make sure that the environment variable will take effect everywhere (e.g. in IIS).

  3. Install SpinFirePublish.exe.

    1. Run the installer. If prompted for ArangoDB credentials, the environment variable from step 1 has not been propagated. Ensure the variable is set then reboot the machine.

    2. After the installation, navigate to your SpinFire Publish instance to make sure it is running correctly.

Troubleshooting

Failed to deploy database

Failed to deploy database

  • Check the log files for more information: CentroWebApp00.log and deploy_log_<appVersion>_<dd-MM-yyyy-HHmmss>.txt.

  • Make sure that the IIS application pool (usually CentroPool) has write access to the folder that contains the database file: <ProgramDataRoot>. The default is C:\ProgramData\SpinFire\SpinFire Publish\.

Attempt to write a readonly database

Attempt to write a readonly database

  • Make sure that the IIS application pool (usually CentroPool) has write access to the folder that contains the database file: <ProgramDataRoot>. The default is C:\ProgramData\SpinFire\SpinFire Publish\.

HTTP Error 500.0 - Internal Server Error

HTTP Error 500.0

  • Ensure that the IIS application pool CentroPool is started.