Summary

In this article, we will explain how to create a PHP executor with the pgsql module installed and available for use when creating new scripts.

Prerequisites:

To implement this solution, following items are required:

• Administrative access to ProcessMaker.
• Docker command for the executor (provided in this article).

Solution:

1. Log on to ProcessMaker and click on the Admin option from the top menu. 
2. From the menu on the left, select Script Executor.
3. Click on the +Script Executor button.
   
   
   
   
4. In the Add New Script Executor window, enter a name for the executor and select the language as PHP.
   
   
   
   
5. Enter the following code in the Docker file section.  

RUN apt-get update -y \

  && apt-get install -y libpq-dev \

  && apt-get clean -y \

  && docker-php-ext-install pdo pdo_pgsql \

  && docker-php-ext-enable pdo_pgsql

6. Click the Save and Build button to save your changes.
   
   
7. A message displays confirming the completion of this procedure. Click the Close button to close this window.
   
8. The PHP with SQLSRV executor is now available in the list of languages when creating a new script.