3.3 Changing the DNS Name or DNS Name and the IP Address of a Primary Server after Installing ZENworks

Windows Script (.bat)

Create a .bat file and add the following content.

@echo off

set "oldDNS=PutOldDnsHere"
set "newDNS=PutNewDnsHere"

setlocal EnableExtensions EnableDelayedExpansion
set "SOURCEFILE=%ZENSERVER_HOME%\conf\zookeeper.properties"
set "TEMPFILE=test_out.txt"

for /f "delims=" %%A in ('type "%SOURCEFILE%"') do (
    set "string=%%A"
    set "modified=!string:%oldDNS%=%newDNS%!"
    echo !modified!>>"%TEMPFILE%"
)

del "%SOURCEFILE%"
move "%TEMPFILE%" "%SOURCEFILE%"
endlocal

After creating the script file, update the PutOldDnsHere and PutNewDnsHere, and then execute the bat file.

Linux Script (.sh)

Create a .sh file and then add the following content.

#!/bin/bash
oldDns=PutOldDnsHere;
newDns=PutNewDnsHere;

echo $oldDns
echo $newDns

#zookeeper.properties
file=/etc/opt/microfocus/zenworks/zookeeper.properties
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

# kafka-service-config.properties
file=/etc/opt/microfocus/zenworks/kafka-service-config.properties
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

#kafka.properties
file=/etc/opt/microfocus/zenworks/kafka/zenworks-kafka-server.properties
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

# schema-registry.properties 
file=/etc/opt/microfocus/zenworks/kafka/zenworks-schema-registry.properties
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

# kafka-connect.properties
file=/etc/opt/microfocus/zenworks/kafka/zenworks-connect-avro-distributed.properties
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

# vertica-datamodel
file=/etc/opt/microfocus/zenworks/datamodel/zenvertica.xml
if test -f $file; then
    sed -i "s/$oldDns/$newDns/" $file
fi

After creating the script file, update the PutOldDnsHere and PutNewDnsHere, and then execute the script file.

PostgreSQL Query

CREATE OR REPLACE FUNCTION replaceDNS(guid character varying,oldDns character varying, newDns character varying  )
RETURNS void AS 
$$ 
DECLARE 
  actualValue varchar(1024);
  updatedValue varchar(1024);
  guidAsBytea bytea;
BEGIN
 select decode(guid, 'hex') into guidAsBytea;
 raise notice '%', guidAsBytea;
 select  data into actualValue from zzenserverroles where id=guidAsBytea and roles = 'ZooKeeper';     
 raise notice '%', actualValue;
 updatedValue := REPLACE(actualValue, oldDns, newDns );
 raise notice '%', updatedValue;
 update zzenserverroles set data=updatedValue where id=guidAsBytea and roles = 'ZooKeeper';
 
 -- update zopaquedata for kafka cluster 
 IF EXISTS (select 1 from zopaquedata where name = 'kafka.cluster.config')  THEN    
   select data into actualValue from zopaquedata where name = 'kafka.cluster.config';     
   raise notice '%', actualValue;
   updatedValue := REPLACE(actualValue, oldDns, newDns );
   raise notice '%', updatedValue;
   update zopaquedata set data=updatedValue where name = 'kafka.cluster.config';
 END IF;
END;
$$ 
LANGUAGE plpgsql; -- language specification

Execute function/procedures in the database, for postgresql to run the following function:
select replaceDNS(server_guid, oldDns ,newDns);

Example:

select replaceDNS('c79de1490818e00f55c82cd6b28e157c', 'oldDns.novell.com','newDns.microfocus.com');

MS SQL Query

CREATE PROCEDURE replaceDNS @guid  nvarchar(100),@oldDns nvarchar(1024), @newDns  nvarchar(1024) 
AS 
BEGIN
  declare @actualValue nvarchar(1024), @updatedValue nvarchar(1024);
  select  @actualValue=data from zzenserverroles where id=@guid and roles = 'ZooKeeper';     
  print 'Actual value: ' + @actualValue;
  set @updatedValue = REPLACE(@actualValue, @oldDns, @newDns );
  print 'update value: ' + @updatedValue;
  update zzenserverroles set data=@updatedValue where id=@guid and roles = 'ZooKeeper';

  -- update zopaquedata for kafka cluster 
  IF EXISTS (select 1 from zopaquedata where name = 'kafka.cluster.config')   
  BEGIN
   select  @actualValue=data from zopaquedata where name = 'kafka.cluster.config';     
   print 'Actual value: ' + @actualValue;
   set @updatedValue = REPLACE(@actualValue, @oldDns, @newDns );
   print 'update value: ' + @updatedValue;
   update zopaquedata set data=@updatedValue where name = 'kafka.cluster.config';
  END
END;

Execute function/procedures in the database, for MS SQL to run the following function:
exec replaceDNS guid, oldDns, newDns

Example:

exec replaceDNS 0xc79de1490818e00f55c82cd6b28e157c, 'oldDns.novell.com','newDns.microfocus.com';

Oracle Query

CREATE OR REPLACE PROCEDURE replaceDNS(guid in varchar2,oldDns in varchar2, newDns in varchar2  )
as
 actualValue varchar2(1024);
 updatedValue varchar2(1024);
 BEGIN
 
   select data into actualValue from zzenserverroles where id=guid and roles = 'ZooKeeper';     
   dbms_output.put_line('Actual value: ' || actualValue);
   updatedValue := REPLACE(actualValue, oldDns, newDns );
   dbms_output.put_line('update value: ' || updatedValue);
   update zzenserverroles set data=updatedValue where id=guid and roles = 'ZooKeeper';
   
   -- update zopaquedata for kafka cluster 
   BEGIN
     select data into actualValue from zopaquedata where name = 'kafka.cluster.config';     
     dbms_output.put_line('Actual value: ' || actualValue);
     updatedValue := REPLACE(actualValue, oldDns, newDns );
     dbms_output.put_line('update value: ' || updatedValue);
     update zopaquedata set data=updatedValue where name = 'kafka.cluster.config';
   EXCEPTION 
    WHEN NO_DATA_FOUND THEN
      NULL;
   END;
 END;

Execute function/procedures in the database, for Oracle to run the following function:
select replaceDNS (guid, oldDns, newDns)

Example:

select replaceDNS('C79DE1490818E00F55C82CD6B28E157C', 'oldDns.novell.com' ,'newDns.microfocus.com');