Register Login





|

Top Links: >> 80. Technology >> AI-Consulting
Current Topic: IIQ Training
Sub-Topics: IIQ - MySQL Install
-- Scroll to check for more content below...
You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
IIQ Training

Identity IQ is one of the product lines of Sail Point.

The product allows to precisely map user privileges to application services.

The product is a Web application, which uses MySQL (or any other) database to store user data (usually employee group, title, etc.) and the names of applications and related services.

Usually the application is projected on the web with the Tomcat application server.

As a Java-based application it can run on any OS-platform that supports Java.
Identity IQ is usually connected with multiple data sources, including LDAP (Active Directory) via ready-to-go Connectors or through the custom integration.

The image below represents the Identity IQ application with its major components.



The Team Training Location @ AWS is: http://itserve.com/identityiq

Here are the instructions to install the application on a Windows-based laptop.

The main steps and components of the installation.

Download and Install Java JDK, Tomcat 8 Web Application Server, Download and Install MySQL
Database, SQL Server or Oracle DB, or any SQL DB you require

To install Tomcat 8.5 at AWS EC2 - use the following command
$sudo yum install tomcat8

See more details in the 5.2 Cloud Technology section

Recommended destinations for the components installed on a local Windows host: (Change the default directory during the install)

Java JDK: - c:\jdk
Tomcat 8.5: - c:\tomcat8 - keep default config files with the port 8080
MySQL: - c:\tools\mysql - keep default port 3306, username=root and password=root
OpenLDAP: - c:\tools\openldap
IdentityIQ: - c:\tomcat8\webapps

1. If you do not have an OS, or virtual machine instance, install the operating system either Windows or Linux and have the Administrator or root password handy
2. Install Java JDK 1.8 or greater from Oracle Website
3. Make sure the Java JDK directory is part of the Windows environment variable
4. Steps to download and 1install Tomcat are available here: https://tomcat.apache.org/download-80.cgi
5. Install Apache Webserver and kick off the service
6. Next Install your database. MySQL community edition works great, for a Sandbox environment and it can be downloaded and installed from www.mysql.com , store your password [MYSQL-PASSWORD]
7. Also add the path of MySQL installation directory to the $PATH$ environment variable, C:\Program Files\MySQL\MySQL Server 5.6\bin

Steps to Install SailPoint Identity IQ

1. Create the installation directory called [iiq_installation]
Was it clear so far? Highlight the text in question Or

2. Download identityiq.zip to the folder [iiq_installation]\identityiq.zip
3. Unzip the file identityiq.zip to the directory [iiq_installation]
4. Create the staging directory called [identityiq]
5. Unpack identityiq.war to the staging directory by running the following commands
6. Change directory to cd [identityiq] folder
7. Run the ff command: jar -xvf ../iiq_installation/identityiq.war
Setup the SailPoint IIQ SQL database, extending the default class table column fields for identity cube, applications, classes etc.
1. Setup and source the database schema
2. Optional: to change the identity cube fields and columns you have to edit the files IdentityExtended.hbm.xml, which is located: identityiq\WEB-INF\classes\sailpoint\object\
3. Here is an example of 2 fields that we have added to the identity cube:
4.
5.
6. You also have to add the ObjectConfig , see this link for more:
Tomcat install instructions: https://www.ntu.edu.sg/home/ehchua/programming/howto/Tomcat_HowTo.html

7. After adding the changed fields, we must update the database schema as follows
8. Change the directory as follows: cd [identityiq]\WEB-INF\bin
9. Print the database schema: to print the database schema, you should run ./iiq schema
10. The database schema DDL script files will be located: [identityiq]\WEB-INF\database
11. The name of the script to create and write the DB tables schema will be:
create_identityiq_tables-x.y.mysql (for defaults), or create_identityiq_tables.mysql (if you changed any of the hibernate .hbm files) . Note that the type of the database will vary based on your target DB. In our case the target DB is mysql. For example, if we were using Microsoft SQL server, the script will be create_identityiq_tables.sqlserver
12. Also you may want to change the db user identityiq password to something different. To encrypt it run ./iiq encrypt [newpassword] and you can update iiq.properties, and put the encrypted password in datasource.password. Also you will have to update the GRANT ALL ? statements in the beginning of create_identityiq_tables.mysql

13. Change directory to: cd [identityiq]\WEB-INF\database
14. Database creation, get the MySQL ROOT userId and the password
15. MySQL login credentials: root / [MYSQL-PASSWORD]
16. Login to mysql -u root -p
17. source create_identityiq_tables.mysql
18. Creates the database and the internal tables
Setup the IIQ Web Application to Connect to Our SQL Database using IIQ.properties file
1. Open up the application iiq.properties file which is located here [identityiq]\WEBINF\classes\iiq.properties
2. Access the iiq.properties file and update the following information:?
3. User ID: identityiq
4. Password: put the encrypted password
5. Change the directory as follows: cd [identityiq]\WEB-INF\bin
4. Run ./iiq console
5. import init.xml (imports core iiq objects to DB)
6. import init-lcm.xml (imp Life cycle manager)

7. import sp.init-custom.xml (if this is needed)
8. Copy the staging directory to the Tomcat application server
9. Copy the [identityiq] folder to webapps\[identityiq] folder
10. Start Tomcat
11. Open up your browser to: http://localhost:8080/identityiq/login.jsf


Steps to Install Open LDAP - Optional
1. Follow the instructions on this website to install open ldap and populate with user objects
2. http://docs.adaptivecomputing.com/viewpoint/hpc/Content/topics/1setup/installSetup/settingUpOpenLDAPOnCentos6.htm
3. https://directory.apache.org/studio/usersguide/Apache_Directory_Studio_LDAP_Browser_User_Guide.pdf

We invite you to create your own questions and answers (QnA) to increase your rank and win the Top Creativity Prize!

| Check Your Progress | Propose QnA | Have a question or comments for open discussion?

Have a suggestion? - shoot an email
Looking for something special? - Talk to AI
Read: IT of the future: AI and Semantic Cloud Architecture | Fixing Education
Do you want to move from theory to practice and become a magician? Learn and work with us at Internet Technology University (ITU) - JavaSchool.com.

Technology that we offer and How this works: English | Spanish | Russian | French

Internet Technology University | JavaSchool.com | Copyrights © Since 1997 | All Rights Reserved
Patents: US10956676, US7032006, US7774751, US7966093, US8051026, US8863234
Including conversational semantic decision support systems (CSDS) and bringing us closer to The message from 2040
Privacy Policy