APEX

Hello

Environment :

Oracle XE18c

APEX 18.2

ORDS 18.4

Centos Release 7.5

Has anybody installed the JasperReportsIntegration with Apache in front of Tomcat using SSL??

I have enabled SSL for Apache to listen for HTTPS requests on port 443

Tomcat talks to the Apache server via the AJP protocol on Port 8009. All traffic to Apache for the "/ords" folder will be redirected to Tomcat on port 8009, with no access to port 8080. As described in my Apache config section :

<VirtualHost *:443>

...

# proxy ORDS requests to tomcat

ProxyRequests off

ProxyPreserveHost On

\<Location "/ords">

    ProxyPass "ajp://localhost:8009/ords"

    ProxyPassReverse "ajp://localhost:8009/ords"

\</Location>

</VirtualHost>

After I deploy the JasperReportsIntegration.war to the Tomcat webapps directory, I want to understand how I invoke the JasperReportsIntegration homepage.

Do I

(A) Update my Apache config file with

<VirtualHost *:443>

...

# proxy ORDS requests to tomcat

ProxyRequests off

ProxyPreserveHost On

\<Location "/ords">

    ProxyPass "ajp://localhost:8009/ords"

    ProxyPassReverse "ajp://localhost:8009/ords"

\</Location>

\<Location "/JasperReportsIntegration">

    ProxyPass "ajp://localhost:8009/JasperReportsIntegration"

    ProxyPassReverse "ajp://localhost:8009/JasperReportsIntegration"

\</Location>

</VirtualHost>

and invoke via url https://bespokedbsolutions.com/JasperReportsIntegration

How does this effect the port parameter when calling from APEX with https?? Usually set to 8080 which I am not using.

OR

(B)

• Enable port 8080 via the firewall

• update server.xml file

• invoke via url https://bespokedbsolutions.com:8080/JasperReportsIntegration (As described in the installation guide)

Will this method effect my SSL access?

Regards

Ade