error while discovering SAP ASE 15.7 on SOLARIS 10

  • 0
  • 1
  • Problem
  • Updated 2 years ago
  • Solved
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
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.
Photo of Neal Stack

Neal Stack, Official Rep

  • 2,392 Points 2k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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

Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Neal Stack

Neal Stack, Official Rep

  • 2,392 Points 2k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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

Photo of Neal Stack

Neal Stack, Official Rep

  • 2,392 Points 2k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb
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