Preparing MySQL servers
To prepare a MySQL server for SPP, refer to the documentation for your MySQL server for information about how to setup and secure encryption.
To enable SSL server certificate validation, add the server’s signing authority certificate to the Trusted Certificates store in SPP. For more information, see Trusted CA Certificates.
For more information about how SPP database servers use SSL, see How do SPP database servers use SSL.
SQL accounts supported
Safeguard can support MySQL accounts that have been created with the format <username> or <username>@< range of IP addresses>. The permitted range of IP addresses must include the IP address of the Safeguard appliance. The % character can be used as a wildcard.
Examples:
- Sam : Permit Sam to log in from any host (default)
- Sam@%: Permit Sam to log in from any host
- Sam@10.1.%: Permit Sam to log in from any IP address in 10.1.xx
Preparing Oracle databases
To prepare an Oracle database for SPP, refer to the documentation for your Oracle database for information about how to set up and secure encryption.
To enable SSL server certificate validation, when configuring the SSL-enabled service on the Oracle server, ensure that the following security setting is configured:
SSL_SERVER_CERT_DN="CN=<address>", where <address> matches the Network Address of the asset in SPP.
Preparing PAN-OS (Palo Alto) networks
In SPP the PAN-OS operating system is used by Palo Alto Networks appliances. SPP connects to PAN-OS systems using SSH.
To prepare a Palo Alto Networks system for SPP
-
Create a service account that is a Device Administrator and assign it the Superuser role and a password.
-
Verify that SSH is enabled.
-
In SPP, create the asset and accounts for the Palo Alto Networks asset type using password authentication.
Preparing PostgreSQL
SPP makes an SSL connection to PostgreSQL using a TCP port defined in the postgresql.conf file. You must enter this port number when adding a PostgreSQL asset to SPP.
To configure PostgreSQL for SPP
-
Create a service account and assign it a password.
NOTE: The service account must have permissions for remote connections, modify log_statements (if you want to enable the Hide Alter User command from verbose log_statement logging option), and permissions to change passwords.
Alter User commands can be excluded from the PostgreSQL server logs during SPP password changes. The option to hide Alter User commands is enabled by default for new PostgreSQL assets starting with SPP 7.1 with verbose log_statement logging. Customers upgrading to 7.1 that want to enable the option will need to reconfigure any existing PostgreSQL assets with verbose log_statement logging to have a service account with superuser permissions and enable the option.
Consult your PostgreSQL Security Guide for the appropriate settings for your organization.
- Verify that you can log in with the service account.
-
In SPP, create the asset and accounts for the PostgreSQL asset type using password authentication. You must specify the Database instance name and the Port used by the database instance. Accounts can also be discovered.
NOTE: When you create an account of Dialog User or Communication Data type, SPP allows you to set the account password or reset the password. Use the Reset Password option to reset the password for this account. If you use the Set Password option and enter the same password used in PostgreSQL, the password check in SPP will fail.