nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

OracleUser_MUC6U

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

No but why do you need that? It works:

OracleUser_MUC6U

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

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

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

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

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

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

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

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.