via the Yetral OpenIAM "Secure System Admin" web browser interface we can access the system across a network.
In this example at https://192.168.0.102:10000
https://192.168.0.102:10000/mysql/index.cgi
Create a Database Schema
Click on the create database
- Provide a name for the new schema, such as openiam, you can leave other options unchanged (default)
You will notice new database icon name openiam appear on the web page. You can double click on this and you will
activate the "Edit Database" option. NOTE at this time there is no tables defined.
Here we click on "Execute SQL" -> "Run SQL from file"
select and execute"
1) mysql_schema_common.sql
2) mysql_schema_security.sql
and
3) mysql_idm_data.sql
using "From local file" under path
/root/OpenIAM/schema
Create a Database User
The identity repository will need a user account that can be used by the IAM application to connect to the repository. To create a user, follow the steps below.
In your web browser go to the MySQL virtual appliance home https://192.168.0.102:10000/mysql/ under "Global Options"
Select the icon "User Permissions" then "Create new user"
For example:
- for "Username" add "idmuser"
- "Password" set to... "idmuser"
With "Permissions"
Select, Insert, Update, Delete and Execute
Then press the "Create" button