Security information storage

The SuperMap GIS server defaults to store the user information in the SQLite database. And storing to MySQL/Oracle databases, as well as other custom storage locations are also supported.

Administrator can set the storage location for the security information on the Security Configuration page. Specifically, the administrators can:

• Use SQLite database storage

SuperMap GIS servers defaults to store the security information and service information in the SQLite database. Take iServer as an example, the storage path is [SuperMap iServer installation directory] \webapps\iserver\WEB-INF, and the storage files are iserver-security.db and iserver-services.db.

You can modify the location and name of the SQLite database as needed. For example: Change the security information storage location to ./WEB-INF/iserver-security2016, after clicking the "switch" button, iServer will automatically copy the administrator information (the administrator account created when starting iServer the first time) to [SuperMap iServer installation directory] \webapps\iserver\WEB-INF\ iserver-security2016.db, which will be also used to store the new security information.

• Use MySQL database storage

Set the configuration items as below. If you have not yet got an available MySQL service, install and configure it first. Please refer to the specific method: MySQL installation and configuration.

• Storage type: MySQL.
• Service address: {ip}: {port}/{database}. {ip} is the IP address of the machine where MySQL locates. {port} is the service port of MySQL, the default is 3306. {database} is the database name, which can be set as the database you have created to store the user information. These parameters can be configured according to the actual situation of MySQL you installed.
• Username: User who has the right to access the database {database}
• Password: The user's password
• Use the MySQL administrator: For the case where the initial administrator (for example, admin1) has been stored in the database, there are two options: Not checked by default, which means that the initial administrator (admin2) of the current iServer will be used and will overwrite the one in the database (the administrator stored in the database will be rewritten as admin2); if checked, the initialized administrator (admin1) already stored in the database will be used instead of the current iServer administrator (admin2).
• Use Oracle database storage

Set the configuration items as below. If you have not yet got an available Oracle service, install and configure it first.  Please refer to the specific method: Oracle installation and configuration.

• Storage type: Oracle.
• Service address: {ip}: {port}/{database}. {ip} is the IP address of the machine where Oracle locates. {port} is the service port of Oracle, the default is 1521. {database} is the database name, which set to the database instance name when you installed the Oracle, and the default value is orcl. These parameters can be configured according to the actual situation of Oracle you installed.
• Username: The user who is assigned the table space and has the right to access the database {database}
• Password: The user's password
• Use the Oracle administrator: For the case where the initial administrator (for example, admin1) has been stored in the database, there are two options: Not checked by default, which means that the initial administrator (admin2) of the current iServer will be used and will overwrite the one in the database (the administrator stored in the database will be rewritten as admin2); if checked, the initialized administrator (admin1) already stored in the database will be used instead of the current iServer administrator (admin2).

• Use PostgreSQL database storage

Set the configuration items as below. If you have not yet got an available PostgreSQL service, install and configure it first.  Please refer to the specific method: PostgreSQL installation and configuration.

• Storage type: PostgreSQL.
• Service address: {ip}: {port}/{database}. {ip} is the IP address of the machine where PostgreSQL locates. {port} is the service port of PostgreSQL, the default is 5432. {database} is the name of the database you created to store the user information.. These parameters can be configured according to the actual situation of PostgreSQL you installed.
• Username: The user who has the right to access the database {database}
• Password: The user's password
• Use the PostgreSQL administrator: For the case where the initial administrator (for example, admin1) has been stored in the database, there are two options: Not checked by default, which means that the initial administrator (admin2) of the current iServer will be used and will overwrite the one in the database (the administrator stored in the database will be rewritten as admin2); if checked, the initialized administrator (admin1) already stored in the database will be used instead of the current iServer administrator (admin2).

After configure the type of database type you've chosen, click the "switch" button, the administrator information (the administrator account created when starting iServer the first time) will be automatically copied to the configured database and the following security information will be also stored with the new configured database.

In addition, if you want to switch back to the local SQLite database, directly select the storage type as  the "SQLite" database.

If the above storage methods can not meet the demand, you can customize the storage way of user information based on the SecurityInfoStorage interface. For more information about the extension method, please refer to: The storage method for the extended user information.