Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  dx_get_db_env - Error while connecting

    Posted 11-15-2022 01:45:00 PM
    Hi Team,

    I am unable to connect to the delphix engine using "dx_get_db_env" command.

    It says "Can't connect to Dephix Engine brsqpdpxxxx"

    It was working couple of months back, not sure why it has stopped working. 

    DX tool kit2 version: 2.3.9.1
    Delphix engine version: Continuous Data 6.0.13.0
    Note: Port 22 is working and not blocked by firewall


    ------------------------------
    Faioze Ahmed
    SQL Server DBA
    Mercury Insurance Services
    ------------------------------


  • 2.  RE: dx_get_db_env - Error while connecting

    Posted 11-17-2022 09:44:00 AM
    Edited by Michael Torok 11-17-2022 11:09:59 AM
    Hi Faioze,

    Did you take out the hostname/ip you use (I guess in config file?) and try to connect to engine from same host, using ssh with the same user?  Like "ssh admin@engine_address" - does this work?


    ------------------------------
    Paul Vero
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: dx_get_db_env - Error while connecting

    Posted 11-17-2022 01:05:00 PM
    Hi Paul Vero,
    Thanks for your email. I tried like you mentioned and it is working and able to connect.
    Command I tried: ssh delphix_admin@brsqpdpxxxx

    Below is the command I am trying to execute but it saying that "Can't connect to Dephix Engine brsqpdpxxxx".

    D:\DelhixEnvironmentReports\dx_get_db_env.exe -d brsqpdpxxxx -type VDB -parentlast p -nohead > D:\\DelphixEnvironment.txt

    Please help here. Thanks in advance.

    Note:
    Delphix engine hosted in Ubuntu Linux box.
    DXtoolkits installed on Windows server and we are trying to connect from Windows server to Linux box

    ------------------------------
    Faioze Ahmed
    SQL Server DBA
    Mercury Insurance Services
    ------------------------------



  • 4.  RE: dx_get_db_env - Error while connecting

    Posted 11-17-2022 02:14:00 PM
    Hi Faioze,

    I don't know your configuration, what version windows, etc.  Did you run ssh from the Windows host you are running dx toolkit from (some newer Windows powershell can run "ssh").  Or did you run it somewhere else?

    Can you connect to the engine from Windows with your browser?  Into the GUI app?
    The error implies you are unable to reach the engine hostname from your Windows machine - other things you can try are nslookup on that hostname.

    Cheers,

    ------------------------------
    Paul Vero
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: dx_get_db_env - Error while connecting
    Best Answer

    Posted 11-21-2022 03:26:00 AM
    Hello Firoz,

    If you can install the dxtoolkit on target server then install it on any target server ( if its NFS)
    Or install it on all target server.
    If you are using HTTPS then use port 443 and for HTTP use 80 port.

    you have to update the dxtools.conf file 
    "data":[
    {
    "hostname" : "ENgine Name",
    "ip_address" : "IP ADDRESS",
    "username" : "USERNAME",
    "password" : "PASSWORD",
    "port" : "443", or 80
    "default" : "false", or TRUE
    "encrypted" : "false",
    "timeout" : "60",
    "protocol" : "https" or HTTP
    }
    ]
    Save the dxtools.conf file and try it should work.
    Or please share the logs from admin > Logs.
    you can check the latest version here 
    https://github.com/delphix/dxtoolkit/releases





    ------------------------------
    Pankaj Asegaonkar
    Delphix
    Infosys
    ------------------------------



  • 6.  RE: dx_get_db_env - Error while connecting

    Posted 11-22-2022 11:27:00 AM
    Thank you so much, Pankaj.

    In our config we didn't have a parameter "protocol". 

    As per your suggestion, I have added the protocol "https" and port 443 and it worked perfectly. Thank you so much.

    ------------------------------
    Faioze Ahmed
    SQL Server DBA
    Mercury Insurance Services
    ------------------------------