SungHoon_Kim

Creating an ALL-IN-ONE VM Image - Part 10-1

Blog Post created by SungHoon_Kim Employee on Nov 23, 2015

This is something I like to do once in a while. It takes long time to setup everything but to me it is a hobby. It is like putting zigsaw puzzles.

 

WARNING: THIS IS NOT SUPPORTED! THIS IS ONLY TO FULFILL YOUR CURIOSITY AND SATISFY YOUR SPIRIT GOING AGAINST ALL ODDS. THIS IS NOT A DEMONSTRATION ALLOWING YOU TO RUN SUCH CONFIGURATION IN YOUR DEV/TEST/QA/PROD ENVIRONMENT.

 

Following components will be installed.

 

01. Install OS (Windows 2008 R2 - English)

02. Microsoft Loopback Adapter

03. Active Directory

04. DNS

05. IIS

06. Certificate Authority

07. MSSQL 2012

08. JDK 1.7.0_80 (32bit and 64bit)

09. NewAtlanta ServletExec 6.0

10. ASF Apache

11. CA Directory

12. Oracle Directory Server 11g

13. CA Single Sign-On Policy Server

14. CA Single Sign-On AdminUI

15. CA Single Sign-On Web Agent/Option Pack

16. CA Single Sign-On Secure Proxy Server

17. CABI 3.3

 

Some trivial steps are skipped such as installing the OS and promoting to a Domain Controller.

 

17. CABI 3.3

 

I have downloaded "DVD02155537E_CA Business Intelligence r3.3 for Windows DVD.iso"

 

"CA Business Intelligence Setup" is just a wrapper for the actual report server installer.

The options that you chose before this is what need to be run after the actual report server is complete.

You actually have an option here whether to "Install SQL Anywhere Database Server" or "Use an existing database server".

In case if you choose "Use an existing database server", it will limit what database server your SiteMinder Audit DB can be or vice versa.

If you choose existing SQL server then your SiteMinder AuditDB must be the SQL server.

If you choose existing Oracle DB then your SiteMinder AuditDB must be Oracle DB as well.

If you choose "Install SQL Anywhere Database Server" then the SiteMinder AuditDB can be either SQL or Oracle.

Don't touch the CMS port, leave it as 6400. This port must be opened from your firewall.

Administrator password only supports alphanumeric so you cannot use special characters.

 

Leave the Port as is. This port must be opened from your firewall.

Leave the settings as is, only enter the desired password for the administrator accounts.

Here again you have an option whether to install an application server(tomcat) for report server or use existing one.

I will let it install a tomcat instance.

 

It also gives you option to configure an IIS server.

What it does is to configure a proxy on the IIS to forward the request to its tomcat but we already have proxy module for NewAtlanta ServletExec so we don't want to make it more complicated by installing another proxy module.

So, I have unchecked the "IIS Web Application Server" option.

The default port it suggests are 8080, 8005 and 8443 but I will use different port.

Run netstat to check which ports are already occupied and use the next available one.

I am going to use 38080, 38005 and 38443. <== 38080 and 38443 ports need to be opened from firewall.

Installation is complete! That was easy!

 

Once you click "Finish" the handle goes back to the previous installer and will continue to perform some additional tasks.

Don't restart yet.

Try to logon to the CMC as Administrator with the password you entered during installation.

This is sufficient to confirm the Report Server is working.

 

At the dropdown menu showing "CMC Home", select "Servers".

Locate "<ServerName>.InputFileRepository" service and check its service port.

You can see the PID is "7872"

 

Download "Process Explorer" and install and run.

Right click on the PID "7872" and select "Properties" then select "TCI/IP" tab.

You can see that this service is listening on TCP Port "54736".

You should set this to a static port in the service configuration and have this port open in the firewall.

If you do not open this port, you will get errors while trying to access the generated reports.

 

 

You must do the same for the "<Server Name>.OutputFileRepository" service as well.

 

You can see the PID is "6688"

Right click on the PID and select Properties and select "TCP/IP".

 

It is listening on Port "54726".

You should set this to a static port in the service configuration and have this port open in the firewall.

If you do not open this port, you will get errors while trying to access the generated reports.

 

So, now we have a list of ports to open at the Report Server side.

6400, 6410, 38080, 38443, 54736 and 54726

 

Load "Windows Firewall with Advanced Security" and select "Inbound Rules" and click "New Rule"

Select "Port" and click "Next"

 

 

Next will be integrating SiteMinder and Report server.

 

This concludes Part 10-1 of ALL IN ONE Image.

Outcomes