2.0.2 Operational Guide

This manual introduces the essential steps for operating Quilliup after installation.

1. License key

Copy the quilliupLicense.xml file to the "C:\Users\..." under the user's folder that runs quilliup service.

2. Command line execution

Verify that the file run_qp.exe (Windows) or run_qp.sh (Linux) exists.

Ensure the user running Quilliup has execution permissions for:  "..\quilliup\webapps\ROOT\utils".

If run_qp.exe / run_qp.sh is used on remote servers, replace them with the latest version provided.

3. Tomcat Service (Windows Users Only)

During Quilliup installation, Apache Tomcat is installed as a Windows service.
The service name will typically follow this format: Apache Tomcat {version} quilliup.

If you modify any Quilliup default configuration:

1. Stop the service before making changes.

2. Restart the service after completing changes.

Destination folder: ...\quilliup\bin

1. Stop quilliup service from Task Manager or by running the "..\quilliup\bin\shutdown.bat" file.

2. Start quilliup service from Services or by running "..\quilliup\bin\startup.bat" file.

3. If the service becomes unresponsive, restart it from Windows Services, locating it under Apache Tomcat {version} quilliup on the services list.

 

4. Secure Browsing (HTTPS)

Working in HTTPS mode is recommended for security, though optional.

• By default, Quilliup runs in HTTP mode on port 8080.

• It can be switched to HTTPS using ports 8443, 443, or another available port.

⚠️ Do not change the port/mode until a valid SSL certificate is created for the Quilliup site. Without it, users will see “untrusted site” warnings.

Linux setup: Set up an HTTPS Linux

Windows setup: Set up an HTTPS windows

5. Qlikview configurations

1. Ensure that the QlikView server is accessible from the Quilliup server.

   • Authentication with username and password may be required.

2. Open: ..\quilliup\webapps\ROOT\WEB-INF\classes\config.properties

3. Verify the following configurations:

   qvw.location=..\quilliup\webapps\ROOT\WEB-INF\lib\qvw\QVW.exe qvw.meta.month.old=2

Related manual for QlikView Data Source configuration: QlikView Data Sources 

6. Restarting Quilliup Service

• Windows: Apache Tomcat 9 Quilliup

• Linux: Apache Tomcat

1. Stop quilliup service from Task Manager or by running the "..\quilliup\bin\shutdown.bat" file.

2. Start quilliup service from Services or by running "..\quilliup\bin\startup.bat" file.

7. Repository Properties Configuration

For versions up to 2.6.1.9.1 (inclusive):

• Open:

   

  ../tomcat/webapps/ROOT/WEB-INF/classes/spring/datajpa-config.xml

• Edit repository details:

  • Choose repository type under jpaVendorAdapter by removing the comment (<!-- -->).

• Define user, password, DB, and server details under the dataSource bean. Save changes.

For version 2.6.1.9.2 and later:

• Open:

   

  ..\quilliup\webapps\ROOT\WEB-INF\classes\connection.properties

• Uncomment relevant DB details (remove #).

• Comment out all irrelevant details.

Note: it's Preferable to encrypt your DB password. If you choose to encrypt your password, please make sure you have a copy of your password in your passwords manager.

• Run: java -jar '...\quilliup\webapps\ROOT\utils\quilliup Encrypt AES.jar'

• Encrypt your password.

• Copy the value from the “Result” field into the connection.properties file.

• Save changes.

• Store a copy of the unencrypted password in a password manager.

For example (MySQL repository):