ITpipes Web Installation Instructions

ITpipes Web Installation Instructions

Note: These instructions are for installing ITpipes Web on a new machine. For more information on how to update, proceed here.

Installation Prerequisites/Requirements 

  1. A web server running a 64-bit edition of Windows Server 2012 or newer with IIS Features and management tools installed from the images below.

  2. SQL Server version 2012 or newer.

    1. Note: ITpipes does not set up a client's local SQL Server as a policy. If cloud-hosted, then the server/database is set up and maintained by ITpipes.

  3. Media storage server with a shared directory to store files. This can be the same server as above.

  4. SQL Server Management Studio and a SQL Server account with dbcreator permission. [Note: Only needed during DB Creation, This user can just be the owner of the ITPipes database after installation is complete]

  5. If using a domain:

    1. Windows domain account (AD - Active Directory account). ITpipes recommends disabling the Password Expiration.

    2. ITPipes uses this account to access the ITPipes Web Application location and the virtual directory media location

  6. Google Chrome, Mozilla Firefox, Safari, Microsoft Edge, or Opera.

  7. A copy of all templates (.tpl) used in ITpipes Web, Desktop, and Mobile. [Note: Please Contact ITPipes if missing these files as we should have the latest ones on file]

  8. As of 6/21/2022 any new installation of ITpipes Web no longer needs this requirement.

    1. Java Runtime Environment 1.8 + for the license server. Must be matched to OS bit type (installed with the installer).

  9. Please verify that the port 7070 is accepted from IP Address 54.148.108.248 to be allowed to go to the server that ITpipes Web is located on; this is a requirement for Flexera licensing as of 05/2022.

  10. Access Database Engine 2016 (installed with the installer).


 



FYI: ITpipes does not need a dedicated server and often is installed on a server shared with ESRI GIS and/or an asset management application.

Other Notes:
- This setup will support 'Always On High Availability' for the SQL server 
- the dbcreator that ITPipes will use to access the database should not create or need any additional users, linked databases, jobs etc
- New users in the web platform are managed by ITPipes in the ITPipesUser database
- The ITPipesUser database can be placed on any existing SQL server that is 2012 or newer
- DB Growth Settings:
ITpipes uses a minimalist attitude when it comes to the database. The database only contains the data itself and references to media files, so tends to stay fairly small. Small enough that we haven’t found a need to track DB growth settings.

Installation Process

Make sure all required features and roles are installed. The installation will fail unless everything is installed.

Installation

ITpipes Web Installer Process

  1. Download and run the latest ITpipes Web installer. [Note: This installer should handle the JRE and Access DB Engine needed for Web functionality]

  2. Select .

  3. Accept the license agreement and select .

  4. Input the SQL Server credentials.

    1. Input the server name or select to browse for available SQL servers.

    2. Input the username and password.

    3. The name of the database defaults to “ITpipesUser.”

  5. Select .

  6. Select the desired method of installation and set to install Flexnet Server.

  7. Default installation:

    1. Select .

    2. Select .

  8. Custom installation:

    1. Input the Desired Site Name and port number.

    2. Set the install location to the desired location. [This can be any drive on the web server]

    3. Select .

  9. Select .

Adding a virtual directory

It is not needed if using Amazon S3 for storage.
  1. IIS (Internet Information Services) Manager. 

  2. Right-click on “ITpipes Web.”

  3. Select “Add Virtual Directory.” 

  4. Input the name of the virtual directory into the alias. ITpipes recommends using “itpipesmedia.” If another is desired, input the desired name. (This name will be used later during the project setup.)

  5. Input the UNC path to the shared media location under “Physical path:”

  6. If a Domain is being used:

    1. Select “Connect As” 

    2. Select the ellipses next to “Specific user:”

    3. Select “Set.”

    4. Input a domain user account name and password. [Note: This user needs read write and modify permissions to the media location]

      1. A static user is preferred whose password does not change.

    5. Test the connection to verify access is available and save the virtual directory.

