Managing the Database Connection and Security
Related Topics Overview
For CCLAS EL applications to run on a client computer, a connection to the CCLAS EL database and CCLAS EL security must be established. Connection and security applications manage this, and reside either on the client computer or on a remote server.
Controlling the Connection and Security
The Pool Control and Security Manager that maintain connection to the CCLAS EL database and security are managed by the CPOOL01.exe and CCSECM01.exe applications, respectively.
When a data set change is requested, the Pool Control application (PoolControl.exe) stops the database connection, and updates the appsettings.json file for V3 and the CCLAS.INI file for V2 to point to the required CCLAS EL database, so that, when a CCLAS EL application is launched again, the appropriate database connection and security is established.
The Pool Control and Security Manager applications are launched manually where it is desirable to bypass the usual login screen to directly launch CCLAS EL applications from shortcuts or the command line.
Process
Pool Control
The CCLAS EL database connection, to connect CCLAS EL database requests with the database, is managed by the Pool Control application (CCPOOL01.EXE) as a background process.
When a CCLAS EL application is launched, if the Pool Control is not running, then it is started automatically.
The system tray displays the Pool Control icon 
when the Pool Control application is running.
View current connection details
Note: In CCLAS EL V3, the Pool Control can be accessed during login via the cclasellogon > CCLAS EL login Form or from the application tool bar to change your CCLAS EL database.
Refer to Logging In To a Laboratory and Changing the Database Connection.
Manually close the Pool Control process
Manually run the Pool Control application
Note that the current connection can be managed from the V3 cclasellogon > CCLAS EL login Form form and from the application toolbar once a V3 application is launched.
Security Manager
CCLAS EL security, to run CCLAS EL applications in a secured environment, is managed by the Security Manager application (CCSECM01.EXE) as a background process.
When a CCLAS EL application is launched, if the Security Manager is not running, then the CCLAS Login screen displays, and after a successful logon, the the Security Manager application is started automatically.
The system tray displays the Security Manager icon 
when the Security Manager application is running.
View the Security Manager process
Manually close the Security Manager process
Managing these Processes via the User Interface
Where the cclasellogon > CCLAS EL login Form is displayed for you to log into CCLAS EL V3, then you can view the terms and conditions of using the CCLAS EL application, or access the Pool Control application to stop the current database connection or set another CCLAS EL database defined in the appsettings.json file as the preferred database. Refer to Logging In To a Laboratory.
After login, you can also stop or set a different database as the preferred database from the V3 application main menu. Refer to Changing the Database Connection.
Any change to a different database automatically updates your appsettings.json file for V3 and CCLAS.INI for V2. Where a connection exists in the appsettings.json file but not in the CCLAS.INI, then an error is raised: Section '<connection>' not found in configuration. Typically these initialisation files should be configured to contain the same available database connections. Refer to Configuring the Language and Database Connection for V3 and Managing the Database Connection and Security.
