Hi,
I have a test system (RHEL 4) that contains an Oracle Database 10g Enterprise Edition Release 10.2.0.1.0.
I have installed HTMLDB from the companion cd.
There were no errors while installing the HTMLDB software (not on the screen, nor in the install logs).
After installation there was a port conflict on tcp 6100, this caused my server logs to be full of
Dec 12 12:49:24 orclserv kernel: ip_conntrack: table full, dropping packet.
errors.
I was able to solve the port conflict by changing the following entry in
/u01/app/oracle/product/10.2.0/htmldb/opmn/conf/opmn.xml
<port local="6100" remote="6200" request="6003"/>
to
<port local="6101" remote="6200" request="6003"/>
Now, when I try to connect to http://192.168.0.102:7777/pls/htmldb/htmldb_admin I get the following error:
Forbidden
You don't have permission to access /pls/htmldb/htmldb_admin on this server.
Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at orclserv Port 7777
The apache logs show the following error:
mod_plsql: /pls/htmldb/htmldb_admin HTTP-403 ORA-1017
[oracle@orclserv logs]$ oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:
This is very strange because I am able to login with sqlplus using HTMLDB_PUBLIC_USER/mypassword.
I have changed the encoded password in marvel.conf to a plain password to make sure that it is correct but with no luck.
Here is my current marvel.conf file.
/u01/app/oracle/product/10.2.0/htmldb/Apache/modplsql/conf/marvel.conf :
---------------------------------------------------------------------
Alias /i/ /u01/app/oracle/product/10.2.0/htmldb/htmldb/images/
<Location /pls/htmldb>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlDatabaseConnectString 127.0.0.1:1521:orcl ServiceNameFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername HTMLDB_PUBLIC_USER
PlsqlDefaultPage htmldb
PlsqlDatabasePassword mypassword
Allow from all
</Location>
---------------------------------------------------------------------
I have installed HTMLDB on other database versions before, never had any problems.
I have reinstalled HTMLDB on this database, but with the same results...
I know that there are lots of other threads on this forum about the "don't have permission to access /pls/htmldb/htmldb_admin on this server" problem, but none of them contains the solution to my problem.
If anyone has any suggestions what might be wrong... all help is truly appreciated :-)
Thank You.
Pieter