Tags: apex, application, database, learning, login, mysql, oracle, process, prompt, running, sql, stil, xdb
XDB and APEX login prompt - Why?
We have been trying out Apex on an XE database. We have a small application running, but since we are stil in the learning process, we are looking at different sources for enlightment. I found Carl Backstrom site with export http://htmldb.oracle.com/pls/otn/f?p=11933:22:657419155728313::NO:RP::
and figured it would be a fine example. I could import it without problems. Unfortunately it references /i/carl/htmldb_examples, and I believe that XE is a bit different, there is no way you can tell where an uploaded image or css- ends up, it has to be referenced via #WORKSPACE_IMAGES#.
I fugured I could use ftp instead, so I created the virtual directories by
dbms_xdb.CreateFolder('/i/carl/) (and similar for subdirectories) and it worked - I could see the created directories by browsing http:/<my hostname>:8080/i.
Next thing I did was to alter the ftpport :dbms_xdb.setftpport(2100) and open a browserwindow on ftp://<my hostname>:2100/i/ and that worked well too. Next thing was simply - using drag'n drop - to move all Carl's gifs, css-files etc into the relevant directory and reset ftpport to 0.
It is all there - I can browse it.
The problem is now - we cannot acces our applications anymore!
If we do the usual http:/<my hostname>:8080/apex we are met by a login-prompt labelled XDB. We are able to bypass that by supplying a legal oracle user/password, but only to be met by yet another login-prompt labelled APEX and no way can we get past that, it inevitably ends in a large 'UNAUTHORIZED' message.
How did that happen? and can it be corrected? We've come to the point where we think about re-installing the entire XE instance, but our latest export is a couple of days old, so we would have som extra work to do.
It is the latest XE by the way - running version 10.2.0.1.0 and Apex 2.1
Hope somebody can help.
Leave a comment...
- 0 Comments