Does Apex_Listener resolve variable #HOST_PROTOCOL# correct in HTTPS? - ORDS, SODA & JSON in the Database

Hi everybody,
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 :-)
Best regards,
JB
PS.
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. 

Hello,
I have noticed the same issue as you. I have tested it with
apex_listener.1.10.179.10.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?
Best regards,
Piotr 

Hi Piotr,
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.
Regards,
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+ 

Has anyone come up with an answer to this? It is very important that we get this solved too. It is going to definitely halt our upgrade to apex 4.0 if this can't be fixed.
Michelle 

I see it and it'll be fix in the next push of the code to otn.
-kris 

Do you know about when that code update will be?
Thanks for your help,
Michelle 

I do know but I'm not allowed to tell. We can not give dates but it's not too far away.
-kris 

Kris, thx for the info!
JB 

anything new on this ?
Problem is a real showstopper...
.g 

Hoi Guys,
I used p9976149 to upgrade Apex 4.0.1 and replace Apex Listener with the latest 1.10.230.17.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?
Regards,
JB 

A patch for this was mentioned but not delivered 

Hi Piotr,
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!
Best regards,
JB 

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:
#HOST#apex_util.flash?p=&APP_ID.:1:&APP_SESSION.:FLOW_FLASH_CHART5_R#REGION_ID#
expands to:
http://gitsapx01.corp.global-it-services.eu:8443/apex/apex_util.flash?p=100:1:2878217115106373:FLOW_FLASH_CHART5_R830115739922903989_en&XMLCallDate=128267217389
Is there anything in the log? Did you put the listener in debug to see if there was something there?
-kris 

Found and fixed the protocol issue. patch coming soon.
-kris 

Kris,
Thanks for the feedback!
I'll wait (im)patiently! ;-)
Regards,
JB

Related

|Apex Listner and Custom Authentication

Hi All,
I have spent a long time looking through the forums and beyond, but cannot seem to get to the bottom of this.
I have recently installed Apex Listener (on glassfish) with Apex 4 and 10g on an XP box, and it all works fine. However, when I import an application that was developed using EPG, I cannot log into it, getting the following message:
Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
     Error      ERR-7621 Could not determine workspace for application (:) on application accept.
OK      The application uses custom authentication and authorisation, maintaining info in session.
I am suspicious that the environment will not let me store a cookie, but I'm not sure. It is a little frustrating, because I wanted to simply use the recommended default configuration for Apex 4. i.e. using the listener. However, now at customer site and just losing so much time on this.
Can anybody help?
thanks
paul 
I guess no one has the answer to this or even a thought ...
or nothing helpful at all.
Thats really disappointing.
I will have to go back to EPG or APache.
Why bother with the big hollbollo about the listener .... 
Hi PJ,
what is the exact version of APEX? And does your application use a page sentry function for custom authentication?
Does your application work when you call it through EPG/mod_plsql? Does only the APEX listener call fail?
Regards
Patrick
-----------
My Blog: http://www.inside-oracle-apex.com
APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
Twitter: http://www.twitter.com/patrickwolf 
Patrick
Thanks for the reply. The problem has been fixed when I upgraded to 4.0.2.00.07.
Paul

Apex Listener and Web Logic OALL8

Hi Guys,
We have the following setup:
DB - Oracle Enterprise 10.2.0.4.0
Application Express - 4.0.1
Apex Listener - 1.0.2.238.15.24
WebLogic - 10.3
The Apex Listener is configured with TNS Connection type and JDBC Driver Type is Thin.
This all works fine for a while then we start getting system unavailable, please try again later messages. Looking in the listener error messages there are two that show up when this starts happening:
1) No more data to read From Socket
2) OALL8 is in an inconsistent LGE
This then resolves itself after a while, works for a while then does it again.
I'm thinking this is connection related, in that the connection is becoming unuseable and then finally closes and its starts working again. The problem is the DBA cannot see any connections from the WL server even when its working fine, is this normal?
I'm struggling to find an answr to this, I;ve seen posts about jdbc versions which I'm waiting for the WL admin to get back to me about but nothing about the socket error really.
Can anyone help with this, any ideas whats going on?
Many Thanks
Andy 
The socket errors mean the connections was lost/kill/something. There's several reasons that could happen such as firewall, resource manager on the db, possible idle timeouts,.. Is there anything in the db that kills idle connections or has resource limits?
-kris 
Hi Kris,
I dont think its the database side as when we use the embedded web container we dont have this problem.
I've upgraded the jdk to the latest version and changed the WL domain to use this rather than jrocket, I'll update this thread as to what affect this has.
Cheers
Andy 
Hi Andy,
did you configure the embedded GlassFish to use TNS as well? If you configure the Listener on the WLS to use TNS, it uses the locally (on the WLS host) available Oracle Client (oci8), not JDBC. This explains why you don't see connections from the WLS. Perhaps your local client is responsible for the timeouts, or at leasts it helps to take a look at those connections...
-Udo 
Hi Udo,
I've tried both jdbc and tns with the embedded and the weblogic, I only get this problem with weblogic.
I'm getting memory errors now when trying to use the latest jdk rather than jrockit.
Cheers
Andy 
Hi Andy,
could it be that the deployment on your WLS is configured to use the global driver provided by the WLS rather than the one shipped with the Listner, or even with WLS connection pooling which is configured with timeouts that differ from the ones controlled by the Listener itself? I won't think this is a general issue with the APEX Listener.
-Udo

