Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE12c - Automation of user/group adapter files creation for SQLAuthenticator

Received Response
102
Views
9
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hi,

I'm automating the configuration for the SQLAuthentictor on OBIEE 12.2.1.2.0 and for this i need to call the OOTB script libovdadapterconfig.sh to add the necessary user and group adapter files.  However when libovdadapterconfig.sh is executed with the list of allowed parameter values supplied, it prompts for the Weblogic Admin password which is required.  There doesn't seem to be an option to pass the password to libovdadapterconfig.sh as a parameter.  Anyone seen this and able to pass password as a parameter?

Thanks

Adrian

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No but why do you need that? It works:

    pastedImage_0.png

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Hi Christian,

    Thanks for your reply.  Yes it does work however for our Cloud Infrastructure environment we need to automate the script without any manual intervention.  Its strange why there is a -userName for user name but none for the password.  Any ideas?

    Adrian 

  • Gianni Ceresa
    Gianni Ceresa Mod

    Why don't you use typical linux tools for that?

    There are many ways and commands which can simulate a user entering a password when a script/command doesn't have a parameter for it.

    Otherwise there would be little to no automation at all as many scripts/commands don't have all the parameter you need and are only interactive CLI things.

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Thanks Gianni.

    Yes i am looking into that now.  Normally I just need to define a local variable in the Linux script and pass the value with the parameter option like userName $local_var_name.  I just thought its strange that the OOTB script doesn't have an option to accept the password as a parameter.

    Thanks for you help.

    Adrian

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    No matter what way i frame it in linux scripting to pass the password as a parameter value i get the following error libovdadapterconfig.sh.  Its possible because the password value is being passed with no associated parameter name.

    Exception in thread "main" java.lang.NullPointerException

            at oracle.ods.virtualization.config.TemplateAdapter.parseCommandLineArgs(TemplateAdapter.java:785)

            at oracle.ods.virtualization.config.TemplateAdapter.main(TemplateAdapter.java:917)

    Adrian

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you try something like https://stackoverflow.com/questions/49866578/how-to-automatically-answer-user-prompts-in-java  too ?

    The .sh does execute a piece of java, something like exec ${JAVA_HOME}/bin/java ${JAVA_EXE_MODE} -classpath ${CLASSPATH} oracle.ods.virtualization.config.TemplateAdapter "$@" there adding a timer to make your "input" of the password wait could work as you need to wait the Java start before to inject the password.

    There are other way to deal with Java prompts for input looking on Google.

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Hi Gianni,

    I can't get the time delay to work.  I also tried echo -e "<password>" | <script>  but get an error.

    Any ideas?

    Adrian

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi Adrian,

    Nothing else cross by my mind at this time. It would require to be tested (and abused) till something work, but I already have long list of things to do/try first ...

    Did you try opening a SR to ask Oracle if they maybe have a hidden param or way to pass that password?

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Thanks Gianni.  I appreciate your time.

    We look to have crack it using the linux util - Expect :-)

    Also opened an SR to check if there is a hidden parameter.

    Thanks again.