Delphix Products

Expand all | Collapse all

Skipping discovery for ASE dataserver with pid on host

Jump to Best Answer
  • 1.  Skipping discovery for ASE dataserver with pid on host

    Posted 03-22-2019 01:16:00 PM


  • 2.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-22-2019 01:26:00 PM
    Hello,

    It sounds like the ASE instance does not have the "-s <database_server_name>" parameter. The automatic discovery process needs the "-s" parameter so that it can later run "isql -U xxx -P xxx -S abc" to connect to the ASE instance and run some queries against sysdatabases and syslisteners.

    Without that parameter, it doesn't know the name of the ASE instance  associated with the "dataserver" process.

    If you have ASE instances that are started without the "-s" command line parameter, you can add them to Delphix manually using the command line interface (CLI):
    https://docs.delphix.com/docs/reference/command-line-interface-guide/cli-cookbook-common-workflows-t...

    I hope this helps.

    Thanks,
      Neal



  • 3.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-22-2019 01:47:00 PM
    I looked Faulst and i found information about WARNING Message

    <<Unable to execute '/var/opt/delphix/Toolkit/Delphix_COMMON_423d396a_2e8a_9c45_5f6a_b7858aa160f2_delphix_host/scripts/bin/dlpx_pfexec ps -Xeo user,pid,args' as user 'delphix_os' via sudo.>>

    What is mean and how to solve it?


  • 4.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-22-2019 01:54:00 PM
    Hello,

    Where are you seeing that? Are you seeing that in the debug logs?

    I'm not sure it is impacting discovery of the ASE instances. It may try an to run the "ps" command via sudo first and if that fails, it falls back to trying to run it without sudo.

    If you run "ps -ef | grep dataserver" do you see that your ASE instance is using the "-s servername" parameter? 


  • 5.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-25-2019 06:22:00 AM
    I see  WARNING Message  in the debug logs

    I was run "ps -ef | grep dataserver".
    I got:
      sybase  7864430 11927586   0   Apr 04      - 10389:59 /opt/sybase/ASE157/ASE-1            5_0/bin/dataserver -d/opt/sybase/data/IB2/system/master.dat -e/opt/sybase/log/IB            2_DS.log -c/opt/sybase/ASE157/ASE-15_0/IB2.cfg -M/opt/sybase/ASE157/ASE-15_0 -sI            B2 -T7717

      sybase 15139022 15073486   0   Sep 02      - 2544:14 /opt/sybase/ASE157/ASE-15            _0/bin/dataserver -d/opt/sybase/data/IB2ARCH/system/master.dat -e/opt/sybase/log            /IB2ARCH_DS.log -c/opt/sybase/ASE157/ASE-15_0/IB2ARCH.cfg -M/opt/sybase/ASE157/A            SE-15_0 -sIB2ARCH

    It's ok?



  • 6.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-25-2019 07:42:00 AM
    i have new error.


  • 7.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-25-2019 08:26:00 AM
    I didn't find solution problem. It is not describe in instruction.


  • 8.  RE: Skipping discovery for ASE dataserver with pid on host

    Posted 03-25-2019 11:10:00 AM
    i solved it


  • 9.  RE: Skipping discovery for ASE dataserver with pid on host
    Best Answer

    Posted 03-25-2019 12:43:00 PM
    Hello,

    Here is how Delphix attempts to discover ASE instances:
    • Get the $SYBASE environment variable by looking for the environment variable in the user’s list of environment variables (the user as specified in the OS Username of the Add Environment dialogue). This must be defined for non-interactive logins. This can be tested by executing "ssh delphix_os_user@ase_host env | grep SYBASE".
    • Get the path to the isql binary looking under $SYBASE
    • List the running instances using ps (see get_ase_instances.sh for details).
      • In Delphix 4.3 and higher, the get_ase_instances.sh script is no longer run. Instead it uses the ProcessExplorer java class 
    • For each instance:
      • Get the list of ports by running isql and querying the syslisteners table (see get_ase_instance_ports.sh for details).
      • Connect via JDBC using the port retrieved from syslisteners and the host/IP entered in the environment definition screen. After successfully connecting, retrieve @@servername. Use the first port that works where @@servername is the same as the value from ps.
      • Using JDBC, populate page size, instance owner and other attributes for each instance.
      • Discover the list of user databases for each instance by querying sysdatabases (excluding the system databases 'master', 'model', 'sybsystemdb', ‘sybsystemprocs' and ‘tempdb').

    So what those error messages are telling you is that Delphix is unable to connect to those ASE instances using "isql". Error 4002 is usually a username/password issue.

    Note that since only a single $SYBASE environment variable is used, only that $SYBASE/interfaces file is used when connecting to each ASE instance. So if there are multiple ASE instances you wish to discover automatically, all of them need to be in the Delphix operating system user's $SYBASE/interfaces file.


  • 10.  RE: Skipping discovery for ASE dataserver with pid on host