Hi everyone,
I have some trouble with the password obfuscation in my dads.conf file. I have a working APEX installation with APEX 4.2.6 and OHS 12.1.3.0.0. My dads.conf file looks as follows:
Alias /i/ "/u00/app/oracle/product/middleware/Oracle_WT/ohs/images/"
<Location /apex>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword mypassword
PlsqlDatabaseConnectString localhost:PORT:SID ServiceNameFormat
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
</Location>
I now tried to obfuscate the password in the dads.conf file using the dads.conf file using dadTool.pl, which worked fine actually. But as soon as I restart the http server it is obviously no longer able to connect to the database as I get the following error in the ohs1.log file:
[2015-03-03T07:44:47.3320+01:00] [OHS] [ERROR:32] [OHS-9999] [mod_plsql.c] [client_id: CLIENT_ADDRESS] [host_id: HOSTNAME] [host_addr: HOST_ADDRESS] [tid: 139994261862144] [user: oracle] [ecid: 00545mffRyCBp2s5oj4EyY0002ZW00021m] [rid: 0] [VirtualHost: main] MODPLSQL-00052: mod_plsql: HTTP-401 ORA-1017 ORA-01017: invalid username/password; logon denied\n
When I now try to access APEX in the browser it asks me to provide a username and password to access the server. I can however, type in the credentials of the APEX_PUBLIC_USER and get successfully forwarded to the APEX login page. Does anybody know what might be missing here? I also have another installation running on OHS 11.1.1.7.0 where this works fine.
Thanks for your advice.