In January I dropped a question about Apex_Listener and mixed HTTP/HTTPS content. Re: APEX Listener Feedback Mixed HTTP and HTTPS content when using SSL (&link to APEX_LISTENER issue)
Because I didn't have a satisfying answer I did some test with the latest Apex (4.0) & Apex_Listener (build 0.10.110.10.57).
- Apex_Listener with HTTP: Charts are OK
- Apex_Listener with HTTPS: Charts are NOK!
- OHS/mod_plsql with HTTP: Charts are OK
- OHS/mod_plsql with HTTPS: Charts are OK
As background info, I used the Apex 4.0 "Sample Application" that was "fresh" installed.
In the chart region the variable #HOST_PROTOCOL# is used and it isn't hardcoded anymore.
Because it works fine with the Oracle HTTP Server I assume that there is still a problem with the Apex Listener.
Depending on the brand of browser (Chrome, IE, FF) and internal settings the HTTPS chart load just hangs or complains with "No data found".
Is this a known bug of Apex_Listener and is there a workaround (not hard coding the macromedia calls off course).
If some body wants to test it, I have temporary a sandbox with the standard "Sample Apllication" available: http://gitsapx01.corp.global-it-services.eu:8888/apex/f?p=100:1 https://gitsapx01.corp.global-it-services.eu:8443/apex/f?p=100:1
(Please note that the HTTPS is based on a self signed certificate, your browser will complain about that :-)
I noticed a minor issue in Apex 4.0 when you open it as a developer in HTTPS.
After the initial logon it throws a warning like:
+>> "This page contains both secure and nonsecure items."+
+>> "Do you want to display the nonsecure items?"+
But I can live with that because it doesn't complain to end-users.
I have noticed the same issue as you. I have tested it with
apex_listener.220.127.116.11.43 on GlassFish Server Open Source Edition 3.0.1 (build 22) - listening on port 8181 and Tomcat 6.0.24 (listening on port 8443).
Also connections through standard SSL port 443 gave me any success.
All of time the CGI environment variable REQUEST_PROTOCOL has value of '/1.1' instead of 'HTTPS'.
Have anyone any idea how to resolve this issue or if it would be fixed in next release of apex_listener?
I verified your expecriences in my sandbox.
The (direct) EPG connection is temporary activated for this test.
In my opnion I believe that the REQUEST_PROTOCOL environment variable is resrverd for Apache-Mod_plsql-Dads.conf only.
As you I get "/1.1" as the result in AL. But in EPG it is "tcp".
See the output below for the details.
Anybody any idea?!? Plzzzz.
JB Apex Listener using HTTP: The content of owa_util.get_cgi_env('HTTP_REFERER'): http://gitsapx01.corp.global-it-services.eu:8888/apex/f?p=9500:1:2237926306889275 The content of owa_util.get_cgi_env('REQUEST_PROTOCOL'): */1.1* Apex Listener using HTTPS: The content of owa_util.get_cgi_env('HTTP_REFERER'): https://gitsapx01.corp.global-it-services.eu:8443/apex/f?p=9500:1:854227275158801 The content of owa_util.get_cgi_env('REQUEST_PROTOCOL'): */1.1* Embedded PLSQL Gateway & HTTP: The content of owa_util.get_cgi_env('HTTP_REFERER'): http://gitsapx01.corp.global-it-services.eu:7777/apex/f?p=9500:18
+The content of owa_util.get_cgi_env('REQUEST_PROTOCOL'): tcp+
I used p9976149 to upgrade Apex 4.0.1 and replace Apex Listener with the latest 18.104.22.168.38. Well I must say that I am quite disappointed.
The HTTPS issues with the failing graphical chars still exist!?!
It is very well possible that is caused by the fact that I still using Tomcat.
Can't go to Oracle Support, but before I go to install Oracle's/Sun's Puffer/Blow/Glassfish I like to hear from somebody else what his or hers experiences are?
Don't like to be forced to use software because of so called "smart" marketing.
Does somebody has positive results with charts & https in the latest Apex (Listener) version?
Were you able to reproduce these issues in Apex 4.0.1 & Apex_Listener (build 0.10.110.10.57) in your Glassfish environment?. Or are they resolved? Either way I am very interested to know!
I've not seen the garbled pictograph characters. If you have some that fail every time, put them in here.
This https thing is confisung me since I checked your instance of the sample app and the url for the xml is fine yet no content is delivered:
Is there anything in the log? Did you put the listener in debug to see if there was something there?