Delphix Toolkits (dxToolkit and dxmToolkit)

Horacio

Hi Horacio.
What exactly are you trying to achieve by running this command?

Horacio

Hi Jose.

I usually use dxtoolkit to document client installations or to generate configuration reports. When executing the dx_get_db_env command, I expected to get a result like the following:

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
dpxlab01.gruponet.co 192.168.73.163       datasets_prod                  Datasets_Prd    dSource                                 N/A                                       0.29 RUNNING    enabled    N/A                            N/A                                 2023-11-22 12:23:46                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       0.87 UNKNOWN    enabled    ORCLCDB                        N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.17 INACTIVE   enabled    N/A                            N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.80        datasets_qa                    Datasets_QA     VDB      datasets_prod                  2023-11-22 12:24:32 -03                   0.00 RUNNING    enabled    N/A                            2023-11-22 12:24:32 -03             2023-11-22 12:48:07                 2023-11-22 12:48:07           

This command used to work with previous versions of the virtualization engine.

Again, I get this error "There is no DB selected to process on dpxlab . Please check filter definitions." while running many other dx_ commands. I will make a list of them.

Thanks for your help

Hi Horacio.
What exactly are you trying to achieve by running this command?

Horacio

Hello Horatio,

I upgraded my dxtoolkit to 2.4.24 and ran it against a Delphix 24.0.0.0 engine and it worked:

% ./dx_get_db_env -version

2.4.24

% ./dx_get_db_env -engine venus

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
venus                orcl-191100-src.supp DBOMSRCD94D3                   luke - worldpay dSource                                 N/A                                       1.87 RUNNING    enabled    DBOMSRCD94D3                   N/A                                 2024-02-12 11:39:43                 N/A                                 
venus                orcl-191100-tgt.supp lukevdb                        luke - worldpay VDB      DBOMSRCD94D3                   2024-02-29 06:31:38 EST                   1.77 RUNNING    enabled    lukevdb     
...etc...

In your screen shot, it shows the engine name as "dpxlab01" but in your command and debug output it shows engine "dpxlab".

I wonder if there is a double entry or some other type of problem in your "/home/hrosende/bin/dxtoolkit2/dxtools.conf" file? In your output it shows that it is loading the configuration for "Loading engine dpxlab" twice:

# ./dx_get_db_env -d dpxlab -rdbms oracle --debug 4
Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /home/hrosende/bin/dxtoolkit2/dxtools.conf
 -Loading engine dpxlab
 -Loading engine dpxlab
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /tmp/cookies.hrosende.dpxlab
connecting to: dpxlab ( IP/name : 192.168.73.85 )

When I test in my environment with "-debug 4" I only see each configuration loaded once:

Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /Users/neal.stack/Downloads/dxtoolkit2424/dxtoolkit2/dxtools.conf
 -Loading engine neal1800
 -Loading engine venus
 -Loading engine saturn
 -Loading engine masking
 -Loading engine Landshark2
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /var/folders/qs/t716yhb17bjct0t54jzwftyh0000gp/T/cookies.neal.stack.venus
connecting to: venus ( IP/name : de-venus.supportlab.delphix.com )

Thanks,

Neal

Hi Jose.

I usually use dxtoolkit to document client installations or to generate configuration reports. When executing the dx_get_db_env command, I expected to get a result like the following:

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
dpxlab01.gruponet.co 192.168.73.163       datasets_prod                  Datasets_Prd    dSource                                 N/A                                       0.29 RUNNING    enabled    N/A                            N/A                                 2023-11-22 12:23:46                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       0.87 UNKNOWN    enabled    ORCLCDB                        N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.17 INACTIVE   enabled    N/A                            N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.80        datasets_qa                    Datasets_QA     VDB      datasets_prod                  2023-11-22 12:24:32 -03                   0.00 RUNNING    enabled    N/A                            2023-11-22 12:24:32 -03             2023-11-22 12:48:07                 2023-11-22 12:48:07           

This command used to work with previous versions of the virtualization engine.

Again, I get this error "There is no DB selected to process on dpxlab . Please check filter definitions." while running many other dx_ commands. I will make a list of them.

Thanks for your help

Hi Horacio.
What exactly are you trying to achieve by running this command?

Horacio

Hello Neal,

