Depending on the number of devices you plan to manage in this ZENworks Management Zone, you can use any of the following databases:
If you have 5,000 or fewer devices, you can use the Embedded PostgreSQL or External PostgreSQL database.
If you have up to 40,000 devices, you can use Microsoft SQL Server or Oracle.
If you have up to 100,000 devices, you need to use the Oracle Enterprise Edition (with partitioning).
NOTE:If you are using an external database, then you need to create two databases, one to save ZENworks data and another to save Audit data. The Audit database is used to record changes made to ZENworks configurations, policies, and other settings. This data helps administrators to adhere to security compliance, troubleshoot issues, and monitor user activities.
Choose the Embedded PostgreSQL to store the ZENworks and Audit data. If you select the embedded database option, no further database configuration is required for ZENworks and Audit.
The PostgreSQL database must exist on a different server in your network. It is recommended that you use a different server rather than the current server.
If you are using an external database, then you need to create two databases, one to save ZENworks data and another to save Audit data.
The Audit database is used to record changes made to ZENworks configurations, policies, and other settings. This data helps administrators to adhere to security compliance, troubleshoot issues, and monitor user activities.
While Configuring the First Primary Server, if you choose to use External PostgreSQL as your database, then perform the following:
In the ZENworks Database Configuration page, specify the following information for the server that is hosting an existing ZENworks database:
Server Address: Specify the database server address and ensure that the database server is up and running.
Port: Select the port through which the ZENworks can communicate with the database server. The default port is 5432.
Administrator Username: Specify the database administrator username, who has the rights to create a database.
Administrator Password: Specify the database administrator password to access the database.
The database administrator username and password will be used to connect to the database server to create the database. The credentials will be discarded after the database and user are created.
Database Name: Specify a name for the database that will be created for ZENworks.
Username: Specify a new user who can access the ZENworks database.
Password: Specify a password to access the ZENworks database
Confirm Password: Use this field to confirm the password. If there is a mismatch, an error message is displayed after you click Next. You can then specify the passwords again.
Click Next and continue with Audit database.
Specify the server information that is hosting an existing Audit database. The fields displayed are the same that were displayed in the ZENworks Database Configuration page.
Click Next and continue with the ZENworks Ports. For information, see Step 9, in the Configuring the First Primary Server.
The Microsoft SQL database must exist on a different server in your network. It is recommended that you use a different server rather than the current server.
If you are using an external database, then you need to create two databases, one to save ZENworks data and another to save Audit data.
The Audit database is used to record changes made to ZENworks configurations, policies, and other settings. This data helps administrators to adhere to security compliance, troubleshoot issues, and monitor user activities.
While Configuring the First Primary Server, if you choose to use Microsoft SQL as your database, then perform the following:
In the Microsoft SQL Server Configuration for ZENworks page, perform the following:
Database Server Details
You can either select the port through which you can access the Microsoft SQL Server or select the name instance of the Microsoft SQL Server.
Server address: Specify a Fully Qualified Domain Name (FQDN) or a valid IP address for the Microsoft SQL server.
Port: Select the port used by the Microsoft SQL server. The default port is 1433.
Named instance: Specify the name of the Microsoft SQL server instance that is hosting the ZENworks database.
Create New Database
In this section, select the mode of authentication for the SQL server, you can select either SQL Server authentication or Windows authentication.
To create a new database, you need to know the database administrator credentials who has system administrator privileges.
It is important to know whether you installed the Microsoft SQL Server by using Windows authentication or Mixed mode authentication. Ensure that you select the option that coincides with your Microsoft SQL server options, or else the authentication fails.
SQL Server Authentication: If you select this option, then you need to specify the administrator credentials who has the required privileges to create a new database.
Windows Authentication: If you select this option, specify the Windows administrator credentials and domain name where the user you specified in the Username field exists.
In the Create New User Schema for Microsoft SQL, perform the following:
Database Details
In this section, specify the name and the directory details of the ZENworks database. If the specified directory does not exist, then the configuration fails.
Authentication
In this section, select the required authentication type and specify the credentials.
NOTE:
For SQL Server Authentication, a new user will be created with the required permission to access the ZENworks instance.
For Windows Authentication, specify the existing domain user credentials to whom the required permission should be provided to access the ZENworks database.
Click Next and continue with Audit database.
Specify the server information that is hosting an existing Audit database. The fields displayed are the same that were displayed in the ZENworks Database Configuration page.
Click Next and continue with ZENworks Ports. For information, see Step 9, in the Configuring the First Primary Server.
The Oracle database must exist on a different server in your network. It is recommended that you use a different server rather than the current server.
If you are using an external database, then you need to create two databases, one to save ZENworks data and another to save Audit data.
The Audit database is used to record changes made to ZENworks configurations, policies, and other settings. This data helps administrators to adhere to security compliance, troubleshoot issues, and monitor user activities.
NOTE:For the Oracle database, if required, you can select Let ZENworks partition the database for improved performance.
While Configuring the First Primary Server, if you choose to use Oracle as your database, then perform the following:
In the User Schema page, perform the information for ZENworks database to connect to the Oracle database:
Basic Details
Server address: Specify a Fully Qualified Domain Name (FQDN) or a valid IP address of the Oracle server.
Port: Specify the port used by the database server. The default port is 1521.
Service name: Specify a valid service name for the Oracle server.
Admin Details
In this section, specify username and password of the database administrator credentials who has the rights to create a new user schema.
In the New User Schema page, perform the following:
Specify the details of a new user that should be created in the database with access to the new user schema.
Username: Specify a new username for the ZENworks database.
The username can have a maximum of 30 characters. It must not contain spaces or special characters such as (@ [ ] / : * ? | > < " & % { } ; , ^ + - = ( ) ! ~ ` . ). The username must not be a database reserve word and it must not start with a number.
Password: Specify a valid password to access the ZENworks database.
The password can have a maximum of 30 characters. It must not contain special characters such as (; : " / @ % ? { } ). The password must not be a database reserve word and it must not start with a number.
Confirm Password: Use this field to confirm the password. If there is a mismatch, an error message is displayed after you click Next. You can then specify the passwords again.
If you want the ZENworks to create the tablespace, select Let ZENworks Create Tablespaces, and specify the following:
Tables and Indexes should be unique and must start with [a-z] | [A-Z]. The Oracle tablespace naming conventions must be followed.
Tables and Indexes DBF file locations should be fully qualified paths and must be unique. The specified path of the folder must be an existing path.
If you want your database administrator to create the tablespace, select Tablespaces Created By DBA.
If you want your database administrator to create the tablespace, select Tablespaces Created By DBA.
Click Next and continue with Audit database.
Specify the server information that is hosting an existing Audit database. The fields displayed are the same that were displayed in the ZENworks Database Configuration page.
Click Next and continue with the ZENworks Ports. For information, see Step 9, in the Configuring the First Primary Server.
NOTE:After configuring ZENworks Appliance on the first Primary Server in the zone, the ZooKeeper service is by default enabled on this server. Ensure that the ZooKeeper service is up and running at all times to enable proper functioning of various ZENworks components. To verify the status of the ZooKeeper service, see the Diagnostics page in ZCC. For more information on the ZooKeeper component, see the ZENworks Primary Server and Satellite Reference.
You also need to ensure that the firewall allows client connections from other Primary Servers to the ZooKeeper services on port 6789. If the Primary Servers in your zone are unable to access the ZooKeeper service, then to open the ports, you can run the following Configure action on the server in which ZooKeeper is enabled.
microfocus-zenworks-configure -c ClusterFirewallConfigureAction -Doperation=add -Dservice=zookeeper
However, if the Primary Server that is within the DMZ is unable to access the ZooKeeper service within the corporate network, then you need to manually open the port 6789 in the corporate firewall.
For more information on the ZooKeeper ports, see ZENworks TCP and UDP Ports.