Administration
This page is for PhixFlow administrators. It summarises the configuration and monitoring tasks you need to do, with links to more details.
Minimum Set-up After Installation
If you have installed PhixFlow for the first time, you need to do the minimum set-up so that you can start creating applications.
- Login as the startup user.
Add your licence key
Create a user with Administrator privileges.
- Check your new user account works.
- Logout
- Login using your new user account
- Once your account works, delete the startup user.
- Set up the essential file locations in Administration→ System → Configuration
System Directories: Restricted Directory: this is optional, but is an important security setting. Leaving it empty effectively allows users to scan the server file system with File Collectors. Although it only allows users to see files that Tomcat has permission to access, this can include files which most users should not be able to see. Typically this is set to the root of the file system you set up for PhixFlow data files. E.g. /opt/phixflow/data.
When you set a Restricted Directory, all other system directories, except the Database Driver File Directory, must be sub-directories of the restricted directory.
Example:
update system_configuration set restricted_dir = '/opt/phixflow/data'; commit;
Temporary File Location: e.g. /opt/phixflow/data/temp – needed for exporting and importing applications and models between PhixFlow instances.
- File Upload Directory: e.g. /opt/phixflow/data/upload – needed for uploaded files ( via file collectors)
- Download Location: required to export data; see Configuring the Download Area.
Full System Configuration
For a full system with multiple users, you need to configure:
- Connections to external data sources, e.g. databases; see Database Driver.
- All the system directories and other System Configuration options; see System Configuration and System Logging Configuration.
- Data formats; see Configuring Data Formats.
- Users and privileges, either in PhixFlow or by integrating with external login systems; see User Administration.
- For integration with other authentication systems, see:
- Configure Active Directory Integration: users are authenticated using one or more Active Directory servers in addition to users that are defined locally within the PhixFlow database.
- Configure AAD Integration via SAML: map the PhixFlow user groups to user groups in your existing single-sign-on system.
- For how to prevent users accessing PhixFlow during system maintenance or upgrades, see Restricting Access During System Maintenance
- For integration with other authentication systems, see:
We recommend that you:
- Install new Theme palettes, which are provided by PhixFlow as packages; see Installing Template Packages.
You can optionally configure:
- Localisation; see Configuring System Localisation and also Localising Applications
- Home screen messages to display on user login: see Configuring a Login Message
- PhixFlow for mobile access; see PhixFlow Security Design Features
Monitoring and Maintenance
To monitor and maintain PhixFlow, you need to:
Set up scheduled maintenance using task plans that include system and archive tasks; see Using Tasks and Task Plans
Use task plans to schedule tasks that maintain the PhixFlow system. The system task includes processes that clear the data from incomplete recordsets.
If incomplete recordsets accumulate, this can slow down PhixFlow's performance. Depending on your PhixFlow database, queries that have to exempt many incomplete recordsets can reach system limits. This can prevent PhixFlow and its applications from running. Therefore, we recommend that you add a system task to a task plan that is scheduled to run daily or weekly.
- Configure a stand-by webapp to shadow the active webapp. The standby webapp will automatically take over in the event that the active server fails. See Configuring for Resilience.
- Monitor PhixFlow processes, tasks and user activity; see System Monitoring and System Console.
- Prepare server machines for installing or upgrading to a new version of PhixFlow; see the Installation and Upgrade pages:
If you have several PhixFlow instances, for example a development instance and production instance, you may also need to move packages, applications, models and tables between PhixFlow instances; see Administration Menu and Moving Items and Data Between Instances.
Other useful information is available in:
PhixFlow Database Considerations
When users or automated process change the data in the PhixFlow client, the data changes are automatically published to the PhixFlow database.
To ensure that PhixFlow can publish data changes, its database must have enough space to hold a copy of the largest table. For the different databases, the space needs to be in:
- Oracle: temporary table space
- SQL Server: temporary file group
- MySQL: the file system.
Learn More
Pages in the Administration Topic
Pages in the User Administration Topic
- Managing User Accounts
- Managing User Groups and Privileges
- Configure Groups for External Login
- Configure Active Directory Integration
- Configure Login Forms
- Configure AAD Integration via SAML
- User Notification Rule
- Email Account
- Restricting Access During System Maintenance
- Understanding Password Encryption
- Setting up OAUTH2 Email Integration