This content has been marked as final. Show 20 replies
1st, Thanks for you answer. After reading it I am almost sure that this will work and solve the problem. but I have an answer...
Where do I put this lines:
I can't find marvel.conf, neither dad.conf. I am using APEX without oracle http server installed, by using the database "gateway".
After reading some of the solutions and documentation on apache2, I came up with this vhost configuration (still a bit of work-in-progress I'm afraid) under linux (APEX is set to its default port 8080):
One problem with this solution is the ExtFilter, which could replace any 8080 occurrence in the returend website, but at least the graphs in the demo app are working again.
<VirtualHost *:80> ServerName yourdomain SetEnv force-proxy-request-1.0 1 ProxyRequests Off ProxyHTMLExtended Off ProxyPreserveHost On ExtFilterDefine fixtext mode=output intype=text/html \ cmd="/bin/sed s/:8080//g" ProxyPass /apex http://localhost:8080/apex ProxyPass /i http://localhost:8080/i ProxyPass /sys http://localhost:8080/sys <Location /apex> ProxyPassReverse http://localhost:8080/apex SetOutputFilter fixtext </Location> <Location /i> ProxyPassReverse http://localhost:8080/apex SetOutputFilter fixtext </Location> <Location /sys> ProxyPassReverse http://localhost:8080/apex SetOutputFilter fixtext </Location> </VirtualHost>
What an imaginative solution ;) -
extFilterDefine fixtext mode=output intype=text/html \But (and I haven't tested this yet), wouldn't that have a potential issue in that it could remove the string 8080 that was passed as part of a regular APEX url (since you're not just searching for the port), e.g. -
http://apex.shellprompt.net/pls/apex/f?p=4550:1:8080042265718416In this case it would remove the 8080 in the session?
To the OP, if you're using the Embedded PL/SQL gateway (I assume you're using XE or 11g, is that correct?), then you will need to look at the following document -
This shows you how you can make the equivalent setting for the DBMS_EPG.
Hope this helps,
Thanks for your answer! Yes we are using 11G. I suppose that the default dad name is 'APEX'. I've been exploring the dbms_epg package but i could not use the function to return the current value (as security measure before update it)
This does not work...
Can you help on that?
Here it is what i tried:
And the errors:
ORA-24232: o atributo do Gateway de PL/SQL Incorporado PlsqlCGIEnvironmentList é desconhecido
ORA-06512: na "SYS.DBMS_SYS_ERROR", linha 86
ORA-06512: na "SYS.DBMS_EPG", linha 101
ORA-06512: na "SYS.DBMS_EPG", linha 265
ORA-06512: na linha 2
And the translation:
ORA-24232: unknown Embedded PL/SQL Gateway attribute stringCause: The specified Embedded PL/SQL Gateway attribute was not known.
Can anyone help?
What an imaginative solution ;) -I know this one is rather old, but changing
extFilterDefine fixtext mode=output intype=text/html
But (and I haven't tested this yet), wouldn't that
have a potential issue in that it could remove the
string 8080 that was passed as part of a regular APEX
url (since you're not just searching for the port),
should do the trick.
The expression searches for ":8080/" and replaces it with "/".