1 2 Previous Next 22 Replies Latest reply: May 28, 2013 10:23 AM by 1004396 RSS

    Always asking password for XDB user

    rkonno
      Dear experts,

      I found a lot of similar question, but I unfortunately does not yet reach an exactly answer about the issue that the following dialog always is displayed when accessing sample application:
      ---
      The server oracle at XDB requires a username and password.

      Warning: This server is requesting that your username and password be sent in an insecure manor (basic authentication without a secure connection).
      ---

      How can I hide the dialog when accessing applications?

      My configuration is blow:
      Oracle Database 11g (11.1.0.6) Production Enterprise Edtion
      Oracle Application Express 3.1
      Using 'Embedded PL/SQL Gateway' for HTTP Server

      Following the manual, 'http://download.oracle.com/docs/cd/E10513_01/doc/install.310/e10496/toc.htm', I had done the steps below for HTTP Server:
      1. connect to db as sys as sysdba
      2. run @apex_epg_config c: because Oracle Application Express software was unzipped under c drive like c:\apex
      3. run ALTER USER ANONYMOUS ACCOUNT UNLOCK;
      4. run EXEC DBMS_XDB.SETHTTPPORT(8080);
      (5. Not documented but restart listener and database)

      After all required configurations,
      1. Log into to http://host:8080/apex/apex_admin
      2. Create a workspace, and admin user for the workspace
      3. Log into http://host:8080/apex using step2
      4. Go to Application Builder, and run pre-installed Sample Application
      5. Log into the sample application, and click a link
      The dialog always displays when clicking link.

      I would appreciate if anyone could give me any suggestions.

      Thanks,
      Rui
        • 1. Re: Always asking password for XDB user
          Jam2
          Hi,

          Did u resolve this issue?. I am also facing same issue. I am using apex 3.0 and 10g release2 enterprise edition.

          Regards
          JIJU
          • 2. Re: Always asking password for XDB user
            Rene W.
            It seems to be a IE7 warning. Don't know if you can get around this without using a secure connection.

            http://blogs.msdn.com/ie/archive/2006/03/15/552246.aspx

            Rene
            • 3. Re: Always asking password for XDB user
              636252
              Hi

              I ad the exact same problem.

              I used everything you wrote; no succcess

              and then I did

              alter user xdb unlock account;

              It now works fine.
              • 4. Re: Always asking password for XDB user
                454090
                I installed Apex 3.1 into 10g and then did exec dbms_xdb.sethttpport(8080).
                Also unlocked the xdb account and reset the password for xdb to "xdb".
                So how when i do http://localhost:8080, I can see the default page ( the one that lists the folders home, public, sys, xmlconfig.xml).
                However when I do http://localhost:8080/apex/apex_admin , again it pops up for the password .

                I do not know what to put in for this so I can then access Apex.

                Does anyone know how to get round this ?
                • 5. Re: Always asking password for XDB user
                  586714
                  Hello,

                  I had the same problem until I could solve it through the tip of "tkres" in the following thread:
                  Configuring PL/SQL Gateway: value for imgupg ?

                  Running apex_epg_config.sql I had not set the proper parameter. The docu is not very clear at that point.

                  Make sure you don't get the error "The system cannot find the path specified".
                  When I got rid of that error my problem was solved.

                  Good luck,
                  Roger
                  • 6. Re: Always asking password for XDB user
                    599201
                    If you wish to enable anonymous access to the ML DB repository, the following code creates the "<allow-repository-anonymous-access>" element if it is missing, or updates it if it is already present in the xdbconfig.xml file.

                    CONN sys/password AS SYSDBA

                    SET SERVEROUTPUT ON
                    DECLARE
                    l_configxml XMLTYPE;
                    l_value VARCHAR2(5) := 'true'; -- (true/false)
                    BEGIN
                    l_configxml := DBMS_XDB.cfg_get();

                    IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0 THEN
                    -- Add missing element.
                    SELECT insertChildXML
                    (
                    l_configxml,
                         '/xdbconfig/sysconfig/protocolconfig/httpconfig',
                         'allow-repository-anonymous-access',
                         XMLType('<allow-repository-anonymous-access xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd">' ||
                         l_value ||
                         '</allow-repository-anonymous-access>'),
                         'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'
                         )
                    INTO l_configxml
                    FROM dual;

                    DBMS_OUTPUT.put_line('Element inserted.');
                    ELSE
                    -- Update existing element.
                    SELECT updateXML
                    (
                    DBMS_XDB.cfg_get(),
                    '/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()',
                    l_value,
                    'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"'
                    )
                    INTO l_configxml
                    FROM dual;

                    DBMS_OUTPUT.put_line('Element updated.');
                    END IF;

                    DBMS_XDB.cfg_update(l_configxml);
                    DBMS_XDB.cfg_refresh;
                    END;
                    /
                    • 7. Re: Always asking password for XDB user
                      581382
                      Basically APEX images are stored within XMLDB, in order to access the XMLDB resources the appropriate ACL (Access Control List) assigned to the images directory need to have anonymous read-contents access otherwise (you guessed it) you are prompted for a username and password.

                      If you have note resolved this problem try this

                      Log into OEM,
                      select schema
                      select resources
                      select images and click edit
                      select the security tab
                      click edit (the file you should be editing is /sys/acls/ro_anonymous_acl.xml)
                      ensure you have the following:
                      principal: ANONYMOUS
                      privilege: read-contents
                      granted: ticked

                      click apply

                      restart the browser and retest APEX in this should resolve your XDB password problem.
                      • 8. Re: Always asking password for XDB user
                        614092
                        I have the same problem too!

                        I'm doing a fresh install of apex on Oracle 10gR2

                        Have completed the steps, but when it comes to loggigng in, I am prompted for an XDB password.

                        I've run the apxchpwd script to set the admin user.

                        I've run the epg_config script as so: @apex_epg_config /home/oracle/apex_3.1.2

                        the apex_3.1.2 directory contains the apex directory.

                        I thought that people seemed to be having problems when doing an upgrade, but a fresh install seems fraught too!

                        any more suggestions? I'm just about to drop the entire database and start again.
                        • 9. Re: Always asking password for XDB user
                          Arie Geller
                          Hello,

                          >> I'm doing a fresh install of apex on Oracle 10gR2… I've run the epg_config script

                          Using EPG with APEX is only being supported on Oracle XE or Oracle 11g. For APEX on Oracle 10gR2 you should use the Oracle HTTP Server (OHS).

                          Regards,
                          Arie.
                          • 10. Re: Always asking password for XDB user
                            666821
                            About version 10gR2 I think is not true. I use 10.2.0.3 OK I have the same problem with xdb user and password request, but after I give the username and password everything works fine.
                            • 11. Re: Always asking password for XDB user
                              Arie Geller
                              Hello,

                              >> I use 10.2.0.3 OK I have the same problem with xdb user and password request …

                              If you have a problem, it means that something is wrong in your system.

                              >> but after I give the username and password everything works fine.

                              Having a relatively simple solution to the problem still doesn’t make it right. You, or your users, shouldn’t have to enter any extra login credential, beside the APEX one. The only reason you need to enter a second password, to the XDB server, is that you are using it in an unsupported environment.

                              As I said before, using EPG is only supported on Oracle XE and Oracle 11g.

                              Regards,
                              Arie.
                              • 12. Re: Always asking password for XDB user
                                656315
                                Hi

                                Did you solve this issue?

                                Could you please tell me the solution if you already fixed it?

                                Thanks!

                                Jinfeng
                                • 13. Re: Always asking password for XDB user
                                  656315
                                  Hi

                                  It seems a lot of people got the same issue.

                                  Would that be a bug of APEX?

                                  I am running the APEX on top of Oracle Database 10g Release 10.2.0.1.0. But it always ask for the XDB username and Password before the APEX page is open.

                                  And I have done a lot of research, and tried a lot of approach. None of them works.

                                  So, I wonder if it is a bug for APEX.

                                  Thanks!!!

                                  Jinfeng
                                  • 14. Re: Always asking password for XDB user
                                    kristjan
                                    db 10.2.0.3 + 3.1.2.00.20 apex


                                    had the same problem. runned the script Pravednik posted above. working just fine now...      

                                    regards.
                                    1 2 Previous Next