Select Page

Art of BI: Installing BITeamwork on SSL Configured WebLogic Admin Server

Christian Screen | | September 24, 2014

Although not a very common integration but every now and then an organization will install OBIEE with SSL configured between the components. We probably see a bit more a company’s configuration of the Middleware WebLogic Administration Console with SSL.  This means that normally in order to access the WebLogic Administration Console, one would access it through http://servername:7001. That is HTTP, Server Name, and Port 7001 which are the defaults.  Some customers like to adjust this for security reasons such that for example usernames and passwords are not transferred over the network in “plain text”.  To do this they configure SSL and usually switch the port in the WebLogic Administration Console configuration for the admin server.  Clearly this involves a SSL certificate to be issued and configured on server if done correctly.

BITeamwork uses WLST to install itself onto the WebLogic Server.  The base install script that is provided with BITeamwork will fail in this SSL WebLogic Admin Server configuration as all WLST script must interact with the Weblogic Admin Server. So this blockage will result in an error within the install script because it is configured to install against a non-SSL admin server by default.

Errors that have been reported are similar to the ones below:

  • javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3://
  • Destination unreachable; nested exception is: java.net.SocketException: Connection reset: No available router to destintation

or

We fix this by conducting the following steps.

  1. Change the WEBLOGIC_URL variable from t3://localhost:7001 to have a t3s protocol which looks like t3s://localhost:7001, clearly here localhost could be change to the name of the server you are running the install script on or for.
  2. Add the following text, adjusted with you security keystore name, above the WEBLOGIC_URL variable setting:
    • JVM_ARGS=”-Dweblogic.security.SSL.ignoreHostnameVerification=true -Dweblogic.security.TrustKeyStore=DemoTrust”

    For step #2 remember to leave the quotes on a Linux/Unix OS but remove them on a Windows OS.

More detail about this solution can be found at, http://docs.oracle.com/cd/E13222_01/wls/docs92/config_scripting/wlst_faq.html#wp1061899, an excerpt of that page providing the solution is here:

If I have SSL or the administration port enabled for my server, how do I connect using WLST?

If you will be connecting to a WebLogic Server instance through an SSL listen port on a server that is using the demonstration SSL keys and certificates, invoke WLST using the following command:

java -Dweblogic.security.SSL.ignoreHostnameVerification=true -Dweblogic.security.TrustKeyStore=DemoTrust weblogic.WLST

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Art of BI: BI Publisher (BIP) Quick Guide and Tips

Read our blog post on how to take over production support of BI Publisher reports.

Sherry Milad | January 15, 2018

How to Index a Fact Table – A Best Practice

At the base of any good BI project is a solid data warehouse or data mart.

Christian Screen | March 16, 2010

Art of BI: How to Add Comments in Oracle BI (OBIEE)

Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.

Christian Screen | December 29, 2013

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS