Delphix Products

Expand all | Collapse all

error while discovering SAP ASE 15.7 on SOLARIS 10

Jump to Best Answer
  • 1.  error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:16:00 PM
    Hi,

    I'm in POV for one if my customerson SOLARIS 10 with SAP ASE 15.7 SP134. When I try to discover SAP ASE I received this error:

    Failed to discover environment variable $SYBASE on host "XXX.XXX.XXX.81"Make sure that environment variable $SYBASE is set for user "sybase" on the host.

    I have checked the delphix_os user that have enviroment variables on .bachrc and logging with the user and verifying the env variables seems ok but still get the same error

    Any Idea plz

    Thanks.

    Mouhssine
    #DemoEnvironment


  • 2.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:20:00 PM


  • 3.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:23:00 PM
    Hi,

    Already checked this post, but we are not on the same scope of this issue.

    As we have everything as required from the doc and the thinks we check from this post

    Thx,

    Regards,

    Mouhssine


  • 4.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:25:00 PM
    If you have exhausted everything in that post, I would advise opening a ticket to get support for your POV as your problem is beyond the scope of assistance that forums can provide.


  • 5.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:26:00 PM
    Hi Mouhssine,

    If you could try this command from another host, it would show us whether or not the SYBASE environment variable is set in the user's ".bashrc" during a non-interactive login:

    $ ssh delphix_os_user@nstacksolase2.dcenter.delphix.com env | grep SYBASE

    If you login interactively and then type "env | grep SYBASE" this is different than executing the command as I have shown above.

    Thanks,
      Neal



  • 6.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:46:00 PM
    Hi Neal,

    Can use an ssh test as this customer is using public keys to authenticat the server and have to explain to the security team such action to get the authorisation.

    But i'm providing you with the output of the barch and the env variables of the user delphix


    delpoc01@masekela:~ 16:40:46

    [130]$ env | grep SYBASE

    SYBASE_JRE6_64=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_JRE6_32=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_JRE7=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_JRE6=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_UA=/sybase/gsymeth3/asebin/UAF-2_5

    SYBASE_OCS=OCS-15_0

    SYBASE=/sybase/gsymeth3/asebin/OCS-15_0

    SYBASE_PLATFORM=sunsparc

    SYBASE_JRE_RTDS=/sybase/gsymeth3/asebin/shared/SAPJRE-7_1_011_64BIT

    SYBASE_JRE7_64=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_JRE7_32=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_WS=WS-15_0

    SYBASE_ASE=ASE-15_0

    delpoc01@masekela:~ 16:41:28

     

    [0]$ cat .bashrc

    # If not running interactively, don't do anything

    [ -z "$PS1" ] && return

     

    PATH=/opt/csw/bin:/opt/csw/sbin:$PATH

    export PATH

     

    MANPATH=/opt/csw/share/man:/usr/share/man:/usr/openwin/share/man:/usr/local/man:$MANPATH

    export MANPATH

     

    PAGER=less

    export PAGER

     

    EDITOR=/usr/bin/vi

    export EDITOR

     

    . /sybase/dba/sybenv.sh gsymeth3

     

    SYBASE=/sybase/gsymeth3/asebin

    export SYBASE

    export PATH

     

    PS1='\u@\h:\[\e[1;37m\]\w\[\e[0m\] \t\n[$?]\$ '

    export PS1

    delpoc01@masekela:~ 16:42:14

    [0]$



    Regards,


    Mouhssine



  • 7.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:50:00 PM
    Hi,

    Error for the logs

    [2015-12-15 05:33:41,014][INFO][environment.impl.discovery.ASEHostEnvironmentDiscoveryProvider#discoverEnvironment:403][Worker-218|JOB-108|ENVIRONMENT_DISCOVER(UNIX_HOST_ENVIRONMENT-17)][ACTION-264] Connected to host 10.22.164.65:22[2015-12-15 05:33:41,015][INFO][environment.impl.discovery.ASEHostEnvironmentDiscoveryProvider#logMe:71][Worker-218|JOB-108|ENVIRONMENT_DISCOVER(UNIX_HOST_ENVIRONMENT-17)][ACTION-264] Encountered User Exception in getSybaseEnvVar(), ASEHostEnvironmentDiscoveryProvider.java:164: exception.ase.environment.envvar.sybase.not_set {masekela.prod.par.gaselys.com|delpoc01}
    [2015-12-15 05:33:41,016][DEBUG][environment.impl.discovery.ASEHostEnvironmentDiscoveryProvider#logMe:73][Worker-218|JOB-108|ENVIRONMENT_DISCOVER(UNIX_HOST_ENVIRONMENT-17)][ACTION-264] 
    com.delphix.appliance.server.dco.events.enums.AseEnvironmentExceptions$EnvvarSybaseNotSet: exception.ase.environment.envvar.sybase.not_set {masekela.prod.par.gaselys.com|delpoc01}
    at com.delphix.appliance.server.environment.impl.discovery.ASEHostEnvironmentDiscoveryProvider.getSybaseEnvVar(ASEHostEnvironmentDiscoveryProvider.java:164)

    Regards,

    Mouhssine


  • 8.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:53:00 PM
    Hello,

    "SYBASE=/sybase/gsymeth3/asebin/OCS-15_0" is incorrect. It should be "SYBASE=/sybase/gsymeth3/asebin".

    I can't tell from your output but the "OCS-15_0" must be appended at some point later than where you set "SYBASE=/sybase/gsymeth3/asebin" in the ".bashrc" file.

    Is it also being set in a ".profile"?

    Do you have a ".ssh/environment" file where it might be set?

    Can you "echo $SHELL" and confirm to me what shell the user is using?

    Thanks,
      Neal


  • 9.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 02:58:00 PM
    Hi Neal,

    We corrected it and we have the same in .profile, but we don't have any .ssh/environnement file, as for the customer and me if we have everything in the source environnement of the user.

    what can justify adding the same export at the level of .ssh/envirnement

    Regards,

    Mouhssine


  • 10.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 03:14:00 PM
    Hi_ Neal,

    The requested changes and the outputs


    delpoc01@masekela:~ 17:07:03

    [0]$ env|grep SYBASE

    SYBASE_JRE6_64=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_JRE6_32=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_JRE7=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_JRE6=/sybase/gsymeth3/asebin/shared/JRE-6_0_24

    SYBASE_UA=/sybase/gsymeth3/asebin/UAF-2_5

    SYBASE_OCS=OCS-15_0

    SYBASE=/sybase/gsymeth3/asebin

    SYBASE_PLATFORM=sunsparc

    SYBASE_JRE_RTDS=/sybase/gsymeth3/asebin/shared/SAPJRE-7_1_011_64BIT

    SYBASE_JRE7_64=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_JRE7_32=/sybase/gsymeth3/asebin/shared/JRE-7_0_7

    SYBASE_WS=WS-15_0

    SYBASE_ASE=ASE-15_0

    delpoc01@masekela:~ 17:07:09

    [0]$ echo $PATH

    /usr/sbin:/usr/bin:/usr/ucb:/usr/local/bin:/sybase/gsymeth3/asebin/SCC-3_2/bin:/sybase/gsymeth3/asebin/ASE-15_0/jobscheduler/bin:/sybase/gsymeth3/asebin/ASE-15_0/bin:/sybase/gsymeth3/asebin/ASE-15_0/install:/sybase/gsymeth3/asebin/ASEP/bin:/sybase/gsymeth3/asebin/DBISQL/bin:/sybase/gsymeth3/asebin/UAF-2_5/bin:/sybase/gsymeth3/asebin/OCS-15_0/bin:/opt/csw/bin:/opt/csw/sbin:/usr/sbin:/usr/bin:/usr/ucb:/usr/local/bin:/sybase/gsymeth3/asebin/SCC-3_2/bin:/sybase/gsymeth3/asebin/ASE-15_0/jobscheduler/bin:/sybase/gsymeth3/asebin/ASE-15_0/bin:/sybase/gsymeth3/asebin/ASE-15_0/install:/sybase/gsymeth3/asebin/ASEP/bin:/sybase/gsymeth3/asebin/DBISQL/bin:/sybase/gsymeth3/asebin/UAF-2_5/bin:/sybase/gsymeth3/asebin/OCS-15_0/bin:/opt/csw/bin:/opt/csw/sbin:/usr/bin::.:/usr/platform/sun4u/sbin:/usr/local/bin:.:/usr/platform/sun4u/sbin:/usr/local/bin

    delpoc01@masekela:~ 17:07:18

    [0]$ which isql

    /sybase/gsymeth3/asebin/OCS-15_0/bin/isql

    delpoc01@masekela:~ 17:07:30


    [0]$ cat .bashrc

    # If not running interactively, don't do anything

    [ -z "$PS1" ] && return

     

    PATH=/opt/csw/bin:/opt/csw/sbin:$PATH

    export PATH

     

    MANPATH=/opt/csw/share/man:/usr/share/man:/usr/openwin/share/man:/usr/local/man:$MANPATH

    export MANPATH

     

    PAGER=less

    export PAGER

     

    EDITOR=/usr/bin/vi

    export EDITOR

     

    . /sybase/dba/sybenv.sh gsymeth3

     

    SYBASE=/sybase/gsymeth3/asebin

    export SYBASE

     

    PS1='\u@\h:\[\e[1;37m\]\w\[\e[0m\] \t\n[$?]\$ '

    export PS1

    delpoc01@masekela:~ 17:08:01

    [0]$ cat .profile

    #       This is the default standard profile provided to a user.

    #       They are expected to edit it to meet their own needs.

     

    MAIL=/usr/mail/${LOGNAME:?}

     

    # if running bash

    if [ -n "$BASH_VERSION" ]; then

        # include .bashrc if it exists

        if [ -f "$HOME/.bashrc" ]; then

            . "$HOME/.bashrc"

        fi

    fi

    . /export/home/delpoc01/.bashrc

    delpoc01@masekela:~ 17:08:07

    [0]$ ls -alrt .ssh

    total 8

    drwx------   2 delpoc01 delpoc01     512 Dec 15 12:18 .

    -rw-r--r--   1 delpoc01 delpoc01     402 Dec 15 12:18 authorized_keys

    drwxr-xr-x   4 delpoc01 delpoc01     512 Dec 15 14:32 ..

    -rw-r--r--   1 delpoc01 delpoc01     451 Dec 15 16:40 known_hosts

    delpoc01@masekela:~ 17:08:42

    [0]$ echo $SHELL

    /bin/bash

    delpoc01@masekela:~ 17:11:17



    Regards,


    Mouhssine



  • 11.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 03:16:00 PM
    Hello,

    In the link Adam referred to in the earlier response, this particular customer found that the SYBASE environment variable was not set during interactive logins unless they added it to the ".ssh/environment" file of the Delphix operating system user.

    The error message is accurate so in order to debug it yourself, I would recommend:
    1. Get a security exception for the public key from a different host so that you can at least temporarily test the non-interactive form of the environment variable check ($ ssh delphix_os_user@nstacksolase2.dcenter.delphix.com env | grep SYBASE).
    2. Try exporting it in the ".ssh/environment" file of your Delphix operating system user.
    Thanks,
      Neal


  • 12.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 03:17:00 PM
    Hi,

    I tried with the following setting and still failing with the same error "Failed to discover environment variable $SYBASE on host "xxxxxxxxxxxxxxxxxxxxxxx""

    Regards,

    Mouhssine


  • 13.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10

    Posted 12-15-2015 03:32:00 PM
    Hi Neal,

    We created  ".ssh/environment" file with exporting the $SYBASE variable

    After retring the same issue happens, i will try to get an exception from the security team to get the ssh test done

    Regards,

    Mouhssine


  • 14.  RE: error while discovering SAP ASE 15.7 on SOLARIS 10
    Best Answer

    Posted 12-22-2015 12:35:00 PM
    Hi,

    All we got it.

    The issue comes from a mixe of env variables that are not set with dynamic login and sybase bug http://service.sap.com/sap/support/notes/2053674

    after passing the patch things are ok

    Thanks to all


    Mouhssine