Database setup

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\MariaDB10.11\data\my.ini).

lower_case_table_names=1

default_time_zone='+00:00'

collation-server=utf8_bin

init-connect='SET NAMES utf8'

character-set-server=utf8

character-set-client-handshake=FALSE

transaction-isolation=READ-COMMITTED

thread_handling=pool-of-threads

connect_timeout=10

wait_timeout=28800

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.