apex_admin page not found

Hello.
I have a problem with apex_admin page.
We updated apex to 4.1 version and updated listener to 1.1.3.
All listener pages (status, admin, configure) are working.
We can run apex on http://hostname:port/apex
But when we try to go to apex admin page on http://hostname:port/apex/apex_admin, we get:
not found
What could be the problem?
Thanks,
Regards 
What do the installation docs say the URL for the admin page is? 
Hi Dejan,
are you able to login to workspace "internal"?
And did you try to use the URL with a trailing slash, e.g. http://hostname:port/apex/apex_admin/ ?
If the answers to the previous questions are negative, could you please provide some additional information on your system? Db, previous APEX and APEX Listener version, upgrade workflow you executed... And did you receive any errors during the upgrade? Perhaps you still have the installation logs at hand for a review.
In general, this doesn't sound like an issue caused by something in APEX Listener, as I know it is capable to display the admin application.
-Udo 
Hello.
Thanks for your reply.
Trailing slash doesn't help.
The problem we have is, that we updated APEX to 4.1 - but updated to Runtime Environment by mistake.
So we executed apxdvins.sql script as described in installation documentation (3.8.1 Converting a Runtime Environment to a Full Development Environment).
Now we can develope application and everything works except admin page.
Regards,
Dejan
Edited by: DejanH on Jan 25, 2012 2:55 PM 
Hello Dejan,
runtime would have been my first thought if you hadn't claimed /apex would work...
Anyway, it would still be interesting to know whether you're able to login to workspace 'internal'. And can you determine if it's actually the alias /apex/apex_admin that fails or perhaps some of the redirects that come afterwards, i.e. which is the concrete URL you get the 404 for? Or do you even get a different status code?
-Udo

Error Error Processing Request. ORA-01403: no data found

