ORDS 3.0 and mod_plsql migration

Hi,

4d97797d-f5af-48dc-b59a-9c299e286db1 wrote:

 

No I don't have anything special in dad.conf, just database, user and password. Everything is in the same database but diferrent user so do I have to configure any mappings?

Normally in ords config I connect to the database as APEX_PUBLIC_USER.

By constructing URL I mean that in dad.conf I have specified location like:

<Location /pls/test>

So I can access this application under servername.domain.com/pls/test/test.home

Using ORDS I have to follow f?p=alias

So now I can access various apps like

servername.domain.com/ords/f?p=1

servername.domain.com/ords/f?p=2

I don't know how to go from this:

servername.domain.com/pls/test/test.home

to this:

servername.domain.com/ords/f?p=????

servername.domain.com/ords/test/test.home <- 404 not found

So maybe my real question was: how do I know an application id?

     This problem can be solved by using Apache HTTP Server as Reverse Proxy in front of ORDS + Oracle WLS.

     Refer the following similar thread : 2 applications on one website

     I tried the same thing(in my APEX configuration) with ORDS + Apache Tomcat with Apache HTTP Server as Reverse Proxy with following as my "httpd-vhosts.conf" (in Apache HTTP Server):

<VirtualHost *:80>
    ServerName abc.xyz.com
    ServerAlias abc.xyz.com
    ProxyPreserveHost On
    RewriteEngine On
    RewriteRule ^/$ /ords/f?p=100:LOGIN_DESKTOP [R=301,L]
    RewriteRule ^/bugs$ /ords/f?p=101:LOGIN [R]
    RewriteRule ^/projects$ /ords/f?p=102:LOGIN [R]
    ProxyPass /ords http://localhost:8484/ords
    ProxyPassReverse /ords http://localhost:8484/ords
    ProxyPass /i http://localhost:8484/i
    ProxyPassReverse /i http://localhost:8484/i
</VirtualHost>

     NOTE : You will need to enable the required modules before writing the above rules in Apache HTTP Server. "abc.xyz.com" is the server name also entered hosts.conf entry for it. You will need to play with the Apache Rewrite Rules to get a grip on it.

     So, whey I type http://abc.xyz.com/bugs it redirects me to 101 "Bug Tracker" sample application of my workspace and same for projects.

Regards,

Kiran

I don't know how to go from this:

servername.domain.com/pls/test/test.home

to this:

servername.domain.com/ords/f?p=????

servername.domain.com/ords/test/test.home <- 404 not found

For generic plsql gateway programs, you don't switch. In this new setup using ORDS, you have two options. One is using the single 'apex' connector. You do this by changing the login user from APEX_PUBLIC_USER to your normal DAD login and password. This is done either using the utility (java -jar ords.war install advanced) in which case when it prompts for PLSQL Gateway Setup you choose yes, and when it asks for username, you choose a different one than the default APEX_PUBLIC_USER.

Back to the "url change"

In this scheme, you would have "server.domain.com/ords/test.home" available if you setup just the default connector ONLY.

If you chose to migrate multiple DADs, then you can set them up each as connector, then URL map them into each connector. This is in the url-mapping.xml file

<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">

  <pool base-path="/test" name="test" schema-name="DAD_USER" />

  <pool base-path="/prod" name="prod" schema-name="DAD_USER" />

</pool-config>

Then you would have if your ords-config directory, $ORDS_CONFIG/ords/conf/

apex.xml

prod.xml

test.xml

Where prod.xml may look like:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

<properties>

<comment>Saved on Fri Sep 04 23:23:35 EDT 2015</comment>

<entry key="db.hostname">proddatabase.domain.internal</entry>

<entry key="db.password">@mypasswordhash</entry>

<entry key="db.servicename">PROD.domain.internal</entry>

<entry key="db.username">DAD_USER</entry>

<entry key="sqldev.name">prod</entry>

</properties>

Under this scenario, you could have difference instance connections.

server.domain.com/ords/test/test.home

server.domain.com/ords/prod/prod.home