NOTE:With a fresh installation of ZENworks 23.4, setting up a new Management Zone using a Windows Server and Linux Server is not supported.
If you want to setup a new zone using a Windows Server and Linux Server, we recommend you install ZENworks 2020 Update 2 and then upgrade to ZENworks 23.4. For information see,
Only a Database Administrator can create the database schema. This database schema will be later used by the ZENworks Administrator to create a new management zone.
Prerequisite:
Make sure Java is installed on the system before running the Schema Creator Tool.
To create a database schema, perform the following steps:
Log in to the Customer Portal or Software Licenses and Downloads.
From the Downloads screen, select the Product, Product Name (entitlement) and Version to view the files. Click the Media Version column to sort the files.
Download and extract the Schema Creator Tool.
Navigate to the extracted folder and open the mssql-schema-details.properties file. The mssql-schema-details.properties includes all of the details required for the Schema Creator Tool to create the database schema, a ZENworks user to access the database, and connection parameters.
Add the following parameters in the mssql-schema-details.properties file:
For ZENworks database, add the following parameters:
ACCESS_PASSWORD= Specify the Microsoft database password for the ZENworks administrator to use.
ACCESS_USER= Specify the Microsoft database user name for ZENworks administrator.
ADMIN_PASSWORD= Specify the database administrator password.
ADMIN_USER= Specify the database administrator user name. Make sure the administrator has rights to create a user.
DATABASE_DIR= Specify the database directory where database should to be created. Make sure to include \\ in the path. For example, C:\\Database.
DATABASE_PORT= Specify the port number used by the external database server.
DATABASE_SERVER_ADDRESS= Specify the IP address of the external database server.
DATABASE_TYPE= Microsoft SQL
DB_NAME= Specify the name for the new ZENworks database.
For audit database, add the following parameters:
AUDIT_ACCESS_PASSWORD= Specify the Microsoft SQL database password for the audit administrator to use.
AUDIT_ACCESS_USER= Specify the Microsoft SQL database user name for audit administrator.
AUDIT_ADMIN_PASSWORD= Specify the Microsoft SQL database administrator password.
AUDIT_ADMIN_USER= Specify the Microsoft SQL database administrator user name.
AUDIT_DATABASE_DIR= Specify the database directory where database should to be created. Make sure to include \\ in the path. For example, C:\\Database
AUDIT_DATABASE_PORT= Specify the port number used by the external database server.
AUDIT_DATABASE_SERVER_ADDRESS= Specify the IP address of the external database server.
AUDIT_DB_NAME= Specify the name for the new database.
After updating the Microsoft SQL properties file, run the following command from the extracted location:
java -jar db-creation-tool.jar mssql-schema-details.properties
The JDBC URL is displayed after successfully executing the command.
Make of note of the JDBC URL for Audit and ZCM printed in the console at completion.
Next, on the Appliance, perform the following steps:
Launch the URL on a supported web browser.
The URL (https://<FQDN>:9443 or https://<ipaddress>:9443) is displayed on the appliance console.
Log in to ZENworks Appliance with the root or zenadmin credentials.
Go to the System Services tile, select the SSH service, and click Start.
Download the silent installer properties file (silentinsall.config) from the following location:
Modify the silent installer properties file (silentinstall.config) with relevant information including the JDBC URL that was printed out in the tool (in step 6 above).
Edit the following parameters in the silentinstall.config file:
Make sure to include the values as specified in the mssql-schema-details.properties file.
DATABASE_JDBC_URL= Specify the JDBC URL that was copied after running the tool. The database and Audit database JDBC URLs will be the same.
AUDIT_DATABASE_JDBC_URL= Specify the JDBC URL that was copied after running the tool. The database and Audit database JDBC URLs will be the same.
DATABASE_ACCESS_USER= Specify the Microsoft SQL database password for the ZENworks administrator to use.
OBFUSCATED_DATABASE_ACCESS_PASSWORD= Specify the Microsoft SQL database user name for the ZENworks administrator to use.
AUDIT_DATABASE_ACCESS_USER= Specify the Microsoft SQL database user name for audit administrator.
OBFUSCATED_AUDIT_DATABASE_ACCESS_PASSWORD= Specify the Audit database password for the ZENworks administrator to use.
USE_EXTERNAL_DB_POSTGRESQL= Specify 0 (zero) if you do not want to use an external PostgreSQL database.
SSL_SERVER_CERT_VALIDITY= Specify the certificate validity as 2. This value is in years.
IS_PRIMARY_SERVER= Set this value to true to configure Microsoft SQL as a Primary Server.
TargetTypes= Specify the target types as FIRST_PRIMARY,ZEN_SERVER,ROLE_ApplianceServer,sles12
TOMCAT_SECURE_PORT= The port used by the Microsoft SQL database server. The default port for Microsoft SQL in ZENworks is 443.
DATABASE_TYPE= Specify the database type as sql-server.
OPEN_FIREWALL_PORTS= Enter Y to open the firewall ports.
ZENSERVER_HOME= Specify the following location to create a ZENworks Server directory:
/opt/microfocus/zenworks
OBFUSCATED_ZONE_PASSWORD= Specify the Management zone password.
USE_EXTERNAL_DB_MSSQL= Enter 1 to use an external Microsoft SQL database.
ZENSERVER_BIN= Specify the following location to create a ZENworks Server bin:
/opt/microfocus/zenworks/bin
SERVER_ADDRESSES= Specify a valid IP address or a Fully Qualified Domain Name (FQDN) for the Microsoft SQL server.
CREATE_NEW_EXTERNAL_DATABASE= Enter 1 to create an external database.
ZEN_ADMIN_PORT= Specify the port used by the Microsoft SQL server. The default port is 7433.
USE_INTERNAL_CA= Specify 1 to use internal CA.
MANAGEMENT_ZONE_NAME= Specify the name of the management zone.
CREATE_NEW_EXTERNAL_AUDIT_DATABASE= The value 0 is the default and means that the new external audit database will not be used.
DNS= Specify the DNS name or IP address of your zone's Primary Server.
IS_FIRST_SERVER= Specify 1 to create a first server.
IS_APPLIANCE= Specify 1 to create an appliance.
USE_EMBEDDED_DATABASE= The value 0 is the default and means that the embedded database will not be used.
USE_EMBEDDED_DB_POSTGRESQL= The value 0 is the default and means that the embedded PostgreSQL database will not be used.
CREATE_NEW_EXTERNAL_DATABASE= The value 0 is the default and means that the new external database will not be created.
CREATE_NEW_EXTERNAL_AUDIT_DATABASE= The value 0 is the default and means that the new external audit database will not be created.
USE_EXTERNAL_DB_ORACLE= The value 0 is the default and means that the external database will not be used.
Copy the silentinstall.config file to the /tmp folder on the appliance.
Invoke the silent installer by running the following command:
/usr/share/ZCMInstaller/zenworks-installer-linux/zuper-installer.sh -f /tmp/silentinstall.config
NOTE:It is recommended to run this command from the local console session.
To view the real-time status of the installation, run the following command:
tail -f /var/opt/microfocus/log/zenworks/Progress_Tracker_ZENworks_Install.log
To hide the Application configuration prompt in ZENworks, create the ZENworksIsConfigured file in /opt/microfous/zenworks by running the following command:
touch /opt/microfocus/zenworks/ZENworksIsConfigured
Only a Database Administrator can create the database schema. This database schema will be later used by the ZENworks Administrator to create a new management zone.
Prerequisite:
Make sure Java is installed on the system before running the Schema Creator Tool.
To create a database schema, perform the following steps:
Log in to the Customer Portal or Software Licenses and Downloads.
From the Downloads screen, select the Product, Product Name (entitlement) and Version to view the files. Click the Media Version column to sort the files.
Download and extract the Schema Creator Tool.
Navigate to the extracted folder and open the oracle-schema-details.properties file. The oracle-schema-details.properties includes all of the details required for the Schema Creator Tool to create the database schema, a ZENworks user to access the database, and connection parameters.
Add the following parameters in the oracle-schema-details.properties file:
For ZENworks database, add the following parameters:
ACCESS_PASSWORD= Specify the Oracle database password for the ZENworks administrator to use.
ACCESS_USER= Specify the Oracle database user name for ZENworks administrator.
ADMIN_PASSWORD= Specify the database administrator password.
ADMIN_USER= Specify the database administrator user name. Make sure the administrator has rights to create a user.
DATABASE_ORACLE_SERVICE_NAME= Specify a valid service name for the Oracle server.
DATABASE_PORT= Specify the port number used by the external database server.
DATABASE_SERVER_ADDRESS= Specify the IP address of the external database server.
DATABASE_TYPE= Oracle
DB_NAME= Specify the name for the new ZENworks database.
DATABASE_ORACLE_TABLETS_DBF= Specify the dbf fully qualified file path, it must be unique. The specified physical path of the folder must be an existing path. Make sure to use \\ in the path. For example: C:\\Oracle\\Database\\ZCMTABLE.dbf
DATABASE_ORACLE_INDEXTS_DBF= Specify the dbf fully qualified file path, it must be unique. The specified physical path of the folder must be an existing path. Make sure to use \\ in the path. For example: C:\\Oracle\\Database\\ZCMTABLE.dbf
DATABASE_ORACLE_TABLE_TABLESPACE= The tablespace name for tables that exist on the Oracle server.
DATABASE_ORACLE_INDEX_TABLESPACE= The tablespace name for indexes that exist on the Oracle server.
For audit database, add the following parameters:
AUDIT_ACCESS_PASSWORD= Specify the Oracle database password for the audit administrator to use.
AUDIT_ACCESS_USER= Specify the Oracle database user name for audit administrator.
AUDIT_ADMIN_PASSWORD= Specify the Oracle database administrator password.
AUDIT_ADMIN_USER= Specify the Oracle database administrator user name.
AUDIT_DATABASE_ORACLE_SERVICE_NAME= Specify a valid service name for the Oracle server.
AUDIT_DATABASE_PORT= Specify the port number used by the external database server.
AUDIT_DATABASE_SERVER_ADDRESS= Specify the IP address of the external database server.
AUDIT_DB_NAME= Specify the name for the new database.
AUDIT_DATABASE_ORACLE_TABLE_TABLESPACE= The tablespace name for tables that exist on the Oracle server.
AUDIT_DATABASE_ORACLE_INDEX_TABLESPACE= The tablespace name for indexes that exist on the Oracle server.
AUDIT_DATABASE_ORACLE_TABLETS_DBF= Specify the dbf fully qualified file path, it must be unique. The specified physical path of the folder must be an existing path. Make sure to use \\ in the path. For example: C:\\Oracle\\Database\\ZCMTABLE.dbf
AUDIT_DATABASE_ORACLE_INDEXTS_DBF= Specify the dbf fully qualified file path, it must be unique. The specified physical path of the folder must be an existing path. Make sure to use \\ in the path. For example: C:\\Oracle\\Database\\ZCMTABLE.dbf
After updating the Oracle properties file, run the following command from the extracted location:
java -jar db-creation-tool.jar oracle-schema-details.properties
The JDBC URL is displayed after successfully executing the command.
Make of note of the JDBC URL for Audit and ZCM printed in the console at completion.
Next, on the Appliance, perform the following steps:
Launch the URL on a supported web browser.
The URL (https://<FQDN>:9443 or https://<ipaddress>:9443) is displayed on the appliance console.
Log in to ZENworks Appliance with the root or zenadmin credentials.
Go to the System Services tile, select the SSH service, and click Start.
Download the silent installer file (silentinstall.config) from the following location:
Modify the silent installer file (silentinstall.config) with relevant information including the JDBC URL that was printed out in the tool (in step 6 above).
Edit the following parameters in the silentinstall.config file:
Make sure to include the values as specified in the oracle-server-details.properties file.
AUDIT_DATABASE_ACCESS_USER= Specify the ZENworks Audit database user name.
AUDIT_DATABASE_ADMIN_USER= Specify the ZENworks Audit database server administrator user name.
AUDIT_DATABASE_ORACLE_INDEX_TABLESPACE= Specify the tablespace name for tables that exist on the Oracle server.
AUDIT_DATABASE_ORACLE_SERVICE_NAME= pecify a valid service name for the Oracle server.
AUDIT_DATABASE_ORACLE_TABLE_TABLESPACE= The tablespace name for indexes that exist on the Oracle server.
CREATE_NEW_EXTERNAL_AUDIT_DATABASE= Specify 1 to create an external audit database.
CREATE_NEW_EXTERNAL_DATABASE= Specify 1 to create an external database.
DATABASE_ACCESS_USER= Specify the Oracle database password for the ZENworks administrator to use.
DATABASE_ORACLE_INDEX_TABLESPACE= Specify the tablespace name for indexes that exist on the Oracle server.
DATABASE_ORACLE_SERVICE_NAME= Specify a valid service name for the Oracle server.
DATABASE_ORACLE_TABLE_TABLESPACE= Specify the tablespace name for tables that exist on the Oracle server.
DATABASE_TYPE= oracle
DNS= Specify the DNS name or IP address of your zone's Primary Server.
IS_APPLIANCE= Specify 1 to create an appliance.
IS_FIRST_SERVER= Specify 1 to create a first server.
IS_PRIMARY_SERVER= Specify 1 to create a first Primary Server.
MANAGEMENT_ZONE_NAME= Specify the name of the management zone.
OBFUSCATED_AUDIT_DATABASE_ACCESS_PASSWORD= Specify the audit database password for the ZENworks administrator to use.
OBFUSCATED_DATABASE_ACCESS_PASSWORD= Specify the Oracle database password for the ZENworks administrator to use.
OBFUSCATED_ZONE_PASSWORD= Specify the Management zone password.
OPEN_FIREWALL_PORTS= Enter Y to open the firewall ports.
SERVER_ADDRESSES= Specify a valid IP address or a Fully Qualified Domain Name (FQDN) for the Oracle server.
SKIP_PARTITIONING= Specify 0 (zero) to let ZENworks use partitioning with the Oracle database. The default value is 1, which means that partitioning will not be used with the Oracle database.
SSL_SERVER_CERT_VALIDITY= Specify the certificate validity as 2. This value is in years.
TargetTypes= Specify the target types as FIRST_PRIMARY,ZEN_SERVER,ROLE_ApplianceServer,sles12
TOMCAT_SECURE_PORT= The port used by the Oracle database server. The default port for Oracle in ZENworks is 443.
USE_EMBEDDED_DB_POSTGRESQL= The value 0 is the default and means that the embedded PostgreSQL database will not be used.
USE_EMBEDDED_DATABASE= The value 0 is the default and means that the embedded database will not be used.
USE_EXISTING_EXTERNAL_AUDIT_DATABASE= The value 0 is the default and means that the existing external audit database will not be used.
USE_EXISTING_EXTERNAL_DATABASE= The value 0 is the default and means that the existing external database will not be used.
USE_EXTERNAL_DB_MSSQL= The value 0 is the default and means that the external Microsoft SQL database will not be used.
USE_EXTERNAL_DB_ORACLE= Specify 1 to use the Oracle external database.
USE_EXTERNAL_DB_POSTGRESQL= The value 0 is the default and means that the external PostgreSQL database will not be used.
USE_INTERNAL_CA= Specify 1 to use internal CA.
ZEN_ADMIN_PORT= Specify the port used by the Oracle server. The default port is 7433.
ZENSERVER_BIN= Specify the following location to create a ZENworks Server bin:
/opt/microfocus/zenworks/bin
ZENSERVER_HOME= Specify the following location to create a ZENworks Server directory:
/opt/microfocus/zenworks
DATABASE_JDBC_URL= Specify the JDBC URL that was copied after running the tool. The database and Audit database JDBC URLs will be the same.
AUDIT_DATABASE_JDBC_URL= Specify the JDBC URL that was copied after running the tool. The database and Audit database JDBC URLs will be the same.
MOUNT_PATH= Specify the following ZENworks installer path:
/usr/share/ZCMInstaller
Copy the silentinstall.config file to the /tmp folder on the appliance.
Invoke the silent installer by running the following command:
/usr/share/ZCMInstaller/zenworks-installer-linux/zuper-installer.sh -f /tmp/silentinstall.config
NOTE:
It is recommended to run this command from the local console session.
To view the real-time status of the installation, run the following command in a new console:
tail -f /var/opt/microfocus/log/zenworks/Progress_Tracker_ZENworks_Install.log
To hide the Application configuration prompt in ZENworks Appliance, create the ZENworksIsConfigured file in /opt/microfous/zenworks by running the following command:
touch /opt/microfocus/zenworks/ZENworksIsConfigured