2.0 - Configuration File env.ini

Overview

In version 2.0.29 and later, ProcessMaker uses the configuration file env.ini for global settings which aren't available under the ADMIN menu.

Editing the env.ini file

Use a plain text editor to edit the configuration file located at:

<INSTALL-DIRECTORY>/workflow/engine/config/env.ini

It is generally found at:

Linux/UNIX:

/opt/processmaker/workflow/engine/config/env.ini

Windows XP/Server 2003:

C:\Program Files\ProcessMaker-2_X_X\processmaker\workflow\engine\config\env.ini

Windows Vista/7/8/Server 2008:

C:\Users\USERNAME\AppData\Roaming\ProcessMaker-2_X_X\processmaker\workflow\engine\config\env.ini

By default, the env.ini file has the following content:

Most of the settings can be enabled by setting them to 1 and disabled by setting them to 0. Settings which are strings should be enclosed in double quotation marks. Lines beginning with ";" (semicolons) are treated as comments and are ignored. Remove the semicolon to uncomment the setting.

Available Settings:

• debug_sql = 0|1

Set to 1 to log all SQL queries to the wf_<WORKSPACE>, rb_<WORKSPACE> and rp_<WORKSPACE> databases in MySQL. Default is 1. For more information, see MySQL Logging.

• debug_time = 0|1

Set to 1 to log the time for web requests to be processed by ProcessMaker. Default is 0. For more information, see Time Logging.

• debug_calendar = 0|1

Set to 1 to log information about calendars. Default is 0.

• wsdl_cache = 0|1

Set to 0 to disable the caching of WSDL (Web Services Description Language) function calls. The default is 1, so WSDL function calls are cached for up to 24 hours, which increases the reliability (especially if there are connection problems), but is a problem when needing immediate execution for debugging.

• memory_limit = "XM"

Set the maximum amount of memory available for each login session in ProcessMaker. Use "M" for megabytes, "K" for kilobyes and "G" for gigabytes. It is not recommended to set this value to less than "100M", which is the default. If generating large Output Documents, it may be necessary to increase this value. To set the memory_limit before version 2.0.29, seeIncreasing the maximum memory per session.

• time_zone = "zone"

Set the time zone for the ProcessMaker server. This setting determines the time zone used for all timestamps in ProcessMaker, such as the starting and ending time for cases. By default, the time zone is set to "America/New_York". A list of available timezones can be found at: http://php.net/manual/en/timezones.php

To set ProcessMaker's time zone before version 2.0.29, See Default Time Zone.

MySQL Logging

If the debug_sql option is set to 1 (or debug is set to 1), then every SQL query to the workflow (wf_<WORKSPACE>), rbac (rb_<WORKSPACE>) and report (rp_<WORKSPACE>) databases will be written in the following three log files:

Each line in the log files records SQL actions in the following format:

For example, here is the shared/log/workflow.log file for the "admin" user's login from the IP address 192.168.0.168:

Logging will noticeably slow down ProcessMaker's performance, so it is not suggested to use this option except for debugging. The log files are not automatically deleted, so they will continue to append new information (until the file system runs out of space). If SQL Logging is enabled for long periods of time, it is a good idea to periodically delete the log files so they don't occupy too much harddrive space.

Enabling MySQL Logging before version 2.0.29

To turn on MySQL logging before version 2.0.29, edit the file <INSTALL-DIRECTORY>/workflow/public_html/sysGeneric.php with a plain text editor. it can generally be found at:Linux/UNIX:

/opt/processmaker/workflow/public_html/sysGeneric.php

Windows, before ProcessMaker version 1.6-4260:

C:\Program Files\ProcessMaker\apps\processmaker\workflow\public_html\sysGeneric.php

Windows, in ProcessMaker version 1.6-4260 and later:

<INSTALL-DIRECTORY>\processmaker\workflow\public_html\sysGeneric.php

Change the value of the debug setting to 1 to turn on detailed SQL logging:

Time Logging

If the debug_time option is set to 1, then the time to process each web request will be logged in a file located at:

<INSTALL-DIRECTORY>/shared/log/time.log

Each line in the log file records the time to process a separate web request in the following format:

Note that the processing-time is in seconds and milliseconds, so a time of 1.309 means 1 second and 309 milliseconds. The URL-path does not include the protocol and IP/Domain address. Time Logging is a good way to discover the URLs and GET variables used in the different frames in the ProcessMaker interface.

For example, here is the shared/log/time.log file for running a case:

The client machine is running on 192.168.0.168 and the ProcessMaker server is running on 192.168.1.76 (the first two numbers of the IP address aren't displayed because of the network's netmask).