To Whom It May Concern,
I am trying to install the APEX listener by either using WebLogic or the standalone mode, both to no avail. I went through all the installation steps with my DBA for the DB side of things and we got no error messages. When trying to configure the APEX listener either way, it's simply giving me the error in my post title once I setup my DB connection to the APEX_PUBLIC_USER schema. Has anyone ever seen this before? What is supposed to be in the APEX_PUBLIC_USER schema? When I look at mine it's empty, I see no objects, which seems a little off to me. Any help will be greatly appreciated because the documentation is pretty sparse and the error messages I'm seeing are far from insightful. One final thing to note is that the images seem to be working via the standalone mode, whereas with WebLogic it's not finding them because they're not displaying, but that's an issue I'll work on next as I'd like to first get APEX working with or without the images.
Thanks,
Josh 
Hi,
I am trying to install the APEX listener by either using WebLogic or the standalone mode, both to no avail.Which version of ApexListener? The installation steps for 1.1.x are different from those for 2.0 EA.
>
I went through all the installation steps with my DBA for the DB side of things and we got no error messages. When trying to configure the APEX listener either way, it's simply giving me the error in my post title once I setup my DB connection to the APEX_PUBLIC_USER schema. Has anyone ever seen this before? What is supposed to be in the APEX_PUBLIC_USER schema? When I look at mine it's empty, I see no objects, which seems a little off to me.
>
What you see is normal. The APEX_PUBLIC_USER schema is empty.
Have you unlocked the APEX_PUBLIC_USER account?
>
Any help will be greatly appreciated because the documentation is pretty sparse and the error messages I'm seeing are far from insightful. One final thing to note is that the images seem to be working via the standalone mode, whereas with WebLogic it's not finding them because they're not displaying, but that's an issue I'll work on next as I'd like to first get APEX working with or without the images.>
Getting to see the Apex pages, even to configure 1.1.x , will not be possible without the images folder.
Have you seen the ApexListener log file? For WLS it is the WLS logfile itself.
Cheers, 
Prabodh,
The version of APEX is 4.2 and the listener is 1.1.4.
Yes, I am able to sign-in to it using SQL*Developer.
I have not seen the ApexListener log file. Do you know which specific WLS logfile it is? One of the AdminServer logs?
Thanks,
Josh 
Ok, have the images working using WebLogic now. Had to re-create the i.war file while in the base directory of the unzipped apex.zip file so the path was correct to the images.
Also, if I go into WebLogic and look at my deployed APEX.war, when I click on any of the 'Testing' tab's links, they all give me the same error as listed in this post's title.
Josh 
A. Which is the HTTP Listener port on WLS where ApexListener is deployed? You have to use that port in the URL
B. Have you followed the steps outlines in the Installation Guide in About the Listener Configuration File -> Locating the Configuration File?
Cheers,
PS:
By default, the local server log file is located in the logs directory below the server instance root directory; for example, DOMAIN_NAME\servers\SERVER_NAME\logs\SERVER_NAME.log, where DOMAIN_NAME is the name of the directory in which you located the domain and SERVER_NAME the name of the server instance.
Edited by: Prabodh on Nov 28, 2012 12:17 PM 
A. 7001, I am using that port
B. Yes, I've followed all the manuals. The config I am seeing is in /tmp/apex/apex-config.xml
Another question, my 'APEX_040200' and 'FLOW_FILES' schemas are currently locked, should they be that way? Could this be causing the issue?
Thanks,
Josh 
Wow, I feel quite silly now. Turns out the DBA ran the run time only install script. We removed the DB install and ran the full development environment script and all is up and working.
Josh

Apex Listener 2.0.1 error 404 from SQL Developer

Hello,
we are using
weblogic 10.3.3
apex listener 2.0.1
sql developer 3.2.2
We try to access the apex listener via SQL developer and get a 404 error.
The adminlistener user is configured on weblogic, the deployment is running well.
We have additional deployments of apex listener 1.1 on the same weblogic server. I hope the parallel use of apex listener 2.0.1 and 1.1 is not the problem
How can I get access to the apex listener 2.0.1 from sql developer? 
In 2.0.0 the adminlistener user is NOT setup in WebLogic, please double check the relevant section of the 2.0.x Listener documentation:
http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/install.htm#CHDEICAI 
thanks, i now have configured as described in the manual.
But it's still not working. I now get an HTTP 401 unauthorized 
It'll be either:
- Provided the wrong credentials
- The role name supplied when setting up the user was mis-typed, it must be exactly (case sensitive): Listener Administrator
Turn on logging and supply the full stack trace if checking those does not address the problem
http://cdivilly.wordpress.com/2013/03/08/configuring-logging-in-oracle-application-express-listener-2-0-1/ 
ok thanks. the new errormessage HTTP 403 forbidden ...
I enabled debug.debugger in the default.xml .... where can I find the output of the logging in the weblogic? 
probably easier to add
<entry key="debug.printDebugToScreen">true</entry>
The stack trace will be included in the error page (not something to do on a production server though!)
The WLS log varies depending on version and your configuration, usually $DOMAIN_HOME/server/logs 
I had this kind of error messages as well..
please be informed that the listener requires a 1.6 version of java, not a 1.7 version !
regards,
Richard 
rima wrote:
I had this kind of error messages as well..
please be informed that the listener requires a 1.6 version of java, not a 1.7 version !
regards,
RichardHi Richard, that is not correct, while the minimum version that Listener supports is 1.6, it should work without problems against 1.7 as well. If you have encountered a problem with using JDK 1.7 please start a new thread (or point me at an existing thread that already discusses the issue) describing the problem you encountered. Please provide version numbers for listener, application server, jdk and OS. Please provide steps to reproduce the error.
Thanks,
Colm Divilly

Categories

Resources