Configuring ITpipes Web

ITpipes Web Server Configuration

Using a compatible browser, browse to the ITpipes Web site

  1. Select .

  2. Input the Server name for the SQL server.

  3. By default, the database is named “itpipesuser.”

  4. Input user name and password for the SQL server

  5. Select to test the connection of ITpipes Web to the user database. Note: This might take two tries.

  6. Select .



Setting up the License


  1. Input http://127.0.0.1:7070/ under “Server” in the “License Server” category.

  2. Select. http://127.0.0.1:7070

  3. Input the license number into “Activation ID.” http://127.0.0.1:7070/

  4. Select “Activate.”

  5. Select “Refresh” to make sure that the license was activated.


ITpipes Database Creation


  1. To create a project, select .
  2. A new window will pop-up allowing the input of the project information.
  3. Input the Alias (the project will be named this alias name inside ITpipes Web).
  4. Input the Server, Database, Username, and Password.
  5. Select the desired template to be used from the dropdown next to Template. [Note: These templates will be located by default at C:/ITPipesWeb/Inetpub/Content/Templates on the Web server]
  6. Input the Drive Letter, Folder Path, UNC Path, and/or Virtual Path. For an explanation of media pathing, proceed here.
  7. If using S3 hosted, add the Bucket, Key, Secret, and Region the s3 bucket is located in.
  8. Select the users that will have access to the project. [Note: These are the web users aka the users in the ITPipesUser db, if this is an initial setup only 'SetupAdmin' will be available]
  9. Select to create the project. [Note: This will create a new SQL database in the SQL Server]
    1. Necessary! make sure that SetupAdmin is “Available” is selected in the User Rights.

Note: One or multiple projects can be created this way during implementation or in the future depending on the needs of users

Troubleshooting

If the “License Server Not Found” error comes up, ensure there are no spaces where the license server was input.

  1. Check the flexnetls.settings

    1. Open the file flexnetls. settings using notepad. The file is located in “C:\inetpub\ITpipes Web\FlexeraServer” by default.

    2. Check the Java version and make sure the path matches what is installed. If it doesn’t match, modify the settings file to match the correct location. Uninstall and re-install the Flexera server by using the following in a command prompt window with Administrative permissions:

      1. cd C:\inetpub\ITpipes Web\FlexeraServer\

      2. flexnetls.bat -uninstall

      3. flexnetls.bat -install

      4. flexnetls.bat -start


    • Related Articles

    • ITpipes Sync Install, Update, Setup

      What is ITpipes Sync and ITpipes Host ITpipes Sync ITpipes Sync is a desktop application that is designed to schedule and automate the transfer of data from one ITpipes project/database to another ITpipes project/database. Examples of this would ...
    • ITpipes Sync - Client Install

      ITpipes Sync Client Install & Setup Prerequisites Note: Sync modules communicate using port 8101 TCP protocols. This port will need to be opened in the Firewall for proper communication. (ITpipes Host) Server-side: Microsoft SQL Server 2012 or higher ...
    • ITpipes Host - Client Install

      ITpipes Host Client Install Prerequisites ITpipes Master SQL Server database has been created. Required information including client-specific details that the client typically sets up and maintains. ITpipes may have a record of this information, but ...
    • ITpipes Education - User's Manual, Quickguides, Training Videos

      Users Manual Here is a link to ITpipes Users Manuals: ITpipes Web ITpipes Mobile ITpipes Sync Quickguides ITpipes Mobile ITpipes Sync Training Videos Links to available training videos.  Best when viewed full screen.   ITpipes Web  Creating a WO - ...
    • ITpipes Desktop Education - Users Manuals, Training Videos, Quickguides

      ITpipes Desktop/Legacy Product Users Manuals ITpipes Desktop - Mobile ITpipes Desktop - Office Box links for users that can not use Google Drive: https://itpipes.box.com/shared/static/w3t4s1a91y5p5bnf5exi.zip ...