I posted an example of what I used to get. You are right; the hostname is not the same. I've changed dxtools.conf several times to make it work in Fedora 40, Oracle Server 8.10, and Windows 11. I uploaded a zip file with current configuration and debug output. I replaced an IP address portion and passwords with XXX on purpose.

I get this message when running ./dx_get_db_env -d dpxlab -rdbms oracle -debug 3.

There is no DB selected to process on dpxlab . Please check filter definitions.

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- -----------------------------------

Thanks for your help

Hello Horatio,

I upgraded my dxtoolkit to 2.4.24 and ran it against a Delphix 24.0.0.0 engine and it worked:

% ./dx_get_db_env -version

2.4.24

% ./dx_get_db_env -engine venus

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
venus                orcl-191100-src.supp DBOMSRCD94D3                   luke - worldpay dSource                                 N/A                                       1.87 RUNNING    enabled    DBOMSRCD94D3                   N/A                                 2024-02-12 11:39:43                 N/A                                 
venus                orcl-191100-tgt.supp lukevdb                        luke - worldpay VDB      DBOMSRCD94D3                   2024-02-29 06:31:38 EST                   1.77 RUNNING    enabled    lukevdb     
...etc...

In your screen shot, it shows the engine name as "dpxlab01" but in your command and debug output it shows engine "dpxlab".

I wonder if there is a double entry or some other type of problem in your "/home/hrosende/bin/dxtoolkit2/dxtools.conf" file? In your output it shows that it is loading the configuration for "Loading engine dpxlab" twice:

# ./dx_get_db_env -d dpxlab -rdbms oracle --debug 4
Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /home/hrosende/bin/dxtoolkit2/dxtools.conf
 -Loading engine dpxlab
 -Loading engine dpxlab
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /tmp/cookies.hrosende.dpxlab
connecting to: dpxlab ( IP/name : 192.168.73.85 )

When I test in my environment with "-debug 4" I only see each configuration loaded once:

Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /Users/neal.stack/Downloads/dxtoolkit2424/dxtoolkit2/dxtools.conf
 -Loading engine neal1800
 -Loading engine venus
 -Loading engine saturn
 -Loading engine masking
 -Loading engine Landshark2
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /var/folders/qs/t716yhb17bjct0t54jzwftyh0000gp/T/cookies.neal.stack.venus
connecting to: venus ( IP/name : de-venus.supportlab.delphix.com )

Thanks,

Neal

Hi Jose.

I usually use dxtoolkit to document client installations or to generate configuration reports. When executing the dx_get_db_env command, I expected to get a result like the following:

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
dpxlab01.gruponet.co 192.168.73.163       datasets_prod                  Datasets_Prd    dSource                                 N/A                                       0.29 RUNNING    enabled    N/A                            N/A                                 2023-11-22 12:23:46                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       0.87 UNKNOWN    enabled    ORCLCDB                        N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.17 INACTIVE   enabled    N/A                            N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.80        datasets_qa                    Datasets_QA     VDB      datasets_prod                  2023-11-22 12:24:32 -03                   0.00 RUNNING    enabled    N/A                            2023-11-22 12:24:32 -03             2023-11-22 12:48:07                 2023-11-22 12:48:07           

This command used to work with previous versions of the virtualization engine.

Again, I get this error "There is no DB selected to process on dpxlab . Please check filter definitions." while running many other dx_ commands. I will make a list of them.

Thanks for your help

Hi Horacio.
What exactly are you trying to achieve by running this command?

Horacio

Hi Horatio,

It is the second entry that is causing the issue. It loads the first "dpxlab" configuration with the "admin" user. Then it overwrites that configuration when it loads the second "dpxlab" configuration for the "sysadmin" user.

The "sysadmin" user doesn't have access to the same APIs as the "admin" user and so you get an empty result set back.

