Skip to main content

SQLite Database

Connector name

agtsqlite

Connector type

Executable

Type (UI field value)

SQLite Database

Connector status / support

Bravura Security-Verified

This connector has been tested and is fully supported by Bravura Security.

The following Bravura Security Fabric operations are supported by this connector (depending on your product license and version):

  • user verify password

  • user change password

  • get server information

  • administrator reset password

  • administrator reset+expire password

  • expire password

  • unexpire password

  • administrator verify password

  • verify+reset password

  • enable account

  • disable account

  • check account enabled

  • create account

  • delete account

  • expire account

  • check account expiry

  • unexpire account

  • lock account

  • unlock account

  • check account lock

  • add user to group

  • delete user from group

  • create group

  • delete group

  • update attributes

  • list account attributes

  • update subscriber attributes/password

  • List:

    • accounts

    • attributes

    • groups

    • members

    • computer objects

    • subscribers

For a full list and explanation of each connector operation, see connector operations.

Preparation

Before you can target with the SQLite database connector, you must:

  1. Create a SQLite database file.

  2. Create a SQLite database configuration file.

  3. Set up a target system administrator

  4. Create at least one template account.

Creating a SQLite database file

You require a SQLite database file that contains the account, group, group membership, computer and subscriber information. This file can be placed in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory. Alternatively, you can use the existing extdb.db database contained in the \<instance>\db\* directory.

A sample SQLite database, agtsqlite.db is contained in the samples\* directory. This database shows the necessary tables, as well as the columns needed in order to work with the sample configuration file, along with some sample data.

Creating a SQLite database configuration file

You must create a configuration file that maps the SQLite database table data to Bravura Security Fabric attributes. The configuration file must be placed in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\. A sample script, agtsqlite.cfg is contained in the samples\* directory. Note that any sample script may need customizations in order to work with your database.

Setting up a target system administrator

Bravura Security Fabric does not require a designated administrator account to perform Bravura Security Fabric operations using the SQLite database connector. You will still see a warning message saying that no administrator credentials are specified, however this can be ignored.

Creating a template account

Bravura Security Fabric uses template accounts as models or "blueprints" for creating new accounts in the SQLite database. Add a record in the account table in the SQLite database to designate as the template account.

Targeting SQLite with the SQLite database connector

For each SQLite database, add a target system (Manage the system > Resources > Target systems):

  • Type is SQLite Database .

  • Address uses:

    Script file The SQLite configuration file name; for example agtsqlite.cfg . This is a required field.

    (key: script)

    Database name The full SQLite database file name; for example agtsqlite.db . This is an optional field.

    (key: database)

Handling account attributes

In order for Bravura Security Fabric to manage attributes, you must first add the attributes to Bravura Security Fabric.

See Account attributes in the Bravura Security Fabric configuration documentation for more information.

Troubleshooting

  • If you are unable to target your SQLite database, ensure that the database is properly defined in the target system address field. It requires the full database file name, including extension.

  • Ensure that the SQLite database is in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory.

  • If you do not specify a database file name in the target system address field, the extdb.db database file from the \<instance>\db\ directory will be used instead.

  • When importing computer resources using the SQLite database connector, the restype attribute in the table being prepared must match the configuration found under the Discovery options tab for the source of record target.

    For the value of the restype field, use the ending of the specific resource list files the connector creates in the \<instance>\psconfig\ directory for those resources. For example:

    • ls_compsrv for server objects

    • ls_compwkstn for workstation objects

In this section: