Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Smart Card Access To OIM

697314Apr 21 2009
I am currently in the process of attempting to secure access to the OIM console by way of smart card. I have been successful in securing the OIM console with oracle access manager (OAM) using basic over ldap authentication.

As a means of moving to client certificate authentication these are the steps I have taken.

I have configured my JBOSS sever that hosts OIM to enable ssl on port 8443. I can successfully access the default JBOSS page over ssl using my smart card.
I have updated the corresponding policy in OAM to use client certificate authentication.
I also updated my ssl.conf.

<VirtualHost 134.251.218.152:443>
.
.
SSLEngine On
ProxyRequests off
ProxyPass /xlWebApp https://134.251.218.152:8443/xlWebApp/Logon.do
ProxyPassReverse /xlWebApp https://134.251.218.152:8443/xlWebApp/Logon.do
ProxyPreserveHost On
.
.
<VirtualHost/>

Note: http://134.251.218.152:443/xlWebapp is my protected resource in OAM

When I try to access https://134.251.218.152:443/xlWebapp I get an Internal server error. Looking at the logs it suggest I need to add the SSLProxyEngine directive.

[Wed Apr 22 00:18:41 2009] [error] SSL Proxy requested for 134.251.218.152:443 but not enabled [Hint: SSLProxyEngine]
[Wed Apr 22 00:18:41 2009] [error] proxy: failed to enable ssl support for 134.251.218.152:8443 (134.251.218.152)

However when I do this I am unable to restart my oracle http server and the following error is printed to the console

ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=822084805,pid=2016)
process crashed during restart
Log:
C:\oracle\HTTP_Server\opmn\logs\\HTTP_Server~1.log

When I look at the a fore mentioned log no errors are reported.

Any assistance with this matter would be greatly appreciated.

Comments

436063

Hi,

Hopefully this will solve your problem

vineet@ORCL>desc temp;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  VARCHAR2(30)

vineet@ORCL>select * from temp;

A
------------------------------
5500
554
5540
5539

Elapsed: 00:00:00.04
vineet@ORCL>l
  1  select * from
  2  (
  3  select * from temp
  4  where a in (
  5             select substr(dual_q.input, 1 , in_list.rn )
  6             from (
  7                       select input , length(input) ln
  8                             from (select '&input' input from dual)
  9                  ) dual_q,
 10                     (
 11                             select row_number() over (order by 1) rn from dual
 12                             group by cube(1, 2, 3,4, 5)
 13                     ) in_list
 14             where  dual_q.ln >= in_list.rn
 15     )
 16  order by 1 desc
 17  )
 18* where rownum < 2
vineet@ORCL>/
Enter value for input: 5544
old   8:                                from (select '&input' input from dual)
new   8:                                from (select '5544' input from dual)

A
------------------------------
554

Elapsed: 00:00:00.04
vineet@ORCL>/
Enter value for input: 55397
old   8:                                from (select '&input' input from dual)
new   8:                                from (select '55397' input from dual)

A
------------------------------
5539

Elapsed: 00:00:00.03
vineet@ORCL>/
Enter value for input: 55409
old   8:                                from (select '&input' input from dual)
new   8:                                from (select '55409' input from dual)

A
------------------------------
5540

Elapsed: 00:00:00.03
vineet@ORCL>

Vineet

146850
here is the magic for you.
SELECT MAX (column_a)
	   KEEP (DENSE_RANK FIRST ORDER BY LENGTH(column_a) DESC) magic_4u
  FROM t
 WHERE column_a IN (SELECT     SUBSTR (str, 1, LEVEL)
                          FROM (SELECT :input str
                                  FROM DUAL)
                    CONNECT BY LEVEL <= LENGTH (str))
for more SQL problems & questions, please visit
http://cafe.daum.net/oraclesqltuning
Laurent Schneider
keep it simple !
SQL> create table t as select '5500' a from dual
 union select '554' from dual 
 union select '5540' from dual 
 union select '5539' from dual;

Table created.

SQL> select max(a) a from t where '&input' like a||'%';
Enter value for input: 5544
A
----
554
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2009
Added on Apr 21 2009
0 comments
377 views