Restoring an ODBC database and configuration from a backup

This procedure should be followed if both OneSpan Authentication Server and its database have been lost. OneSpan Authentication Server configuration files and the database will be restored from earlier backups.

To restore a backup of the embedded MariaDB database and OneSpan Authentication Server

1. Rebuild the server with your operating system SOE, using the same IP address as before, in the same domain as before.

2. Retrieve your backup copies of the configuration files that were previously created from the following folder:

   /etc/vasco/ias (Linux)

   %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server\bin (Windows)

   For more information, see Backup of sensitive data (Overview).

3. Reinstall OneSpan Authentication Server on the server using the same settings as those used in the previous installation. Do not run the Maintenance Wizard!
4. Restore the backup copy of the configuration file identikeyconfig.xml into its proper directory. Restore the backup copies of any other files that were backed up from the same directory at the same time. For more information, refer to Backup of sensitive data (Overview).
5. Stop the OneSpan Authentication Server service or daemon, respectively.
6. In Windows, open a Command Prompt window and navigate to %PROGRAMFILES%\VASCO\MariaDB10.11\bin\. In Linux, open a terminal and navigate to /usr/bin/ or /usr/sbin/, depending on which Linux distribution you are using.

7. Type the following command:

   mysql db_name --ssl=TRUE -u db_username -p <  backup_filename

   where:

   • ‑‑ssl=TRUE enables secure connections (TLS) for the database connection.
   • db_name is the database name, e.g. Identikey Server.
   • db_username is the user account used for database authentication.
   • backup_filename is the absolute path and name of the file to restore the data backup, e.g. ./backup.sql.

   When prompted, provide the password for the database administrator account.

   By default, the following settings apply to the embedded MariaDB database:

   • db_name (default database name) is Identikey Server.
   • db_username (database administrator account name) is digipass.
   • db_password (database administrator account password) is digipassword.

   This command can only be executed with SSL enabled.

8. Delete the replication database. To do so, delete Replication.DB in the following directory:

   • /var/spool/vasco/ias (Linux)
   • %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server\ReplData (Windows, default)

   If you have configured replication to store its files in a different directory, delete the files in that directory instead.

9. Restart the OneSpan Authentication Server service/daemon.
10. Perform the steps in Restoring an ODBC database from another OneSpan Authentication Server instance on all other OneSpan Authentication Server instances in the environment. It is essential to resynchronize all the databases in the system.