Delphix Toolkits (dxToolkit and dxmToolkit)

When I create a hook using dx_ctl_dbhooks toolkit, it creates a hook in the VDB with the content of the script which I passed as hook.
e.g.:
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /home/delphix/delphix_oratab.sh

When I check configure clone hook in the Engine, the entire script content appears in the hook. I believe the hook should be created only with the exact path of the script (as "/home.delphix/delphix_oratab.sh") which needs to be executed as hook (script might have some runtime user arguments), and not the entire content of the script.

Please check if this can be corrected to fix this behavior. 

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Hi,

File /home/delphix/delphix_oratab.sh on machine with Dxtoolkit installed should contain a requested hook body.
If you want to call script "/path/foo.sh" using Dephix Hook you need to do the following:

1. Create a file 

/tmp/myhook.txt with body:
/path/foo.sh

2. run Dxtoolkit command
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /tmp/myhook.txt

and body of /tmp/myhook.txt will be uploaded as hook body.

regards,
Marcin



------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
------------------------------

Original Message:
Sent: 04-27-2020 05:34:05 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

When I create a hook using dx_ctl_dbhooks toolkit, it creates a hook in the VDB with the content of the script which I passed as hook.
e.g.:
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /home/delphix/delphix_oratab.sh

When I check configure clone hook in the Engine, the entire script content appears in the hook. I believe the hook should be created only with the exact path of the script (as "/home.delphix/delphix_oratab.sh") which needs to be executed as hook (script might have some runtime user arguments), and not the entire content of the script.

Please check if this can be corrected to fix this behavior. 

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Hi Marcin,

The suggested workaround is helpful upto some extent. But, I am looking forward if this behavior is going to be fixed because we have several custom scripts with runtime user variable/arguments to be passed which are dynamically generated. These scripts need to be triggered as hooks. 
It will be more meaningful to only consider the passed command/script details in hook instead of converting to script body.

Please check and suggest.

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Original Message:
Sent: 04-27-2020 08:30:49 AM
From: Marcin Przepiorowski
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hi,

File /home/delphix/delphix_oratab.sh on machine with Dxtoolkit installed should contain a requested hook body.
If you want to call script "/path/foo.sh" using Dephix Hook you need to do the following:

1. Create a file 

/tmp/myhook.txt with body:
/path/foo.sh

2. run Dxtoolkit command
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /tmp/myhook.txt

and body of /tmp/myhook.txt will be uploaded as hook body.

regards,
Marcin



------------------------------
Marcin Przepiorowski
Technical Principal
Delphix

Original Message:
Sent: 04-27-2020 05:34:05 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

When I create a hook using dx_ctl_dbhooks toolkit, it creates a hook in the VDB with the content of the script which I passed as hook.
e.g.:
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /home/delphix/delphix_oratab.sh

When I check configure clone hook in the Engine, the entire script content appears in the hook. I believe the hook should be created only with the exact path of the script (as "/home.delphix/delphix_oratab.sh") which needs to be executed as hook (script might have some runtime user arguments), and not the entire content of the script.

Please check if this can be corrected to fix this behavior. 

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Hello,

This is not a workaround but this is how this script has been design.
Passing hooks body directly from command line it's very tricky and it will requires a lot of escape characters so parsing shell will skip 
special characters needed in the scripts.

You can still generate automatically a text file with hook body and use it as input of dx_ctl_dbhook

regards,
Marcin

------------------------------
Marcin Przepiorowski
Technical Principal
Delphix
------------------------------

Original Message:
Sent: 04-28-2020 03:02:24 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hi Marcin,

The suggested workaround is helpful upto some extent. But, I am looking forward if this behavior is going to be fixed because we have several custom scripts with runtime user variable/arguments to be passed which are dynamically generated. These scripts need to be triggered as hooks. 
It will be more meaningful to only consider the passed command/script details in hook instead of converting to script body.

Please check and suggest.

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys

Original Message:
Sent: 04-27-2020 08:30:49 AM
From: Marcin Przepiorowski
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hi,

File /home/delphix/delphix_oratab.sh on machine with Dxtoolkit installed should contain a requested hook body.
If you want to call script "/path/foo.sh" using Dephix Hook you need to do the following:

1. Create a file 

/tmp/myhook.txt with body:
/path/foo.sh

2. run Dxtoolkit command
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /tmp/myhook.txt

and body of /tmp/myhook.txt will be uploaded as hook body.

regards,
Marcin



------------------------------
Marcin Przepiorowski
Technical Principal
Delphix

Original Message:
Sent: 04-27-2020 05:34:05 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

When I create a hook using dx_ctl_dbhooks toolkit, it creates a hook in the VDB with the content of the script which I passed as hook.
e.g.:
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /home/delphix/delphix_oratab.sh

When I check configure clone hook in the Engine, the entire script content appears in the hook. I believe the hook should be created only with the exact path of the script (as "/home.delphix/delphix_oratab.sh") which needs to be executed as hook (script might have some runtime user arguments), and not the entire content of the script.

Please check if this can be corrected to fix this behavior. 

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Thanks Marcin, 
If its designed in such way, I think what you suggested as alternate should be helpful to achieve what I am looking for. 

Regards,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------

Original Message:
Sent: 04-28-2020 03:17:58 AM
From: Marcin Przepiorowski
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hello,

This is not a workaround but this is how this script has been design.
Passing hooks body directly from command line it's very tricky and it will requires a lot of escape characters so parsing shell will skip 
special characters needed in the scripts.

You can still generate automatically a text file with hook body and use it as input of dx_ctl_dbhook

regards,
Marcin

------------------------------
Marcin Przepiorowski
Technical Principal
Delphix

Original Message:
Sent: 04-28-2020 03:02:24 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hi Marcin,

The suggested workaround is helpful upto some extent. But, I am looking forward if this behavior is going to be fixed because we have several custom scripts with runtime user variable/arguments to be passed which are dynamically generated. These scripts need to be triggered as hooks. 
It will be more meaningful to only consider the passed command/script details in hook instead of converting to script body.

Please check and suggest.

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys

Original Message:
Sent: 04-27-2020 08:30:49 AM
From: Marcin Przepiorowski
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

Hi,

File /home/delphix/delphix_oratab.sh on machine with Dxtoolkit installed should contain a requested hook body.
If you want to call script "/path/foo.sh" using Dephix Hook you need to do the following:

1. Create a file 

/tmp/myhook.txt with body:
/path/foo.sh

2. run Dxtoolkit command
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /tmp/myhook.txt

and body of /tmp/myhook.txt will be uploaded as hook body.

regards,
Marcin



------------------------------
Marcin Przepiorowski
Technical Principal
Delphix

Original Message:
Sent: 04-27-2020 05:34:05 AM
From: Sushil Krishn
Subject: dx_ctl_dbhooks creates hook with entire content of given HookScript instead of creating hook with script path

When I create a hook using dx_ctl_dbhooks toolkit, it creates a hook in the VDB with the content of the script which I passed as hook.
e.g.:
dx_ctl_dbhooks -d de1 -action set -hookname confighook1 -hooktype configureClone -dbname msktest1 -hook /home/delphix/delphix_oratab.sh

When I check configure clone hook in the Engine, the entire script content appears in the hook. I believe the hook should be created only with the exact path of the script (as "/home.delphix/delphix_oratab.sh") which needs to be executed as hook (script might have some runtime user arguments), and not the entire content of the script.

Please check if this can be corrected to fix this behavior. 

Thanks,
Sushil

------------------------------
Sushil Krishn
Oracle DBA
Unisys
------------------------------