LD_LIBRARY_PATH can't be found

[#1]

Hi everybody. When I use https://github.com/cloudera/hue/blob/master/tools/ops/hue_sync_ldap_groups_cron.sh to sync ldap groups with hue on my first cluster it's works fine but when I use on a second cluster I have one error  "LD_LIBRARY_PATH can't be found, if you are using ORACLE for your Hue database
then it must be set, if not, you can ignore
export LD_LIBRARY_PATH=/path/to/instantclient". Cause this error,  we can't retreive de ldap_config used later in the scripts. Does someone know how to fix this issue. Thanks 😉

[#2]

@Bilal_Hammas 

Seems like you do not have the below 2 global parameters exported in the problematic cluster Hue node and these libraries are needed to sync LDAP users into Hue DB when you use an Oracle DB as a backend database to Hue.

To check that please run the below command in the Hue node

 >> $ echo $ORACLE_HOME 

>> $ echo $LD_LIBRARY_PATH

If the above 2 commands return no values then the error that you hitting is expected.

Please export these 2 parameters in the Hue hosted node.

>> log in to the Hue node say for example with the root user

>> Find the path where you have instantclient installed

>> $locate instantclient

>> Copy the instantclient path from the above command and replace it with /path/instantclient in the below command

>> $ export ORACLE_HOME=</path/instantclient>

>> Check again if you can see the value

>> $ echo $ORACLE_HOME 

>> Then export the LD library path by running

>> $ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

>>Check again if you can see the value

>> $ echo $LD_LIBRARY_PATH

>> Then try to sync ldap groups again with hue and share your observations.

[#3]

@Bilal_Hammas Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks.

[#4]

no, Unfortunately.

[#5]

@Bilal_Hammas 

Please share the output of the below 2 commands from the working cluster

 >> $ echo $ORACLE_HOME 

>> $ echo $LD_LIBRARY_PATH

[#6]

@Bilal_Hammas Has the reply helped resolve your issue? Can you provide the information @iks has requested? Thanks.

[#7 · Accepted solution]

It was a python version issue between the 2 clusters