Restoring an ODBC database from a backup

This procedure should be followed if a database has been damaged and no current, valid database exists on another server. The database is restored from an earlier backup.

If OneSpan Authentication Server has been upgraded, make sure that the backup used to restore the database was taken after the upgrade. Restoring a backup that was taken before the upgrade will cause OneSpan Authentication Server to fail.

To restore a backup of the embedded MariaDB database

1. 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.

2. 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.

3. 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.

4. Restart the OneSpan Authentication Server service/daemon.
5. 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.