Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

Purpose

When installing iQSonar 2.14.x on Windows 2012 the install will complete but report that IIS was not found on the system and was not configured even when IIS is installed properly..

 

Pre-requisites:

 

IQSonar installed. IIS Role installed and configured with features enabled per documentation. The following features must be enabled in IIS (from IQSonar Scan Prerequisites): 

 

  • ASP.NET
  • .NET Extensibility
  • ASP
  • ASAPI Extensions
  • ISAPI Filters
  • Server-Side Includes
  • Default Document
  •  directory Browsing
  •  HTTP Errors
  •  HTTP Redirection
  •  Static Content
  •  Request Filtering
  •  WindowsAuthentication

Tip – add the IIS Role and .NET runtime before running any Windows updates for easy install.   For issues installing .NET see Installing DotNet 3 on Windows 8 /Server 2012

Step 1 - Create the iQSonar Application Pool

Add an iQSonar Pool with the following settings:

  1. Name = IQSonar
  2. Net CLR Version =  v2.0.50727
  3. Managed Pipeline mode = Classic
  4. Check the: Start Pool Immediately and click OK
  5. Highlight the  IQSonar Application pool and select Advance settings from the menu on the right and set Enable 32-bit-applications
    to True.

    

Step 2 – Add the iQSonar Application to the Default Web Site

  1. Create a new application by right clicking on the Default Website and select 'Add Application'
  2. Alias = iQSonar
  3. Application Pool = iQSonar
  4. Physical Path = C:\Program Files (x86)\iQuate\iQSonar\Sonar
  5. Click on OK to complete the application additon.
  6. Exapand the IQSonar folder then right Click on the API subfolder and select "Convert to Application" - the application pool should be iQSonar - click on OK.






Step 3 : Edit Web.config to add the database location and credentials and the handler mappings

  • Edit C:\Program Files (x86)\iQuate\iQSonar\Sonar\web.config  
  • Modify  connectionString with details in clear text:

{code:xml}
      <connectionStrings>
        <add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS_DB;uid=USER;pwd=PASSWORD;" />
      </connectionStrings>
{code}

 

Add the following lines near the bottom of the file (between </iquate.dal> and </configuration>)

 
  </iquate.dal>
    <system.webServer>
        <handlers>
            <add name="SHT" path="*.sht" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="RPT" path="*.rpt" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="XML" path="*.xml" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="PNG" path="*.png" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="JS" path="*.js" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="CSS" path="*.css" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
        </handlers>
    </system.webServer>
</configuration>

Sample Web.config file (Click to download)
Re-encrypt Web.config:
  1. Open Command Prompt as Administrator
  2. cd to .NET Framework directory - %windir%\Microsoft.NET\Framework\v2.0.50727\
  3. Run aspnet_regiis -pe "connectionStrings" -app "/iQSonar"

 
 

Step 4 - Change permissions 

Change permissions C:\Program Files (x86)\iQuate\iQSonar\Sonar to allow cache files to be created correctly.
Add the IIS_IUSRS local group to the Sonar Directory.
 

  1. Right Click on the folder and click properties


  2.  Check security tab


  3. Press Edit


  4. Press Add


  5. Make sure the Location has the hostname of the VM and type the group


  6. Press ok and Make sure you give the group Full control

 

iQuate support has automated the above process and created a package that will allow you complete above steps in an automated fashion.

Purpose

=======

During the install iQSonar may not recognize that IIS is installed and will not configure the web based front end automatically.

This script will perform the following actions:

  - setup the iQSonar Application Pool in IIS

  - Add the iQSonar Web Application to IIS

  - set permissions on the Sonar folder to allow IIS to manage the cache files in the web application

  - set the File Handler mappings for IIS in the web.config file

  - setup the connection to the iQSonar CMS Database in the web.config file

  - encrypt the web.config file to obfuscate the credentials needed to access the iQSonar CMS Database.

 

A KB Article is also available detailing how to perform these steps manually.

 

Instructions

============

Extract the web.txt file and the fixiis.bat file into C:\Program Files(x86)\iQuate

 

NOTE:  If your iQSonar installation is not in the default c:\Program Files(x86) modify the fixiis.bat file to reflect the proper drive and folder structure.

 

Edit Web.txt to add the location of your iQSonar CMS Database as configured during installation.

    Modify  the following line with details in clear text with the information for your environment:

 

 <connectionStrings>

     <add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS_DB;uid=USER;pwd=PASSWORD;" />

 </connectionStrings>

 

Run fixiis.bat - you will be prompted to update the permissions, IIS and to encrypt the file.  Answer yes on each step to properly create the iQSonar web application.

 

After the file has run you can now open the iQSonar web application in Internet Explorer by going to http:\\localhost\iQSonar from the iQSonar server.


 

win2012iis.rar

  • Page:

V4 installation error message: missing table - t_Artifact missing error

  • Page:

Insert IP Ranges into iQSonar Database directly.

  • Page:

V3 Applications that are not mapped to a device

  • Page:

V3 How to Create a Derived Software Rule using process information.

  • Page:

V3 Install iQSonar 2.14.x on Windows 2012

  • No labels