Saving Connection Properties for Sentinel Data Manager

The saveConnection command saves the database connection details to a specified file. These connection details are necessary for all other SDM command line operations.

If you run the SDM GUI with Save connection settings selected, the saveConnection command is not necessary. You can use the sdm.connect file located in <install_directory>/sdm.

The saveConnection command uses the following flags:

Table 2 saveConnection command Flags

Command

Command Flags

-action

saveConnection

-server

<postgresql>

-host

<database host IP Address or host name to connect to>

-port

<database port number to connect to >

-database

<database name/SID>

-driverProps

<Properties File>

-dbuser

<database username>

-password

<database password>

winAuth

Used for Windows authentication. When using this option, -user and –password are not needed.

connectFile

<filenameToSaveConnection>

The application saves all the above connection details along with the encrypted password to the sdm.connect file. All other SDM command line commands refer to the specified file. This step should be completed the first time you use the SDM command line on a machine and every time you want to change the connection details the application uses.

To run saveConnection:

  1. Execute the command as follows:

    -action saveConnection -server <postgresql> -host <hostIpaddress/hostName> -port <portnum> -database <databaseName/SID> [-driverProps <propertiesFile] {-user <dbUser> -password <dbPass> | -winAuth} -connectFile <filenameToSaveConnection>
    

    The following example saves connections for a host with an IP address of 10.0.0.1 at port 5432.

    • PostgreSQL Example:

      -action saveConnection -server postgresql -host 10.0.0.1 -port 5432 -database SIEM -user dbauser -password xxxxxx -connectFile sdm.connect
      

    This saves the connection details to the sdm.connect file. the rest of the commands take this filename as input to connect to the designated database and to perform their actions.

For trademark and copyright information, see Legal Notices.