This content has been marked as final. Show 11 replies
Have you checked if one VM (apache) can connect to the other VM (apex) directly?
I can ping from one from the other - does that answer the question? I don't have a browser on either VM as they are the 'server' editions - and I didn't want to add any un-needed apps.
If I must for the sake of testing then I will - or is there another way?
Thanks for looking at it though,
PS - when I attempt to change the listener port (in SQL Plus) using the dbms_xdb.sethttpport('80') - it is successfull - but I then get this in the listener logs:
Error listening on: (Description=(Address=(Protocol=tcp)(Port=80)(Host=))(Presentation=HTTP)(Session=RAW))
Linux Error: 13: Permission denied
Message was edited by:
You could try to telnet from the apache VM to the XE VM and check if port 1521/8080 is available. Are there any firewall settings in any of the VMs?
Can't say I've encountered such an error message yet. What happens if you change the http port back to 8080?
I tried telnet and both 1521/8080 say:
Connected to 10.0.0.21.
Escape character is '^]'.
When I change it back, the listener starts normally for 8080...
I recommend to look at my post at:
How to configure Virtual Hosts in Oracle XE - Multiple Domain Names
That will explain how to get everything up & running in not time. I do have setup a Fedora 6 hosting different domains and parsing on each Virtual Domain different technologies like: PHP, Oracle APEX & Ruby on Rails applications for each virtual domain in the same machine =)
Good Luck D.
I read through your post, and I have tried many different methods mentioned, but I'm still not there yet... :`-(
Using the following in my virtual host config has gotten me close:
ServerAlias www.my-domain.ca *.my-domain.ca
SetEnv force-proxy-request-1.0 1
SetEnv proxy-nokeepalive 1
ProxyPass /IAG http://10.0.0.21:8080/apex
ProxyPass /i http://10.0.0.21:8080/i
ProxyPass /sys http://10.0.0.21:8080/sys
Allow from all
So I can go to my-domain.ca and see my html page, and I can then go to my-domain.ca/IAG and I get the Apex login page!!!
BUT, when I enter my credentials and click login, I get this as a URL:
and I am still at the login screen...
And when I log into Apex from a PC inside my network as Admin (workspace internal) and check Login Attempts - I see that my login attempt was
"Normal, successful authentication"
I am quite perplexed...
I did try using:
RewriteRule ^/IAG$ http://www.my-domain.ca/IAG/apex/ [R]
RewriteRule ^/apex/$ http://10.0.0.21:8080/apex/ [P]
RewriteRule ^/apex/(.*)$ http://10.0.0.21:8080/apex/$1 [P]
ProxyPass /IAG http://10.0.0.21:8080/
ProxyPassReverse /IAG http://10.0.0.21:8080/
instead of the above code, but www.my-domain.ca/IAG takes me to the Oracle License page (www.my-domain.ca/IAG/apex is the url). And if I add 'apex' to the end (www.my-domain.ca/IAG/apex/apex), I get a new URL of http://apex/apex/f?p=4550:1 and the Oracle login page, but with no images.
Message was edited by:
So, I have also found that I posted wrongly in the last post. If I put www.my-domain.ca/IAG in the url, I get a 404 error. But if I put /IAG/apex, I get the login page. I then tried putting in an application ID:
And I get the application login!!! And when I enter my credentials it works!!! All until I try to log out. When I log out, I get:
as the url...
Just configure this in your Apache Virtual Hosts :
RewriteRule ^/$ http://www.my-domain.ca/apex/ [R]
RewriteRule ^/apex/$ http://keops:8080/apex/f?p=100:1 [P]
RewriteRule ^/apex/(.*)$ http://keops:8080/apex/$1 [P]
ProxyPass / http://keops:8080/
ProxyPassReverse / http://keops:8080/
Allow from all
Don't worry about the /i /sys /IAG... when you configure a virtual host that will be the root of that domain... Note: Replace Keops with the name of your machine [ hostname -a ] assuming that OracleXE can work when opening an URL:
http://keops:8080/apex => Is a valid OracleXE Installation. otherwise you will have a problem with the images and is nothing to do with the Apache Proxy redirection is a problem with the Oracle Listener due to a wrong configuration of the /etc/hosts file.
Hope that get you going !!!.
Currently working: [ http://www.announcefree.com ]
Say, I've always had problems to display flash charts from APEX with just the Proxy settings. Does your config solve that?
no, it shouldn't.
You need to configure the DBMS_EPG for that.
If the Apache is for example running on www.myserver.de on port 80, you can use the following configuration:
Does that work for you?
BEGIN DBMS_EPG.set_dad_attribute ( dad_name => 'APEX', attr_name => 'cgi-environment-list', attr_value => 'HTTP_HOST=www.myserver.de:80'); END; / ### to remove: BEGIN DBMS_EPG.delete_dad_attribute ( dad_name => 'APEX', attr_name => 'cgi-environment-list'); END; /
Thanks Dietmar, I'll try it in the next few days and let you know.