Delphix Products

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

Hey Mouhssine,

Check out this community post on the same subject. https://community.delphix.com/delphix/topics/error-while-discovering-sap-ase-15-7-on-aix-7-1?topic-r...

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

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.

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

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

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

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

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

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

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

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

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

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