Excerpt | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Setup Config XML Files (For Synergetic Community Portal/SynWeb Newer than v68)Common Configuration:
When setting up SAML authentication for Community Portal or SynWeb you currently have to set in the configuration XML as following. First we have to enable SAML mode for the application.
|
|
zSynWeb user will require the role of "Synergetic_main_dbo_ReservedDBRole"
Login Properties
Logout Properties
|
Performance Properties
The following are advanced settings and should not be adjusted unless fully aware of the implications. The settings affect memory usage, the number of concurrent queries and therefore overall performance of SynWeb and Community Portal. Using connection pooling is best practice from Microsoft, allows shared use of SQL server connections and reduces overheads required to establish and remove connections to the SQL Server for every query.
Defaults/recommendations for a standard size environment are as follows:
- Database Pool Enabled Flag
- Utilises a pool of reusable SQL Server connections rather than having overheads of creating a new connection for every query performed and closing off the connection.
- Recommended Setting: true
- Database Pool Size Max
- The maximum number of connections allowed in the pool for concurrent SQL queries. The default setting of 100 should be ample for a standard healthy environment however if queries are slower running due to SQL Server or query performance issues, then pool size may need to be increased to allow for more queries however the SQL Server could become a bottleneck. Inefficient queries and SQL Server health issues should be investigated if the pool size if seen as insufficient.
- Default Setting: 100
- Database Pool Size Min
- When the web application starts, this number of connections will be established to SQL Server from the outset so they are ready to use from when the first set of SQL queries are processed.
- Recommended Setting: 20
- Multi Subnet Fallover Enabled Flag
- Significantly improves initial connection performance when SQL Server Availability Group is used across two IP subnets
- true if SQL Availability Group used with multi-subnet failover, false if no SQL Availability group is used or all of the SQL AG nodes are in the same subnet.
Reference documents:
Database Connection Pooling:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling
https://www.progress.com/tutorials/net/net-connection-pooling
Multi-subnet Failover:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recoverySetup Configuration Keys
There are 2 configuration keys to visually display how the logout page is displayed when a logout is successful:
Info | ||
---|---|---|
| ||
SynWeb|System|LogoutCustomHtml |
Default logout message for SynWeb.
Info | ||
---|---|---|
| ||
CommunityPortal|Pages|LogOut|LogoutCustomHtml |
Default logout message for Community Portal
The configuration key supports HTML format.