dpdbadmin addschema

Mis à jour le 13 Jan 2025
3 Minutes à lire

Partager
Sombre
Lumière
PDF

The content is currently unavailable in French. You are viewing the default English version.

Résumé de l’article

Avez-vous trouvé ce résumé utile ?

Merci pour vos commentaires

The dpdbadmin addschema command is used to create all required tables in an existing database, if they are not already there. Each table will be checked individually to see if it is already there and if not, will be added.

Syntax

dpdbadmin addschema –d dsn [OPTION]...

where dsn is the ODBC data source name.

Command-line options

Table: dpdbadmin addschema command-line options
Option	Parameter	Description
‑case	case	Use case for the user IDs and domain names stored in the database. If required, user IDs and domain names from other sources will be converted to match the case used in the database (Default: lower). Possible values: lower mixed (no conversion)
‑d, ‑dsn	dsn	Required. ODBC data source name (DSN), e.g. "IAS embedded database".
‑domain	domain	Use domain as the master domain (Default: master). If the domain does not already exist, it is created.
‑h, ‑help		Show help and usage information.
‑l, ‑log	logfile	Write output to logfile.
‑noserver		Do not create the main tables used by OneSpan Authentication Server. Use this if you only want to install the tables necessary for auditing.
‑nouser		Do not create the user table. This option is currently not supported.
‑p, ‑password	dbpassword	Optional. Password of the database administrator. This option can be omitted if the database administrator account has a blank password.
‑q		Quiet mode. Do not output commentary text.
‑u, ‑user	dbusername	Optional. User name of a database administrator (if required).
‑unlockdb		Unlock a database synchronization lock used to protect the database schema against concurrent schema modifications.
‑utf8factor	factor	On certain databases (such as Oracle), column sizes are specified in bytes, not characters, by default. When UTF-8 encoding is used to store data, for full Unicode support, one character may be represented as more than one byte. Normally, 2 or 3 characters are used, depending on the language, but in some cases, 4 characters are required. If your data will include a lot of non-English characters, you can increase the size of certain columns by factor to allow for the extra bytes. factor should be 2, 3, or 4. Typically, 3 is sufficient. The columns affected by this are the user name (not user ID) and various Description fields. On other databases, column sizes are specified in characters, and this parameter is not needed.
‑v, ‑verbose		Print verbose output. Can be specified twice to be more verbose.
‑vdsadmin	tablename	Alternative name for the administrator table to be created (Default: vdsAdmin).
‑vdsadmindomains	tablename	Alternative name for the administrator domain table to be created (Default: vdsAdminDomains).
‑vdsauditmsg	tablename	Alternative name for the organizational unit table to be created (Default: vdsAuditMsg).
‑vdsauditmsgfield	tablename	Alternative name for the organizational unit table to be created (Default: vdsAuditMsgField).
‑vdsbackend	tablename	Alternative name for the back-end server table to be created (Default: vdsBackEnd).
‑vdsconfiguration	tablename	Alternative name for the configuration table to be created (Default: vdsConfiguration).
‑vdscomponent	tablename	Alternative name for the component table to be created (Default: vdsComponent).
‑vdscontrol	tablename	Alternative name for the control table to be created (Default: vdsControl).
‑vdsdigipass	tablename	Alternative name for the authenticator table to be created (Default: vdsDigipass).
‑vdsdomain	tablename	Alternative name for the domain table to be created (Default: vdsDomain).
‑vdsdpapplication	tablename	Alternative name for the authenticator application table to be created (Default: vdsDPApplication).
‑vdskey	tablename	Alternative name for the key table to be created (Default: vdsKey).
‑vdsofflineauthdata	tablename	Alternative name for the offline authentication data table to be created (Default: vdsOfflineData).
‑vdsorgunit	tablename	Alternative name for the organizational unit table to be created (Default: vdsOrgUnit).
‑vdspendingoperation	tablename	Alternative name for the pending operation table to be created (Default: vdsPendingOperation).
‑vdspersistentcache	tablename	Alternative name for the persistent cache table to be created (Default: vdsPersistentCache).
‑vdspolicy	tablename	Alternative name for the policy table to be created (Default: vdsPolicy).
‑vdsdpsoftparams	tablename	Alternative name for the authenticator soft parameter table to be created (Default: vdsDPSoftParams).
‑vdsreport	tablename	Alternative name for the report table to be created (Default: vdsReport).
‑vdsreportfield	tablename	Alternative name for the report field table to be created (Default: vdsReportField).
‑vdsreportformat	tablename	Alternative name for the report format table to be created (Default: vdsReportFormat).
‑vdsstoredreport	tablename	Alternative name for the stored reports table to be created (Default: vdsStoredReport).
‑vdstask	tablename	Alternative name for the task table to be created (Default: vdsTask).
‑vdsuser	tablename	Alternative name for the user table to be created (Default: vdsUser).
‑vdsuserattr	tablename	Alternative name for the user attribute table to be created (Default: vdsUserAttr).
‑y, ‑assume‑yes		Run the command non-interactively and assume Yes as answer to all confirmation prompts.

Exit codes

Table: dpdbadmin addschema exit codes
Exit code	Description
0	The command completed successfully.
1	The command has been aborted by the user.
2	The command failed due to an unspecified error.
3	The specified parameters are invalid.
4	The command failed due to an error.
5	The database authentication failed.
9	The data version is higher than the product version (unsupported) or missing.
10	The schema version does either not match the current or a compatible product version (unsupported) or is missing. The schema cannot be directly upgraded to the current product version.
11	Server data migration for the installed product version has not been completed yet.

Examples

To add a schema to the database using the data source name IAS embedded database and the user credentials digipass and digipassword type:

dpdbadmin addschema –u digipass –p digipassword –d "IAS embedded database"

Cet article vous a-t-il été utile ?

What's Next

dpdbadmin checkschema

Table des matières

Syntax
Command-line options
Exit codes
Examples