The "hostname" field in the configuration file is not a literal host name. It is an identifier ( https://github.com/delphix/dxtoolkit/wiki#configuration ):

Can you try giving the two entries in your configuration file a unique host name? Maybe something like the following?

            "hostname" : "dpxlab",
            "ip_address" : "192.168.XX.XX",
            "username" : "admin",

and

            "hostname" : "sysadmin_dpxlab",
            "ip_address" : "192.168.XX.XX",
            "username" : "sysadmin",

Thanks,

Neal

Hello Neal,

I posted an example of what I used to get. You are right; the hostname is not the same. I've changed dxtools.conf several times to make it work in Fedora 40, Oracle Server 8.10, and Windows 11. I uploaded a zip file with current configuration and debug output. I replaced an IP address portion and passwords with XXX on purpose.

I get this message when running ./dx_get_db_env -d dpxlab -rdbms oracle -debug 3.

There is no DB selected to process on dpxlab . Please check filter definitions.

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- -----------------------------------

Thanks for your help

Hello Horatio,

I upgraded my dxtoolkit to 2.4.24 and ran it against a Delphix 24.0.0.0 engine and it worked:

% ./dx_get_db_env -version

2.4.24

% ./dx_get_db_env -engine venus

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
venus                orcl-191100-src.supp DBOMSRCD94D3                   luke - worldpay dSource                                 N/A                                       1.87 RUNNING    enabled    DBOMSRCD94D3                   N/A                                 2024-02-12 11:39:43                 N/A                                 
venus                orcl-191100-tgt.supp lukevdb                        luke - worldpay VDB      DBOMSRCD94D3                   2024-02-29 06:31:38 EST                   1.77 RUNNING    enabled    lukevdb     
...etc...

In your screen shot, it shows the engine name as "dpxlab01" but in your command and debug output it shows engine "dpxlab".

I wonder if there is a double entry or some other type of problem in your "/home/hrosende/bin/dxtoolkit2/dxtools.conf" file? In your output it shows that it is loading the configuration for "Loading engine dpxlab" twice:

# ./dx_get_db_env -d dpxlab -rdbms oracle --debug 4
Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /home/hrosende/bin/dxtoolkit2/dxtools.conf
 -Loading engine dpxlab
 -Loading engine dpxlab
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /tmp/cookies.hrosende.dpxlab
connecting to: dpxlab ( IP/name : 192.168.73.85 )

When I test in my environment with "-debug 4" I only see each configuration loaded once:

Dxtoolkit version 2.4.24
-Entering Engine::constructor
-Entering Engine::load_config
Loading engines from /Users/neal.stack/Downloads/dxtoolkit2424/dxtoolkit2/dxtools.conf
 -Loading engine neal1800
 -Loading engine venus
 -Loading engine saturn
 -Loading engine masking
 -Loading engine Landshark2
-Entering Engine::dlpx_connect
-Login type: password
 -Cookie file /var/folders/qs/t716yhb17bjct0t54jzwftyh0000gp/T/cookies.neal.stack.venus
connecting to: venus ( IP/name : de-venus.supportlab.delphix.com )

Thanks,

Neal

Hi Jose.

I usually use dxtoolkit to document client installations or to generate configuration reports. When executing the dx_get_db_env command, I expected to get a result like the following:

Appliance            Hostname             Database                       Group           Type     SourceDB                       Parent snapshot                     Used [GB]  Status     Enabled    Unique Name                    Parent time                         VDB creation time                   VDB refresh time                    
-------------------- -------------------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ---------- ---------- ---------- ------------------------------ ----------------------------------- ----------------------------------- ----------------------------------- 
dpxlab01.gruponet.co 192.168.73.163       datasets_prod                  Datasets_Prd    dSource                                 N/A                                       0.29 RUNNING    enabled    N/A                            N/A                                 2023-11-22 12:23:46                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLCDB                        Datasets_Prd    CDB                                     N/A                                       0.87 UNKNOWN    enabled    ORCLCDB                        N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.82        ORCLPDB1                       Datasets_Prd    dSource                                 N/A                                       0.17 INACTIVE   enabled    N/A                            N/A                                 2023-12-03 12:15:39                 N/A                                 
dpxlab01.gruponet.co 192.168.73.80        datasets_qa                    Datasets_QA     VDB      datasets_prod                  2023-11-22 12:24:32 -03                   0.00 RUNNING    enabled    N/A                            2023-11-22 12:24:32 -03             2023-11-22 12:48:07                 2023-11-22 12:48:07           

This command used to work with previous versions of the virtualization engine.

Again, I get this error "There is no DB selected to process on dpxlab . Please check filter definitions." while running many other dx_ commands. I will make a list of them.

Thanks for your help

Hi Horacio.
What exactly are you trying to achieve by running this command?

Horacio