If you need to access the Jedox In-Memory DB (OLAP) component of Jedox Web from Excel clients on different machines, you must update the
palo.ini and make the following changes to configuration files:
- Changes in the file
Change the entry http “127.0.0.1” 7777 to either http “” 7777 or http <SERVER-IP> 7777.
- If you enter a static IP other than 127.0.0.1, you also need to change other configuration files:
…\httpd\app\etc\config.php, the entry define(‘CFG_PALO_HOST’, ‘127.0.0.1’) needs to be changed to the Server IP used in palo.ini.
…\core\palo_config.xml, the entry <host>127.0.0.1</host> needs to be changed to the Server IP used in palo.ini.
- Changing the Jedox OLAP Server port:
Change the port entry http 127.0.0.1 7777 to the new port.
This change must also be made in
…\httpd\app\etc\config.phpfor the entry define(‘CFG_PALO_PORT’, ‘7777’);
…\core\palo_config.xmlfor the entry <port>7777</port>.
- The Jedox services need to be restarted after making these changes in order to apply these settings.
You can make these settings if you run Jedox on-premises, but they must not be changed in a Jedox Cloud environment. These changes are available for Jedox Web Connections Manager if the server IP is hard-coded in palo.ini as the only allowed IP from which other connections can connect to the In-Memory DB. If you use the Excel Add-in, make sure you set the connection to
http "" 7777 to make sure that all the users of the Excel Add-in can connect to the In-Memory DB.
Note: it is recommended to check the settings and ensure that the firewall is configured to let these ports communicate outside the server. This must be ensured when a connection from the outside is made to the server, either from Excel Add-in or another Jedox Server to the Jedox In-Memory DB. For more information on how to use the ports, see Jedox Web Connections.
Timeout for In-Memory DB requests when web services shut down
Jedox In-Memory DB requests can be canceled in the event of a web services shutdown after a determined time period, and client libraries can receive notification. After the defined timeout period, all active In-Memory DB requests will be cancelled. The timeout period is defined with a modification to palo_config.xml.
For example, the following modification to palo_config would specify a network timeout of 300 seconds:
<?xml version="1.0" encoding="utf-8"?>
<palo_configuration xmlns="http://www.jedox.com/wss" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">