2 Replies Latest reply on May 8, 2019 8:00 PM by Neil Taylor

    Still password for XDB asked after configuration of EPG

    Laury

      Hi,

       

      I have a user who want to have EPG configured to user APEX 19.1 on his laptop, for testing purposes.

      APEX 19.1 is installed on a PDB, but he still gets the pop up to login for XDB asking for user name and password.

       

      Logged as root on the database I have:

       

      SQL> show con_name

       

      CON_NAME

      ------------------------------

      CDB$ROOT

      SQL> col USERNAME for a20

      col ACCOUNT_STATUS for a30

       

              SELECT USERNAME

               , ACCOUNT_STATUS

            FROM DBA_USERS

          WHERE USERNAME IN ('ANONYMOUS','XDB'); SQL> SQL> SQL>   2    3    4

       

      USERNAME             ACCOUNT_STATUS

      -------------------- ------------------------------

      ANONYMOUS            OPEN

      XDB                  OPEN

       

      SQL>

       

       

      From the PDB, the HTTP port is configured:

       

      SQL> show con_name

       

      CON_NAME

      ------------------------------

      MAAT

      SQL> select dbms_xdb_config.gethttpport from dual;

       

      GETHTTPPORT

      -----------

             8088

       

      I have tried as root to execute:

       

      alter user ANONYMOUS identified by <password> account unlock;   

      alter user XDB identified by <password> account unlock;   

      grant create session to ANONYMOUS; 

       

      If I check the EPG configuration (from the PDB) by running epgstat.sql, I get:

       

      SQL> start $ORACLE_HOME/rdbms/admin/epgstat.sql

      +--------------------------------------+

      | XDB protocol ports:                  |

      |  XDB is listening for the protocol   |

      |  when the protocol port is non-zero. |

      +--------------------------------------+

       

      HTTP Port FTP Port

      --------- --------

           8088        0

       

      1 row selected.

       

      +---------------------------+

      | DAD virtual-path mappings |

      +---------------------------+

       

      Virtual Path                     DAD Name

      -------------------------------- --------------------------------

      /apex/*                          APEX

       

      1 row selected.

       

      +----------------+

      | DAD attributes |

      +----------------+

       

      DAD Name     DAD Param                DAD Value

      ------------ ------------------------ ----------------------------------------

      APEX         database-username        ANONYMOUS

                   default-page             apex

                   document-table-name      wwv_flow_file_objects$

                   request-validation-funct wwv_flow_epg_include_modules.authorize

                   ion

       

                   path-alias-procedure     wwv_flow.resolve_friendly_url

                   nls-language             american_america.al32utf8

                   path-alias               r

       

      7 rows selected.

       

      +---------------------------------------------------+

      | DAD authorization:                                |

      |  To use static authentication of a user in a DAD, |

      |  the DAD must be authorized for the user.         |

      +---------------------------------------------------+

       

      no rows selected

       

      +----------------------------+

      | DAD authentication schemes |

      +----------------------------+

       

      DAD Name             User Name                        Auth Scheme

      -------------------- -------------------------------- ------------------

      APEX                 ANONYMOUS                        Anonymous

       

      1 row selected.

       

      +--------------------------------------------------------+

      | ANONYMOUS user status:                                 |

      |  To use static or anonymous authentication in any DAD, |

      |  the ANONYMOUS account must be unlocked.               |

      +--------------------------------------------------------+

       

      Database User   Status

      --------------- --------------------

      ANONYMOUS       OPEN

       

      1 row selected.

       

      +-------------------------------------------------------------------+

      | ANONYMOUS access to XDB repository:                               |

      |  To allow public access to XDB repository without authentication, |

      |  ANONYMOUS access to the repository must be allowed.              |

      +-------------------------------------------------------------------+

       

      Allow repository anonymous access?

      ----------------------------------

      false

       

      1 row selected.

       

      SQL>

       

      But he still gets the pop up to login for XDB asking for user name and password.

       

      Does someone know where to investigate further?

       

      Thanks and Regards