Database setup

Prev Next

OneSpan Authentication Server requires an ODBC-compliant database as its data store. An embedded (MariaDB) database is available with OneSpan Authentication Server. If you choose basic installation, this database will be installed and configured by default.

The database can be located on any machine to which OneSpan Authentication Server can connect. To set up a database for use with OneSpan Authentication Server, the database schema must be extended correctly. You can choose to do so manually before the installation begins, or automatically as part of the installation process.

Manual installation and configuration of MariaDB

If you choose a manual installation of MariaDB, we recommend to introduce the following settings in the MariaDB configuration file (usually located in %PROGRAMFILES%\VASCO\MariaDB11.8\data\my.ini).

character-set-client-handshake=FALSE
character_set_server=utf8
collation_server=utf8_bin
connect_timeout=10
default_time_zone='+00:00'
init_connect='SET NAMES utf8'
lower_case_table_names=1
thread_handling=pool-of-threads
transaction_isolation=READ-COMMITTED
wait_timeout=28800

By default, InnoDB is the storage engine used by MariaDB. In addition to the listed settings, it is recommended to set the innodb_buffer_pool_size setting to approximately 80% of the available memory to ensure that most of the working set can be kept in memory (cf. Configuring MariaDB for Optimal Performance, last accessed on May 7, 2026).

For more information about configuring MariaDB, refer to the MariaDB documentation.

Oracle Database servers

When configuring a database on Oracle Database to use with OneSpan Authentication Server, note the following required settings:

  • On the Select Installation Option page, select Create and configure a database.

  • On the Typical Installation Configuration page:

    • Select Unicode (AL32UTF8) in the Character set list.

    • Type in an administrative password twice to prevent typing errors.

    • Clear the Create as Container database box.