dpdbadmin checkschema
The dpdbadmin checkschema command is used to verify if schema updates have been completed after performing an ODBC data store extension using dpdbadmin addschema.
For most database setups, the schema extension does not finish instantaneously after executing the addschema command. Wait several minutes for the schema extensions to replicate across the system, before verifying the schema updates using checkschema.
Syntax
dpdbadmin checkschema –d dsn [OPTION]...
where dsn is the ODBC data source name.
Command-line options
| Option | Parameter | Description |
|---|---|---|
| ‑audit | Verify the auditing tables. By default, only the main tables used by OneSpan Authentication Server are verified. | |
| ‑d, ‑dsn | dsn | Required. ODBC data source name (DSN), e.g. "IAS embedded database". |
| ‑h, ‑help | Show help and usage information. | |
| ‑l, ‑log | logfile | Write output to logfile. |
| ‑noserver | Do not verify the main tables used by OneSpan Authentication Server. This should only be used with ‑audit, when you only want to verify the auditing tables. | |
| ‑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 | 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. | |
| ‑v, ‑verbose | Print verbose output. Can be specified twice to be more verbose. | |
| ‑vdscontrol | tablename | The alternative name for the control table specified when creating the schema using 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. |
| 6 | The schema is invalid. |
| 8 | The schema version does not match the product version, but is compatible. The schema can be directly upgraded to the current product version. |
| 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 check the schema in the database using the data source name IAS embedded database and the user credentials digipass and digipassword type:
dpdbadmin checkschema –u digipass –p digipassword –d "IAS embedded database"